Download latest version here

Version 2.83 (16 May 201)

General

• Fixed: Multi-Proj including incorrect libs in C7.3 and up.

 

Version 2.82 (16 May 201)

General

• Clarion 8 maintenance release.

 

 

Version 2.80 (15 June 2010)

General

• Fixed duplicate symbol errors in Clarion 7.2 when compiling in LIB mode.

 

Version 2.79 (10 June 2010)

General

• Clarion 7.2 recompile.

 

 

Version 2.78 (21 January 2010)

General

• This release provides compatibility for Clarion 7.0 and 7.1
• _ABCLinkMode_=>1 set to 0 in C7.1 and C7.0 build for the LIB compile.
• OfficeInside 2 - modify and compile for C7.1 and 7.0.
• Ship pwutil.lib, and link at the project level.
• Changed projects to release mode to work around broken Assert function in Clarion 7.0. Fixes errors such as: "Assertion failed on line: 1461 in file pwcom.clw when calling ReplaceText".
• Fixed assert messages in Clarion 7.0, as a result of the broken Assert statement in C7.0. This only applies to Clarion 7.0, this bug is fixed in Clarion 7.1.
• Tested build for regression in Clarion 6 in Local and Standalone.
• Test build for regressions in Clarion 5.5 in Local and Standalone.

 

Version 2.77 (20 July 2009)

General

• Fixed: Fixed incorrect release dates and version number in the History doc.
• Fixed: Error in the C7 LIB that caused FM3 to not upgrade files.

 

Excel

• Fixed: CloseWorkbook method returning 0 incorrectly when no parameter was passed to specify the behaviour (the workbook was correctly closed, but the return value was incorrect).
• Fixed: RenameWorksheet()

 

 

Version 2.76 (14 July 2009)

General

• Fixed: Fixed incorrect release date for 2.74 in the History document.
• Fixed: Compatibility problems with OfficeInside and editable reports between various versions of Clarion
• Fixed: Long standing issue with the editable report classes and a potential conflict with FM3, which prevented files from upgrading in some cases.
• Changed: The Editable Report classes now ship as source code and are added at the project level. The underlying classes are contained in _oiABPROI.clw and oiABPROI.inc and the ReportGenerator interface is defined in oiABPROI.clw.

Word

• Fixed: Fixed the SpaceBefore and SpaceAfter options of the SetParagraphFormatting not working correctly.

 

Version 2.74 (06 July 2009)

General

• Fixed: OfficeInside is now compatible with Clarion 7 is both Local and Standalone modes.

Excel

• Fixed: The oiExcel.ExcelImport() method  was not correctly retrieving the filename from the user when no filename is passed. The method can be called with a blank file name, in order to prompt the user for the file to import:
  ExcelDoc.ExcelImport ('', ?Progress, numColumns, startRow)
• Added: Equates for passing to oiExcel.CloseWorkbook( ) to determine the save behaviour:
  oix:Default  equate(1)
  oix:DontSave equate(2)
  oix:Save     equate(3)
• Fixed: The oiExcel.ExcelImport() method was prompting to save the document before closing.
• Fixed: The oiExcel.ExcelImport() method stopping before importing all rows if the startRow parameter was passed.

 

Version 2.74 (19 June 2009)

  Outlook

• Fixed: The Contact HomeAddressStreet property was not being updated when the UpdateContact method was called to update the entire contact from a group (updating the individual property worked correctly, as did retrieving the value from the Outlook contact).

Version 2.73 (15 June 2009)

General

• Fixed a compile error when using the Editable Report templates in current build of C7 (5675). The SoftVelocity ReportGenerator interface changed in this release (ProcessText reverted to the C6 protoype). This resolves the "No matching prototype available" error in oiABPROI.clw on compilation.

 

Version 2.72 (11 June 2009)

General

• Documentation improvements, new navigation and menu system etc.
• Changed: The oiBase.NewObject() method now requires the passed pItem to have been allocated before calling it (previously it allowed a null pointer to be passed, which would result in errors).
• Fixed: Memory leak in the oiExcel object because of handles to interfaces not being freed.
• Fixed a problem with methods ignoring calls because of an incorrect flag being set on intialisation (prevented Mail Merge from working in 2.71).

Excel

• Added: New oiExcel.Replace procedure to provide additional find and replace parameters (string pFind, string pReplace, long lookAt=0, long searchOrder=1, long lookAt=2, long matchCase=0, long matchByte=0).
• Fixed: ReplaceText (): Changed internal calling to not pass the last two parameters (searchFormat and replaceFormat), neither of which was used. Also corrected one of the parameters being passed incorrectly.
• Changed: ReplaceText(): now returns True for success and False for failure.
• Changed: ReplaceText(): The replacement string may be an empty string, it is perfectly legal to replace a string with nothing (removing it)
• Added: New internal method GetCells() returns the Cells range object.
• Added: In Progress. Please do NOT use this method in this release. New Find() method for returning the position of a specific string of text. Supports searching in either direction, case sensitive or insensitive searches, searching for exact matches or the search phrase within the string etc. Returns the cell that the match was found at.
• Added: oiExcel.DisplayAlerts() method allows the display of messages from Excel to be enabled or disabled
• Added: oiExcel.EnableEvents() procedure (currently this is internal)
• Added: oiBase.ToCstring(*string s) method. Copies the contents passed string to a new cstring and returns a pointer to the new cstring.
• Added: oiExcel.RunAutoMacros() method that allows the auto macros built into a file to be run (Auto_Activate, Auto_Close, Auto_Deactivate, and Auto_Open macros)
• Added: oiExcel.GetWorkbooks(). Used internally (functionality will be exposed).
• Added: oiExcel.GetActiveWindow(). Used internally (functionality will be exposed).
• Deprecated: CountWorkbooks_LB()
• Deprecated: NewWorkbook_LB()

 

Version 2.71 (10 April 2009)

General

• C7 support update for Multi-Proj.
• C7 support - template includes the oiABPROI.INC, Fomin support,  Report target selector, WOWordReporterDeclaration, legacy class generation when necessary.
• C7 support - uses the additional parameter in the implemented IReportGenerator.ProcessString class in C7.

Outlook

• Outlook (UpdateContact) - Updated to support all of the properties, optimised the update code and added a new GetContactPropertyName method to return the name when passed the long value for a field.

 

Version 2.69 (11 September 2008)

General

• Clarion 7 compatible release.
• Updated documentation and reformatted the oiExcel class documentation for improved clarity and consistency.

Word

• Added/Fixed: The FindText() method now returns 1 when the text that was search for is found, and zero if it is not found, which is the documented behaviour. The method now checks the Found property of the Find member of the Selection object to determine whether the search was actually successful. Previously the FindText() method was actually returning whether or not execution was successful, and the return value was not related to the result of the Find.
• Fixed: The MailMergeSetDataSource was always returning 0, even when successful. It now returns 1 for success and 0 for failure.

Excel

• Added: GetCellBackgroundColor() method returns the background color of a cell or range of cells. Can be called as:
  curColor = oiExcel.GetCellbackgroundColor('', '')    ! Fetch the color for the currently selected cells
  curColor = oiExcel.GetCellbackgroundColor('A1', '')  ! Fetch the color for a specific cell
  curColor = oiExcel.GetCellbackgroundColor('D1', 'E7')! Fetch the color for the range of cells specified

 

 

 

Version 2.68 (16 July 2008)

Excel

• Added: Documentation Color Management in Excel and Cell Formatting. This is recommended reading.
• Fixed: A missing property in the Contact groups in the documentation.

General

• Documentation updates.
• Website pages were not correctly reflecting the version.

 

Version 2.67 (02 July 2008)

Word

• Changed: Removed the temporary InitSite method.

General

• Fixed: Incorrect style sheet in some of the documentation files.
• Added: The Microsoft Office Compatibility pack is now supported. Unfortunately the compatibility pack causes the incorrect version of Office to be reported, which was causing OfficeInside to specify the the Office 2007 format for spreadsheets, which the compatibility pack would be create, and convert as if it was an older binary Excel document, causing the document o become corrupt. This has been resolved in this release.
• Added: Error handling and logging to the email sending for Outlook.
• Important: With Outlook 2007 the Outlook Security model has changed. There are now three settings (accessible via Tools -> Trust Centre -> Programmatic Access):
  • "Warn me about suspicious activity when my antivirus software is inactive or out of date (recommended)".
    This setting does not appear to function correctly when most setups. Presumably it is meant to allow the antivirus software to determine whether access is allowed or not. Instead in every configuration tested it simply blocks all access, which means that sending mail will fail because the Recipient object cannot be retrieved. Outlook provides no indication of the failure, or the reason for it.
  • "Always warn me about suspicious activity".
    This setting operates in the same manner as the security model in Outlook 2003, except that it introduces an even more onerous warning dialog box on mail sending. First the user is prompted to allow access to 1, 5 or 10 minutes, then when an email is sent a warning dialogue is displayed (because the first dialog is actually a security flaw). The second dialog does not allow the user to continue immediately, but instead displays a progress bar for a few seconds before the button can be pressed. This means that utilities such as "ClickYes" can no longer be used.
  • "Never warn me about suspicious activity".
    This setting allows all applications access, much like in Office 2000 and XP.
  • Unfortunately all three of the settings are essentially useless - either they are overly onerous for the user, or they provide no protection against malicious software (even the option to always warn of suspicious activity can be overridden by malicious software). One solution to this is to install the free Advanced Security for Outlook from MAPILabs (http://www.mapilab.com/outlook/security/). This allows the user to choose whether an application is trusted when it tries to access Outlook. This approach only requires the user to allow (or deny) an application access once, which provides good protection, without any burden on the end user.

 

Version 2.66 (11 June 2008)

Word

• Added: Additional errortrapping and error handling code for document and object creation.
• Changed: Changed the way that the Tables object was retrieved to improve reliability when processing multiple documents in a row.

 

General

• Fixed: The Clarion 5.5 DLL that shipped with the 2.65 release was the 2.64 version.

 

 

Version 2.65 (4 June 2008)

Word

• Added: [Beta] New PrintOut method that exposes all the print settings available in Word. This uses the new
  • Background (optional). True to have the macro continue while Microsoft Word prints the document.
  • pAppend (optional). True to append the specified document to the file name specified by the OutputFileName argument. False to overwrite the contents of OutputFileName.
  • pRange (optional). The page range. Can be one of the following WdPrintOutRange constants: wdPrintAllDocument, wdPrintCurrentPage, wdPrintFromTo, wdPrintRangeOfPages, or wdPrintSelection.
  • OutputFileName (optional). If PrintToFile is True, this argument specifies the path and file name of the output file.
  • pFrom (optional). The starting page number when Range is set to wdPrintFromTo.
  • pTo (optional). The ending page number when Range is set to wdPrintFromTo.
  • Item (optional). The item to be printed. Can be one of the following WdPrintOutItem constants: wdPrintAutoTextEntries, wdPrintComments, wdPrintDocumentContent, wdPrintKeyAssignments, wdPrintProperties, or wdPrintStyles.
  • Copies (optional). The number of copies to be printed.
  • Pages (optional). The page numbers and page ranges to be printed, separated by commas. For example, "2, 6-10" prints page 2 and pages 6 through 10.
  • PageType (optional). The type of pages to be printed. Can be one of the following WdPrintOutPages constants: wdPrintAllPages, wdPrintEvenPagesOnly, or wdPrintOddPagesOnly.
  • PrintToFile (optional). True to send printer instructions to a file. Make sure to specify a file name with OutputFileName.
  • Collate (optional). When printing multiple copies of a document, True to print all pages of the document before printing the next copy.
  • FileName (optional). The path and file name of the document to be printed. If this argument is omitted, Word prints the active document. Available only with the Application object.
  • ActivePrinterMacGX (optional). This argument is available only in Microsoft Office 98 Macintosh Edition. For additional information about this argument, consult the language reference Help included with Microsoft Office 98 Macintosh Edition.
  • ManualDuplexPrint (optional). True to print a two-sided document on a printer without a duplex printing kit. If this argument is True, the PrintBackground and PrintReverse properties are ignored. Use the PrintOddPagesInAscendingOrder and PrintEvenPagesInAscendingOrder properties to control the output during manual duplex printing. This argument may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed.
  • PrintZoomColumn (optional). The number of pages you want Word to fit horizontally on one page. Can be 1, 2, 3, or 4. Use with the PrintZoomRow argument to print multiple pages on a single sheet.
  • PrintZoomRow (optional) . The number of pages you want Word to fit vertically on one page. Can be 1, 2, or 4. Use with the PrintZoomColumn argument to print multiple pages on a single sheet.
  • PrintZoomWidth (optional). The width to which you want Word to scale printed pages, in twips (20 twips = 1 point; 72 points = 1 inch).
  • PrintZoomHeight (optional). The height to which you want Word to scale printed pages, in twips (20 twips = 1 point; 72 points = 1 inch).
• Added: [Beta] new task insert and update properties for use with the InsertTask, UpdateTask and GetTask/GetTaskQ methods:
  • oio:TaskCategories equate(13)
  • oio:TaskCompanies equate(14)
  • oio:TaskComplete equate(15)
  • oio:TaskIsConflict equate(16) ! read only
  • oio:TaskDateCompleted equate(17)
  • oio:TaskTimeCompleted equate(18)
  • oio:TaskIsRecurring equate(19) ! read only
  • oio:TaskNoAging equate(20)
  • oio:TaskOwner equate(21)
  • oio:TaskPercentComplete equate(22)
  • oio:TaskSize equate(23) ! size in bytes, read only
  • oio:TaskStatus equate(24)
  • oio:TaskStatusOnCompletionRecipients equate(25) ! recipients who will receive notification on completion
  • oio:TaskStatusUpdateRecipients equate(26) ! recipients who will receive notification when the task is updated
  • oio:TaskTeamTask equate(27) ! set to true if this is a team task
  • oio:TaskTotalWork equate(28)
  • oio:TaskUnRead equate(29)

General

• Documentation Updates and improvements
• Internal class additions and cleanup, new generic COM classes and access methods
• New internal generic Get/Set and Call methods

 

 

Version 2.64 (04 April 2008)

Excel

• Added: GetFileName() method that returns the name and path of the file on disk that is currently open.
• Changed: The ReadCell method now supports up to 4096 characters rather than 255 characters. This limitation will be removed in a future release.
• Added: The .excelFileName property to the Excel editable report class. This stores the file name that Excel returned once the file is saved.

 

Word

• Added: GetFileName() method that returns the name and path of the file on disk that is currently open.
• Fixed: Editable Report: Removed an extraneous call to Update() to change the application visibility after an editable report was created, but the application has already been closed by the Kill() and the file opened (if chosen) in a new instance using ShellExecute.
• Added: The .wordFileName property to the Word editable report class. This stores the file name that Word returned once the file is saved.
• [Editable Reports] Added: If the FileName is blank for the report output then the user is prompted for a file name automatically.

 

General

• Note: There is an issue with compatibility with FileExplorer in Clarion 5.5 when in Local Mode (duplicate symbol errors). This is not an issue with Clarion 6 or 7 and only occurs in Local Mode in Clarion 5.5.
• Fixed: the csWord.ico and csExcel.ico icons were not always being linked into the project automatically for Editable Report use with the TargetSelector.
• Added: Multi-Proj support for automatically including required icons in the project.
• [Editable Reports] Fixed: The Excel and Word Editable report now uses the new excelFileName/wordFileName property to ensure the correct file name is always opened.
• [Editable Reports] Fixed:Removed an extraneous call to Update() to change the application visibility after an editable report was created, but the application has already been closed by the Kill() and the file opened (if chosen) in a new instance using ShellExecute.
• [Editalbe Reports] Added: Error handling and user information messages.
• Right Reports Integrations - CapeSoft Right Reports now supports outputting reports to fully editable Word and Excel documents using OfficeInside.
• General documentation cleanup and improvements.

 

Outlook

• Fixed: The DateReceived and TimeReceived properties contents were reversed when retrieving the list of messages.
• Added: SaveAs() method that allows the document to be saved to disk as a the following formats:
  • Microsoft Office Word format (.doc)
  • HTML format (.html)
  • iCal format (.ics)
  • MIME HTML format (.mht)
  • Outlook message format (.msg)
  • Outlook Unicode message format (.msg)
  • Rich Text format (.rtf)
  • Microsoft Office Outlook template (.oft)
  • Text format (.txt)
  •  VCal format (.vcs)
  • VCard format (.vcf)

 

 

Version 2.63 (02 January 2008)

Excel

• Added: ImportSetup() and ImportComplete() callback methods to allow the document to be modified before and after the actual import when using the ImportExcel() method.
• Fixed: The Report To Excel template was displaying a prompt to save the current sheet when used in versions of Office prior to 2007. The new version now supports all version of Office and correctly determines the version and saves the document appropriately.
• Added: Code for Excel and Word editable reports to check the version of Office being used do the file saving appropriately. Note: It is recommended that the file name is specified without a file extension, this will allow OfficeInside and the Office application to set the correct file extension (for example either .XLS or .XLSX).

General

• Additional documentation updates, converted the bulk of the documentation to using style sheets, removed inline and outdated attributes, reduced the document sizes, added new method documentation and improved existing documentation with full parameter lists and descriptions, examples etc.

 

Version 2.62 (11 November 2007)

Outlook

• Added a new GetEmailBody method to the Outlook object that is does not limit the size of the email body fetched, and returns the size required if the passed string reference is not large enough and the data has been truncated. The old method has a limit of 20,000 characters. This is the method that is now called in the example application.

 

Version 2.61 (17 October 2007)

General

• Fixed the GetOfficeVersion function which was returning the incorrect version of Office for versions prior to Office 2007. This was causing a problem in SendTo.

 

Version 2.60 (04 October 2007)

General

• Fixed the editable reports example and removed an unnecessary Message() statement, also added both Word and Excel functionality to both examples. This should have been fixed in the previous release but the incorrect example was fixed.
• Closed (cannot reproduce): Case 1582: Office Inside not working with Office 2003 SBE. OfficeInside has been tested using Office 2003 SBE under both Windows XP and Vista without any problems.
• Added: More documentation updates, fixed missing links in the new method listing, updated documentation for method, converted documentation to all CSS for styling to improve consistency and speed (reduced the page size).
• Added a GetOfficeVersion() method that returns the version of Office installed. This is particularly useful for determining whether Office 2007 (12) is installed and hence the default document format being used (.xlsx, .docx etc.)

Word

• Confirmed Behaviour: Case 1486: ReplaceText() has a 256 character limit in Word. This is an intrinsic limitation of MS Word, not of OfficeInside. The workaround is to use the Find method to find and select the text to replace, and then use the InsertText to insert text if more than 256 characters are needed. This has been documented for the ReplaceText method, along with the workarounds (such as putting your large string on the clipboard and calling MyWord.ReplaceText('LookFor', '^c', true). The 2-character string '^c' will be interpreted by Word as the Paste command.
• Fixed: Case 1367: GotoEndOfDoc doesn’t go to last character. The new GotoItem method that this calls fixes the various bugs and problems that existed with this method. The GotoItem can be use to go to the last line in the document, which will actually also go to the end of the document (selection moves to after the last line). Similarly going to the first line goes to the start of the first line (the beginning of the document).
• Fixed: Case 1366: GetFontSize returning invalid result - the GetFontSize method was returning a large integer rather than the correct font size.

Excel

• Added: Support for saving to the new XLSX format for the editable report templates. If now uses the default format specified by Excel, which ensures that the Compatibility dialog box is not displayed. It is recommended that you do not specify the file extension when specifying the file name, which allows Excel to pick the correct file extension based on the format used.

 

 

Version 2.50 (12 September 2007)

General

• Fixed the Editable Report templates for Word and Excel, they were not sharing the same TargetSelector object unless it was specified manually and with some configurations it was possible to have two independent TargetSelectors declared in a single procedure.
• More documentation updates for Word and Excel.
• Note: For the Word and Excel editable reports in Legacy you must have at least one of the SV report output templates added. For ABC this limitation does not apply. Full Legacy support will be added in a future release to remove this limitation.

Word

• Added: Two new methods for AutoFormat support for tables. This allows one of the built-in tables styles in Word to be applied to any table automatically. This also solves the problem under Word 2002 where an auto style is selected as default and that style is applied to any tables inserted. See the oiWord.TableAutoFormat() and oiWord.TableUpdateAutoFormat() method for more information.
• Added Auto Formatting support to the example application for tables, support all of the around 30 different styles.
• Closed: Case 1583: Cannot reproduce in the current build. oiWord.TableSetCellBold setting the style for the whole column. This is not reproducible, using either the oiWord.TableSetCellBold() method or the normal methods for setting the current selection to Bold, Italic etc. Also tested to ensure that the Toggle commands work as well as On/Off for styles. Test with bold, italic, underlined and combinations.
• Added: New FindText() method search for a string and selects the next instance found, allowing each instance of a string to be found and modified (the style changed, or the actual string changed etc.).
• Fixed: Case 1368: GotoItem method not working. This method has been completely replaced and now works for all of the options available. Also note that this method now works as expected, so a number of workarounds are no longer needed. See the new oiWord.GotoItem() documentation for more information.
• Confirmed Behaviour: Case 1486: ReplaceText() has a 256 character limit in Word. This is an intrinsic limitation of MS Word, not of OfficeInside. The workaround is to use the Find method to find and select the text to replace, and then use the InsertText to insert text if more than 256 characters are needed. This will be documented for the ReplaceText method.

Excel

• Closed: Case 1478: Cannot reproduce in the current build: SetCellFormat does not appear to be working fully. Test all possible cell formatting options, along with a large number of combinations. All are working correctly.

 

 

Version 2.40 (10 September 2007)

General

• Added a Clarion 7 build.
• New documentation and changes to the existing documentation. All method, properties and data types for Word and Excel are being documented and the documentation completely overhauled, in line with the new Outlook documentation.
• Fixed invalid tags and attributes in documentation, added accessibility, fixed non html encoded characters etc.
• Changed and Fixed the RecentFiles classes. They are now initialised only for Word and Excel (PowerPoint can also be made available) and they correctly list everything the the Recent Files list for both applications. The list and objects are initialised when the object is, and the list is available as soon as the application has started (directly after the call to the Init() method returns).
• Added a RecentFiles tab to both the Excel and Word examples that displays the Recent File list for each application.
• Major cleanup of the documentation, all documentation will be moved to XHTML 1.0 Strict, and use CSS for formatting. This will improve load performance, accessibility and consistency. A large number of errors, formatting problems and code issues have been fixed.
• Added a new section to the documentation indicating how to dynamically create OfficeInside objects using the New command. Important: If you New an OfficeInside object you must set the .disabled property to 1 before the call to the Init method or the call to Init() will not work, and subsequent calls to the methods of the object will not work.

Word

• Fixed the RecentFiles list, it was not returning the list of recent files due to an initialisation error.
• Note: Event handling is currently being worked on, it has not been enabled since OfficeInside moved to late bound in 1.40 Beta. Currently event handling is only working for Outlook.
• Added new event handling functions.
  • oiWord.EventStartup( )
  • oiWord.EventQuit( )
  • oiWord.EventDocumentChange( )
  • oiWord.EventDocumentOpen( )
  • oiWord.EventDocumentBeforeClose( )
  • oiWord.EventDocumentBeforePrint( )
  • oiWord.EventDocumentBeforeSave( )
  • oiWord.EventNewDocument( )
  • oiWord.EventWindowActivate( )
  • oiWord.EventWindowDeactivate( )
  • oiWord.EventWindowSelectionChange ( )
  • oiWord.EventWindowBeforeRightClick( )
  • oiWord.EventWindowBeforeDoubleClick( )
  • oiWord.EventEPostagePropertyDialog( )
  • oiWord.EventEPostageInsert( )
  • oiWord.EventMailMergeAfterMerge( )
  • oiWord.EventMailMergeAfterRecordMerge( )
  • oiWord.EventMailMergeBeforeMerge( )
  • oiWord.EventMailMergeBeforeRecordMerge( )
  • oiWord.EventMailMergeDataSourceLoad( )
  • oiWord.EventMailMergeDataSourceValidate( )
  • oiWord.EventMailMergeWizardSendToCustom( )
  • oiWord.EventMailMergeWizardStateChange( )
  • oiWord.EventWindowSize( )
  • oiWord. EventXMLSelectionChange( )
  • oiWord.EventXMLValidation( )
  • oiWord.ErrorEventDocumentSync( )
  • oiWord. EventEPostageInsertEx( )
  • oiWord.EventMailMergeDataSourceValidate2( )
  • oiWord.EventUnknown( )
• Changed: The oiWord.Update() method. The Option parameter was optional, but required in order for any code to execute. It is not an optional parameter and is no longer passed as such.
• Fixed: Case 1561: Opening and closing two instance of Word on two threads produces a normal.dot error. Can no longer reproduce this in the current release of OfficeInside.
• Fixed: Case 1470: TableSetInsideBordersLineStyle equates were incorrect and setting the style resulted in the style being set to the next one in the style list.
• Fixed: Case 1560: TableSetOutsideBordersLineStyle was not working at all, it is now correctly setting the table borders.
• Added: Case 1404: Add support for Document Protection. You can now Protect and Unprotect any document, including choosing the type of protect (read only, edit comments only, edit form fields only, make revisions only, or no protection). See the oiWord.Protect() and oiWord.Unprotect() method. A password is used if specified.

 

Excel

• New methods to for importing Excel files. Replaces the old ImportXLSFile() method. The new method is ExcelImport() and calls the new TakeImportRecord() callback method. No longer has any limitation on the number of columns imported, any number of columns can be imported.
• New ColumnName() method replaces the old GetColumnAddressFromColumnNumber() method removes the 26 column limit - column numbers up to 450,000 are now supported making this method quite future proof (Excel 2007 supports 16K columns and earlier versions supported 255 columns). The old method is deprecated, but will still be supported and simply calls the new ColumnName() method.
• Important: If you are using the 'Import XLS To TPS' control template (now called 'Import and Excel File') then you must move your code for processing each record from the old ImportXLSFile_TakeRecord() method to the new TakeImportRecord() method. Also note that instead of each column being passed as a parameter the columns are now passed using a queue.
• Fixed the RecentFiles list, it was not returning the list of recent files due to an initialisation error.
• New alignment options for oiExcel.SetCellAlignment:
  • oix:WrapText
  • oix:HorizontalAlignment
  • oix:VerticalAlignmentszMemberof
  • oix:Indent
  • oix:ShrinkToFit
  • oix:TextDirection
  • oix:Orientation
• In addition alignment equates for each of the options was added (see the SetCellAlignment() documentation)
• New documentation for SetPaletteColor() and GetPaletteColor(), including three examples, and an example of two complete procedures for implementing local color palette management. Fully documented how Excel uses colors and the difference between passing clarion color equates and actual color values using the oiExcel.InterpretClarionColorEquates property.
• SetCellNumberFormat() now supports any format and picture that Excel supports, also fully documented how to create custom pictures and formatting, and to use Excel to generate a picture for any possible format needed.
  

Outlook

• Added: New properties to the oioFolderItemsQType. This queue is used to store the contents of the folder in Outlook. The following properties are now available when using the oiOutlook.GetMailItemsQ() method. Note that the oioFolderItemsQType has changed to reflect the new properties. If you are using your own manually declared queues rather than the types provided by OfficeInside you will need to update your queue declaration. Please note that this is strongly not recommended.
  • Categories
  • Companies
  • FlagRequest
  • Importance
  • IsMarkedAsTask
  • LastModificationTime
  • LastModificationDate
  • ReceivedByName
  • ReceivedTime
  • ReceivedDate
  • ReplyRecipientNames
  • SentOnBehalfOfName
  • UnRead
• Fixed: Case 823: Address Book reading GPFs with more than 350 contacts. This error cannot be reproduced in the current release, even with far more than 350 contacts
• Fixed: Case 824:  Start Date and Start Time not read from Outlook when reading Tasks
• Added: New properties when reading Tasks to the oioTasksQType1 and oioTaskProperties structures (Writing to these properties will be supported in the next release.):
  • Categories
  • Companies
  • Complete
  • IsConflict
  • DateCompleted
  • TimeCompleted
  • IsRecurring
  • NoAging
  • Owner
  • PercentComplete
  • Size
  • Status
  • StatusOnCompletionRecipients
  • StatusUpdateRecipientsTeamTask
  • TotalWork
  • UnRead

 

Version 2.36 (23 July 2007)

General

• Fixed: Compile error (unresolved external) in C55. The DLL for C55 was not correctly compiled, and an old DLL was included in the install.

 

Version 2.35 (11 July 2007)

General

• Documented a number of DLL functions that can be called from anywhere within an application using OfficeInside (no object needs to be instantiated to call these functions). See the DLL Functions section.
• Exposed the oiBaseToDec() and oiDecToBase() DLL functions.

 

 

Version 2.34 (06 July 2007)

General

• When using the Excel.dontCloseOnKill or the Word.dontCloseOnKill option the instance of Word or Excel is now automatically made visible and the display refreshed (and automatic display refreshing enabled if it was disabled).
• Corrected the dates in the History for all releases in 2007 (they were listed as 2006).
• Updated the Editable Reports example. Clarified the options, redid window layout, provided new instructions etc. The example now demonstrates the different options setting the report target. The hand code required will be moved to template options.
• Added support for Multi-Proj

Word

• Updated documentation for the ScreenRefresh() method.
• New editable report template, generates all code needed, supports other report generators (such as those provided by SoftVelocity), allows the user target selection dialog box to be controlled etc.

Excel

• New editable report template, generates all code needed, supports other report generators (such as those provided by SoftVelocity), allows the user target selection dialog box to be controlled etc.
• New SaveAs method and documentation, now support specifying a file format to save the file as, which is useful for ensuring that a standard XLS file is saved with Office 2007, and ensuring that the Compatibility dialog is not displayed.

  

Version 2.33 (07 February 2007)

General

• The template now generates return values for method declarations that return values and correctly returns the parent's return value by default. Solves the "Function did not return a result" compiler warnings.
• Installer is now cryptographically signed by Capesoft Software (Pty) Ltd. Ensures the validity of the installer and avoids the "unsigned file" security warning. Also allows the installer to run correctly under Windows Vista.

Version 2.32 (07 February 2007)

General

• Fixed the dontCloseOnKill option for use with Word and Excel, it was allowing Word and Excel to close when Kill() was called and it had been set to a non zero value.

 

Version 2.31 (06 February 2007)

General

• Updated documentation to reflect newly added methods for spell checking etc. SpellCheckString, SpellCheckHtml, SpellWord. These method will be used to clean up the template generated spell checking. In addition they provide improved support and functionality.
• Added example code using SpellCheckString and SpellCheckHtml, which show how the methods work, as well as providing an example of spell checking a FileExplorer control.
• General documentation update (ongoing) to document every method and property, add examples for every method, document all parameters, return values and add cross referencing!
• New Properties sections added to Word and Excel docs, and new Methods tables added.

 

Version 2.30 (02 February 2007)

General

• New Office01.tpw for handling classes and objects, maintains backward compatability while supporting all possible parameters etc.
• Fixed template bug that was not generating parent called with pointer to typed queues corrected.
• Template: Added support for additional data types in the method declarations.
• Update the template that generates object and method declarations, and fixed a number of small issues.

Excel

• Documented the two templates to import from Excel. See the Import From Excel templates section.
• Udpated document, new example code for WriteToCell (shows how to export a table to an Excel file), clean up documentation example code, added syntax highlighting etc. Documentation will be overhauled as the Outlook docs have already been.
• New section in the documentation on class properties.
• New dontCloseOnKill property allows the OfficeInside object to be killed while leaving Excel open.

Word

• New SpellChecking methods.
• New method to check the spelling of all words in a string and to encapsulate spelling (CheckSpelling).
• Add a CheckSpellingHtml method to allow HTML to be spell checked.
• Added support for punctuation to the spell checker so that additional punctuation is not incorrectly determined as part of the word.
• Optimised spell checked and improve process speed of splitting the string into words, removing punctuation etc.
• Added support for ignoring URL Encoded characters in HTML.
• Added support for ignoring HTML Escape code such as  
• Additional documentation on Spell Checking and RTF controls, new FAQs, links in the docs and cross referencing etc.
• New dontCloseOnKill property allows the OfficeInside object to be killed while leaving Word open.

 

Version 2.21 (23 January 2007)

Excel

• Fixed the PrintMe() method wich stopped working the the previous release.

Version 2.20 (16 January 2007)

Word

• Fixed the MailMerge example in the Clarion 6 Demo, now uses a CSV file, fixed issues with dialog boxes displaying and problems reading the data from the file etc
• Case 1126: oiWord.InsertTable() fails when too many rows are specified (stops editable reports working):
  Fixed this using the Table.Rows.Add() method. Now the Tables.Add() call always adds a single row table, and Table.Rows.Add() is called in a loop to add the rest of the rows. No real speed difference and there is now no limitation on the number of rows being added. Although the MS Documentation for the Add() method of the Tables Collection seems to indicate that there is no limit to the number of added rows (other than the 32 bit signed integer being passed), all the examples provided seem to use the Table.Rows.Add() method in a loop, indicating that this appears to be a known (and ignored) behavior.
• Updated spell checking templates, fixed a potential problem with C55 and spell checking with RTF controls, where they were spell checked before any other controls.
• Created new C55 and C6 specific examples for spell checking, show the two different approach needed for RTF controls in the two different version.
• Added SetScreenUpdating() and ScreenRefresh() methods to allow screen updating to be turned off when writing data to Word (provides a small performance improvement) and ScreenRefresh() allows the screen to be refreshed manually.
• Updated documentation and began documentation rewrite.

Outlook

• Modified the Address Book example to use a queue declared in the data section. Although it is recommended that you use the data types provided for Contacts, Tasks, Appointments, Folders and Messages, the Clarion listbox editor does not allow you to populate the fields easily, and so to make the example easily modifiable we have opted to declare the queue as local data.

Excel

• Began rewrite of docs. This will be a full rewrite as has been done with the Outlook docs
• New Methods:
  • SetCalculations: Allows automatic calculation of each inserted or edited cell in Excel to be turned off. This can dramatically increase the speed of writing large numbers of cells to Excel, and once complete automatic calculation can be turned back on using the same method.
  • Calculate: Forces the values of all formulas in all open workbooks to be calculated. Useful if SetCalculations has turned off automatic cell value calculation and the values need to be calculated at some point.
  • SetScreenUpdating:Allows screen updating to be turned off and on in Excel. This can also dramatically improve performance when inserting large numbers of cells.
• The new methods for optimisation have been implemented in the editable report templates etc. to improve performance. This has provided a small improvement in output speed to Word, and a very large performance improvement in outputting to Excel (in some cases as much as a hundred times faster).

Other

• Added support for the Recent Files classes to the demo application
• Global and Local templates: cleaned up tabs, moved overlapping text, added descriptions to tabs, made RTF info version specific for C55/C6 etc.
• New utility functions:
  • oiDecToBase: Converts from a decimal (base 10) to any other base, for example Hexidecimal (base 16), binary (base 2) etc.
  • oiBaseToDec: Converts from any base to a decimal number. For example convert Hexidecimal or binary to decimal.
• New Classes for all the applications representing the Recently Used Files objects:
  • oiRecentFiles: Stores a list of recent files for all of the Office applications (Word, Excel, Powerpoint and Outlook). This class is automatically initialised when the main object is, and filled with a list of recent files, which can then be accessed by looping through the queue. The class also contains methods to refresh the queue, delete files, open files etc.
  • oiRecentFile: Class used by the RecentFiles class, and represents an individual file in the list. This class will typically not be accessed directly.
• New oiBase class that the original Office Inside classes inherit from, as well as the new child classes (such as RecentFiles). The oiBase class provides NewObject, CallMethod, GetProperty and SetProperty methods, and neatly encapsulates access to the properties and methods of the COM objects encapsulated by Office Inside. It is intended to also provide an interface for exposing COM objects that have not otherwise been exposed by Office Inside.
• Moved all functionality into the C55 compatible demo application. Functionality will no longer be split between C55 and C6 in the main Demo. For features that differ in C55 and C6 (or like editable report are only available in C6) separate examples will be include.
• Moved editable reports to a separate example.
• Editable reports no longer require either C6 EE or the SV Advanced Report Output Templates, they now only require Clarion 6. See the new Editable Report Example for the optional code to allow the use of editable reports without the SV templates.
• Editable reports now start hidden and only display when complete (if the template setting to display the document is turned on).
• Note: The RecentFiles class and other new base class method have very rudimentary document and will be fully documented in the next release. The RecentFiles class usage is demonstrated in the main OffDemo.app example application on the Word_Main window (procedure)

Version 2.11 :  (08 December 2006)

• New classes (to be documented and functional in the next release): RecentFile, RecentFiles
• New Data type (to be documented and functional in the next release): RecentFilesType
• Completely rewritten documentation for the Outlook class. Every single method, property, data type and equate have been documented. Quickstart sections showing how the objects work have been added, along with improved formatting and clarity. Every method has all parameters, the return values, related class properties, data types and equates listed, along with an actual example of its use. In addition every method now has a See Also section that cross references it with all related methods.

Version 2.10 :  (17 November 2006)

• Added support for spell checking RTF text boxes and RTF controls populated using the RTF template in both ABC and Legacy for Clarion 6.
• Added Clarion 5.5 RTF Spell Checking control template. In order to add spell checking to a Clarion 5.5 RTF control populate the 'Office Inside Spell Check for C55 RTF' spell checking control template onto the window for each RTF control that needs spell checking. This adds a "check spelling" button which then checks the spelling of the control. This is necessary simply because of the design of the C55 RTF control and class. See the section on C55 RTF Controls.
• Added support for FileExplorer and Office Inside on the same window and the same thread. There is now a "Activate compatibility with File Explorer" on the local extension of the Office Inside object. Tick this box only if you are using Office Inside on the same procedure as FileExplorer. If you are calling the Init method manually the you need to set the oiOffice.noComInit property of the object to 1 before calling the Init() method.
• Changes to the manner in which Office Inside is initialised to allowing another object or control outside of Office Inside to initialise COM. This allows the above feature of compatibility with File Explorer, but also allows the use of Office Inside with other COM objects that need to initialise the COM interface themselves.
• Add the first set of changes to the documentation. All objects, method, properties, data types etc. will be fully documented and the existing documentation enhanced to provide better examples, as well as better explanations of the method, their parameters, return types, requirements etc.
• Fixed: Spell check template used the an embed for alertkeys in Legacy that did not work in some instances. Simplified the code to use a single embed for both ABC and Legacy. Thanks to Jorge Alejandro Lavera for not only reporting this, but suggesting the solution too.

 
Version 2.01 :  (30 August 2006)

• Added support for Text Boxes on Editable Word and Excel reports.
• Updated documentation for oiOutlook.GetMailFoldersQ