Where do find the documentation for “44,34,76,1,2/5/6/9/13/9,0,true,true,true,false,false”?
Question title:
fileProps(1).Value =
Question text:
Where do find the documentation for “44,34,76,1,2/5/6/9/13/9,0,true,true,true,false,false”?
What is the question really about? What could the “fileProps” be - some array in Basic? Why wouldn’t you mention e.g. that the string in the question text is about CSV (and indeed, just typing CSV in LibreOffice Help’s Index would bring the relevant documentation)?..
Please upload the ful macro code here…
The basic code I’m working with is as follows:
sURL = fileProps(0).name=“FilterName” fileProps(0).value=“Text - txt - csv (StarCalc)” fileProps(1).Name = “FilterOptions” fileProps(1).Value =“44,34,76,1,2/ 5/6/9/13/9,0,true,true,true,false,false” starDeskTop.loadComponentFromURL(sURL, “_blank”, 0,fileProps())
I need to open this file with “Detect special numbers” checked. My efforts to find out which of the fileProps(1).Value = parameters would do that have not been successful. In fact, I cannot find what any of the parameters do.
Somewhere there must be documentation that details what “44,34,76,1,2/ 5/6/9/13/9,0,true,true,true,false,false” controls, and how to change them.
Sorry for brevity on my question - that was the result of my frustration.
NAL
Here is an another description. It is for the OpenOffice. Be careful, maybe something was changed by the developers of the LO.
https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options
This is what I wanted,
Many thanks,
NAL
LOL… The documentation, mentioned in the first comment, was updated to the newest development and is most complete and correct … but obsolete OOo documentation is “what I wanted”. Go figure…
Found this be searching for “Libre Office Text - txt - csv filter options”.