Re: [tdf-discuss] Macro Difficulties
Christian, You're right. My attempt to fool with options didn't work at first because I misidentified the file's character set, so I thought the csv in the filter name was significant and embarked on the quest to convert to CSV. Now that I have the right character set, everything works perfectly!!! I have put up a post on SAP's community network site to let others know it's possible to export from Business One to LibreOffice; hopefully it will help the switchers out there. I start my post off by publicly thanking you and Eduardo. If you'd like to see the post, it's at: http://scn.sap.com/thread/3325286 That post contains full instructions on how to modify AutoOpen.xls. But for those who want to cut right to the chase without reading it, here's the subroutine LibreOffice can use to open a tab-separated text file output by SAP Business One: Public Sub StarOpenTsvFile(tsvPath As String) Dim starDesktop As Object Dim url As String Dim doc As Object Dim parms(1) As New com.sun.star.beans.PropertyValue parms(0).Name = FilterName parms(0).Value = Text - txt - csv (StarCalc) ' Name is incorrect, but required parms(1).Name = FilterOptions parms(1).Value = 9,,65535,1 ' Tab seps, no string delim, UTF-16 charset, begin at line 1 starDesktop = createUnoService(com.sun.star.frame.Desktop) url = ConvertToUrl(tsvPath) doc = starDesktop.loadComponentFromURL(url, _blank, 0, parms) End Sub Thanks again! -- Charles -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Experimental UI for LibreOffice proposal
Your idea of a ribbon turned into a sidebar by 90° rotation imho is nothing else than the revival of the old (pre-Windows) Lotus 1-2-3 menu system. Pulldown-menus (and dialog boxes) are a far more advanced concept. Besides the issues with screenspace. A concept that could be a *lot* more useful imho would be to allow tearing off individual (sub-)menus and placing them as floating (or docked if the user prefers that) toolboxes next to the workspace. See typical graphics software or e.g. RagTime. When I was working in RagTime (or FrameMaker, but that was more than a decade ago), all I had on-screen besides the document itself and the pull-down menubar above were the listboxes with character and paragraph styles and very few other floating palettes. Hmmm, that sounds interesting. To be honest, I liked the image I picked, but I think that when starting, it makes sense to consider other designs. If it turns out you don't want a radically different toolbar, then my proposal is a bad idea. In fact what must be absolutely avoided is to create several different parallel GUIs (toolbars vs. pull-down menus) for the same functionality. If the primary GUI is not ergonomic then fix it. Don't add another, redundant GUI, this is just confusing. Use only pull-down menus, but allow them to be torn off as floating or docked palettes, at the choice of the user. Allow menu items to be text, icons or any combination of both (icons only is a toolbar then). Allow the menu contents to be edited by the user. Allow for definition of shurtcuts for all menu items by users, so that the complete GUI can be entirely used without ever using the mouse, which is important for proficient users. Get rid of those idiotic redundant assistants, wizards or whatever they are called, since they are just yet another parallel redundant GUI. Instead, restructure menus and dialog boxes to make them more ergnomic. A truely ergonomic GUI is necessarily visually spartanic. Application GUIs are work tools that have to follow the rules of ergonomics. They are *NOT* fashion objects. Sincerely, Wolfgang -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Re: Install path for LibreOffice under Windows
Hi Andras Andras Timar wrote On Mon, Mar 4, 2013 at 4:45 PM, Pedro lt; pedlino@ gt; wrote: So my question is: is there any reason that LibreOffice under Windows does not install to \LibreOffice\? Not really. AFAIK it is just a legacy setting. Default install location can be changed either from installer UI, or by the INSTALLLOCATION property from the msiexec's command line. All settings, registry keys etc. will accommodate automatically. Migration of extensions is a different issue, I'm not an expert of that. So in theory it would not be a problem changing this (for the Windows OS only) to default to an un-numbered folder. If \LibreOffice\ is the default folder, there is no need for extension migration at all. They are already where the program expects them, just like the User extensions. Enhancement request added to Bugzilla https://bugs.freedesktop.org/show_bug.cgi?id=62303 Best regards, Pedro -- View this message in context: http://nabble.documentfoundation.org/Install-path-for-LibreOffice-under-Windows-tp4041530p4043609.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Macro Difficulties
Hi Charles, *, On Wed, Mar 13, 2013 at 4:36 PM, Charles Jenkins cejw...@gmail.com wrote: You're right. My attempt to fool with options didn't work at first because I misidentified the file's character set, so I thought the csv in the filter name was significant and embarked on the quest to convert to CSV. Ah, OK :-) - teh csv filter is used synonymous for all character separated values, not specific to a comma, although that is the most used ones. One could argue whether tsv deserves a special mention or not, but you don't add hsv (hyphen separated) or all other kinds of other fileextensions Now that I have the right character set, everything works perfectly!!! I have put up a post on SAP's community network site to let others know it's possible to export from Business One to LibreOffice; hopefully it will help the switchers out there. I start my post off by publicly thanking you and Eduardo. Great to hear that it works, and of course thanks for sharing your findings with others! If you'd like to see the post, it's at: http://scn.sap.com/thread/3325286 Allow me some nitpicking :-) Public Sub StarOpenTsvFile(tsvPath As String) Dim starDesktop As Object Dim url As String Dim doc As Object Dim parms(1) As New com.sun.star.beans.PropertyValue parms(0).Name = FilterName parms(0).Value = Text - txt - csv (StarCalc) ' Name is incorrect, but required The name is of course correct, as that is what the filter is called. It is for text based (Text) Spreadsheets (StarCalc), most commonly with txt and csv extensions. It is not limited to comma separated files. I prefer to read csv as character separated, as that matches it much better, as multiple delimers, or also no delimter at all (when using fixed-width columns) can be used. It doesn't explicitly list tsv or other possible filename extensions though. parms(1).Name = FilterOptions parms(1).Value = 9,,65535,1 ' Tab seps, no string delim, UTF-16 charset, begin at line 1 having a pointer to documentation for these kind of magic strings is always nice to have :-) Otherwise: Thanks again for sharing the solution - too often one does just read Solved my problem, bye and doesn't get to know what the actual solution was, so thumbs up :-) ciao Christian -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
