Hi! I have some problems to find information about this. All I found after hours of searching are few examples that probably work in some situations but certainly not what I'm looking for,
The problem is that those examples contains a lot of anonymous numbers and stuff but no explanation what so ever what those numbers mean or where I can find the details. Here's the closest thing I came up with so far: Sub Main Dim HOME As String Dim DirName As String Dim FileName As String Dim Args(1) As new com.sun.star.beans.PropertyValue HOME="/home/<MyUserName>" DirName = HOME & "/Some/Path/" FileName = ConvertToURL(DirName & "/MyFile.csv") ' Get the latest results. Shell(HOME & "/bin/ScriptThatCreatesMyFile.sh", True) Args(0).Name = "FilterName" Args(0).Value = "Text - txt - csv (StarCalc)" Args(1).Name = "FilterOptions" Args(1).Value = "44,34,76,1,,0,False,True,True,False" StarDesktop.loadComponentFromURL(FileName, "_default", 2, Args()) End Sub Questions: Exactly what does ”44,34,76,1,,0,False,True,True,False” mean? Where can I find information about this? What is True? What is False? Why is something missing between two commas? Many questions come to my mind… Problems at the moment: 1. The code above seems to treat my file as comma separated. I need TAB only as separator. 2. The CSV file is imported to a new window. I want it to overwrite existing (old and outdated) information in columns A:D (without messing with my conditional and unconditional formatting) on Sheet 0. After som further experimenting I seem to have solved problem 1. It seems lik means Chr(44), which is a comma, and Chr(34) os a double quote. The following line gave me separate columns for every TAB: Args(1).Value = "9,,76,1,,0,False,True,True,False" But what does the rest mean? Chr(76)="L", which seems weird, so I guess the ”76” means something else. I wonder why this kind of information is so hard to find. For easy stuff, when no manual is needed, you can find tons of information, but when things are a bit more cryptic, when a manual is really, really needed, you can search for hours and find nothing, as it seems. Maybe I'm wrong, I actually hope I am, even if I would look stupid… :P Kind regards Johnny Rosenberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
