http://www.pitonyak.org/database/
Look at my random DB ramblings.... I don't remember if I have better coverage they're pretty in my primary macro book http://www.pitonyak.org/oo.php But I do explain them, but I cannot check the documents from my phone... Sent from BlueMail On Nov 20, 2017, 4:47 PM, at 4:47 PM, Johnny Rosenberg <[email protected]> wrote: >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: [email protected] >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 -- To unsubscribe e-mail to: [email protected] 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
