8/3/2023 0 Comments Openoffice scalcValueObject:=StarOffice.Bridge_GetValueObject ĬalcSheet.GetCellRangeByName('A1:A4'). SortFields:=StarOffice.Bridge_GetStruct('.TableSortField') reOffice vs OpenOffice Templates & Extensions Who uses LibreOffice Screenshots Download Download LibreOffice. So the whole code should be: StarOffice:=CreateOleObject('') In example that i found it is commented "you must specify which type of sequence is transmitted to SortFields property". ValueObject.Set('.TableSortField', SortFields) Forum francophone de support pour Apache OpenOffice, LibreOffice et dérivés de. It is a "Value Object" and must be set like this: ValueObject:=StarOffice.Bridge_GetValueObject Built-in wizards guide you through choosing and using a comprehensive range of advanced features. Newcomers find it intuitive and easy to learn, while professional data miners and number crunchers appreciate the comprehensive range of advanced functions. You can format sheets, cells, dates, time, numbers, text, charts, and many other. Calc is the free spreadsheet program you've always needed. The answer is: SortFields is not just a variants array. Calc offers advanced data and document formatting tools. If you dont have any versions of Microsoft Office, you can use OpenOffice Calc or LibreOffice Calc to open XLSB files. Hope this topic on SO will be googled a way more easily by people who stumbled into this issue. SortDescriptor:=StarOffice.Bridge_GetStruct('.PropertyValue') ĬalcSheet.GetCellRangeByName('A1:A4').Sort(SortDescriptor) Īs usual, solution came shortly after exposing the problem to the world :-) I've found an example from the depths of Internet. SortDescriptor:=VarArra圜reate(, varVariant) SortFields:=StarOffice.Bridge_GetStruct('.SortField') SOCalc:=SODesktop.LoadComponentFromURL('private:factory/scalc', '_blank', 0, VarArra圜reate(, varVariant)) ĬalcSheet.GetCellByPosition(0, 0).SetValue(2) ĬalcSheet.GetCellByPosition(0, 1).SetValue(1) ĬalcSheet.GetCellByPosition(0, 2).SetValue(4) ĬalcSheet.GetCellByPosition(0, 3).SetValue(3) SODesktop:=StarOffice.CreateInstance('.Desktop') OpenOffice Calc also uses the Open Document Format as its default, with only limited support for Microsofts XLSX format. System.SysUtils, Variants, ComObj, ActiveX Minimal reproducible example: program OpenOfficeCalcSortingIssue I tried to follow the examples in basic (from " Macros Explained"*) or C#, but still no result. I've spent several hours trying to sort data in OpenOffice Calc in Delphi.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |