[libreoffice-users] Re: unopkg error
Le 10/08/11 09:22, Lars Callenbach a écrit : Hello Lars, I have compiled an addin which works find under openoffice 3.2. Using either libreoffice 3.3 or 3.4 the following error message appears: ERROR: Fehler beim Hinzuf�gen von: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt Cause: Media-Typ konnte nicht ermittelt werden: file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt unopkg failed. Did you also try and install it on OOo 3.3 or OOo 3.4 beta ? The package framework for extensions changed during OOo 3.3.x development and this may be the reason why your extension is failing to install. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to use the command /msoreg=1 ?
2011/8/11 sobriquet c.sobriq...@gmail.com: My computer does not have Microsoft office installed; rather the minute Starter office is in place. I followed the instructions in the System Requirements and downloaded--mmsvc90.dll. My computer is running Win7, so I went to Programs--Accessories-- Command Prompt, where the screen shows C:\users\name_ I type the command /msoreg=1 at the prompt, and it refuses to acknowledge it. What went wrong? Tks, Sobriquet And exactly where comes LibreOffice into the picture? Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macro not active when the document start
2011/8/10 Cor Nouws oo...@nouenoff.nl: toto wrote (10-08-11 09:23) I'm using macro's function and it doesn't start when the document start. You can change that via Tools Customize Events. Find the OnOpen event and link it to the macro for the document. I think the function is supposed to be used as a cell function. Then the event thing is not needed. Regards Johnny Rosenberg ジョニー・ローゼンバーグ Regards, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macro not active when the document start
2011/8/10 toto t...@nurulfikri.com: I'm using macro's function and it doesn't start when the document start. It would start if I change the value of the variabel at the function. The code is to change numeric value to string. If I execute the code: ubah(123) the result is seratus dua puluh tiga. Any idea how to make the function executed when I open the document? The macro is used as a cell function right? In that case, where did you put the macro? It should be placed in My Macros, I think, so you need to move it there if it's not there already. Regards Johnny Rosenberg ジョニー・ローゼンバーグ The code is: Public Function ubah(x as currency) as String Dim triliun As Currency Dim milyar As Currency Dim juta As Currency Dim ribu As Currency Dim satu As Currency Dim sen As Currency Dim baca As String If x 1 Then gusti = Modul belum tersedia saat ini Exit Function End If 'Jika x adalah 0, maka dibaca sebagai 0 If x = 0 Then baca = angka(0, 1) Else 'Pisah masing-masing bagian untuk triliun, milyar, juta, ribu, rupiah, dan sen triliun = Int(x / 1000 ^ 4) milyar = Int((x - triliun * 1000 ^ 4) / 1000 ^ 3) juta = Int((x - triliun * 1000 ^ 4 - milyar * 1000 ^ 3) / 1000 ^ 2) ribu = Int((x - triliun * 1000 ^ 4 - milyar * 1000 ^ 3 - juta * 1000 ^ 2) / 1000) satu = Int(x - triliun * 1000 ^ 4 - milyar * 1000 ^ 3 - juta * 1000 ^ 2 - ribu * 1000) sen = Int((x - Int(x)) * 100) 'Baca bagian triliun dan ditambah akhiran triliun If triliun 0 Then baca = ratus(triliun, 5) + triliun End If 'Baca bagian milyar dan ditambah akhiran milyar If milyar 0 Then baca = ratus(milyar, 4) + milyar End If 'Baca bagian juta dan ditambah akhiran juta If juta 0 Then baca = baca + ratus(juta, 3) + juta End If 'Baca bagian ribu dan ditambah akhiran ribu If ribu 0 Then baca = baca + ratus(ribu, 2) + ribu End If 'Baca bagian rupiah dan ditambah akhiran rupiah If satu 0 Then baca = baca + ratus(satu, 1) End If 'Baca bagian sen dan ditambah akhiran sen If sen 0 Then baca = baca + ratus(sen, 0) End If End If ubah = UCase(Left(baca, 1)) LCase(Mid(baca, 2)) End Function Function ratus(x As Currency, Posisi As Integer) As String Dim a100 As Integer, a10 As Integer, a1 As Integer Dim baca As String a100 = Int(x * 0.01) a10 = Int((x - a100 * 100) * 0.1) a1 = Int(x - a100 * 100 - a10 * 10) 'Baca Bagian Ratus If a100 = 1 Then baca = Seratus Else If a100 0 Then baca = angka(a100, Posisi) + ratus End If End If 'Baca Bagian Puluh dan Satuan If a10 = 1 Then baca = baca + angka(a10 * 10 + a1, Posisi) Else If a10 0 Then baca = baca + angka(a10, Posisi) + puluh End If If a1 0 Then baca = baca + angka(a1, Posisi) End If End If ratus = baca End Function Function angka(x As Integer, Posisi As Integer) Select Case x Case 0: angka = Nol Case 1: If Posisi = 1 Or Posisi 2 Then angka = Satu Else angka = Satu End If Case 2: angka = Dua Case 3: angka = Tiga Case 4: angka = Empat Case 5: angka = Lima Case 6: angka = Enam Case 7: angka = Tujuh Case 8: angka = Delapan Case 9: angka = Sembilan Case 10: angka = Sepuluh Case 11: angka = Sebelas Case 12: angka = Duabelas Case 13: angka = Tigabelas Case 14: angka = Empatbelas Case 15: angka = Limabelas Case 16: angka = Enambelas Case 17: angka = Tujuhbelas Case 18: angka = Delapanbelas Case 19: angka = Sembilanbelas End Select End Function -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] unopkg error
Hi Jay, I have modified the QuantLib addin code so that it runs under Linux and Windows XP (using Openoffice 3.2.1). Under Libreoffice the code compiles and the oxt file will be created but loading of the addin (using the oxt file) fails with an error message under Linux. Was there any change in the api of Libreoffice? What do I have to change/add to get a working addin? Is there any documentation or are there any C++ addin examples that can be used? The examples in the SDK (code examples under $SDK/examples/cpp) are not helpful. It seems that there have been no changes. So I expect that the code for the Quantlib addin need not be modified. Any ideas? Regards, Lars Lars, On Wed, 2011-08-10 at 09:22 +0200, Lars Callenbach wrote: Hello, I have compiled an addin which works find under openoffice 3.2. Using either libreoffice 3.3 or 3.4 the following error message appears: ERROR: Fehler beim Hinzuf�gen von: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt Cause: Media-Typ konnte nicht ermittelt werden: file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt unopkg failed. The directory CalcAddins.oxt has not been created and the oxt file has not been unziped. What do I have to change to get a working addin using libreoffice? Regards, Lars -- NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! Jetzt informieren: http://www.gmx.net/de/go/freephone I would check OOo to see if they have an updated version and check http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List and http://wiki.documentfoundation.org/Downloads/Templates . Plugins, unless they are official ones, may lag the release somewhat some if they need significant changes they may not work with the latest version. -- Jay Lozier jsloz...@gmail.com -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Macro not active when the document start
Am 11.08.2011 10:30, Johnny Rosenberg wrote: The macro is used as a cell function right? In that case, where did you put the macro? It should be placed in My Macros, I think, so you need to move it there if it's not there already. Wrong. It has to be stored in library Standard, either the document's one or the global one. Standard is loaded automatically and a cell function will be found immediately. The functions do not contain any references to UNO objects so they *should* work right from the start and they *should* update automatically if menu:ToolsCellContentsAutomatic Calculation is enabled and if (and only if) a referenced value has been modified. Otherwise recalculation should be triggered on key F9. Ctrl+shift+F9 enforces a complete recalculation of the whole workbook. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] New Custom Style in Writer - odd behavior
From: john d. herron paradox.her...@bluewin.ch To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 4:12:48 Subject: [libreoffice-users] New Custom Style in Writer - odd behavior Aug 07, 2011; 8:42pm - john herron wrote: I created a style (Default_2, next style also Default_2) which I based on the standard Default style. The only difference between the two is that Default has single line spacing whereas for Default_2 calls for double spacing. When I assign Default_2 to a paragraph from Styles and Formatting, it properly displays double-spaced. But when I then finish editing the paragraph with Return (or Enter, if you prefer that), the paragraph reverts to single space. The same also occurs with an indenting style (Def_2_Ind_1) derived from Default_2. Am I doing something wrong or could this be a bug? TIA john Aug 08 Simon Cropper (The foss Workflow Guides) Aug 08, 2011; 12:49am replied: Try not using the underscore. So rename Default_2 to Default2 or DefaultDouble and see what happens. -- Cheers Simon Simon Cropper Website Administrator http://www.fossworkflowguides.com - Hello, Simon Cropper. I tried following your suggestion to not use _ as a style name separator (i.e. renamed the style Default2) but to no avail. Closing the double-spaced Default2 paragraph with Return/Enter still causes the paragraph to revert to single-spaced. Why do I suspect that this behavior might be a bug? Because in OOo's 3.2 Writer, which I also use, the problem does not occur. What now? john Hi :) The guide for posting a bug-report http://wiki.documentfoundation.org/BugReport can give soem useful advice but if you can't find out all the info it asks for don't worry, just post anyway. You can always add info later. Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Date Format in Writer
To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International .mm.dd format included as an option (default?) in the fields for Writer? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] unopkg error
Hi :) Is the QuantLib addin/add-on/plug-in/extension released under a copy-left License such as GPL, LGPL, MPL or something like that? Are you happy to release your updated one under a copy-left so that anyone can modify and redistribute the code in an OpenSource way? If so then it might be a good idea to join the devs list and/or post a bug-report about the add-on to see if you get any helpful suggestions from other devs. http://wiki.documentfoundation.org/BugReport Good luck and many regards from Tom :) From: Lars Callenbach lars.callenb...@gmx.de To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 9:23:53 Subject: Re: [libreoffice-users] unopkg error Hi Jay, I have modified the QuantLib addin code so that it runs under Linux and Windows XP (using OpenOffice 3.2.1). Under LibreOffice the code compiles and the oxt file will be created but loading of the addin (using the oxt file) fails with an error message under Linux. Was there any change in the api of LibreOffice? What do I have to change/add to get a working addin? Is there any documentation or are there any C++ addin examples that can be used? The examples in the SDK (code examples under $SDK/examples/cpp) are not helpful. It seems that there have been no changes. So I expect that the code for the Quantlib addin need not be modified. Any ideas? Regards, Lars Lars, On Wed, 2011-08-10 at 09:22 +0200, Lars Callenbach wrote: Hello, I have compiled an addin which works find under OpenOffice 3.2. Using either LibreOffice 3.3 or 3.4 the following error message appears: ERROR: Fehler beim Hinzuf�gen von: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt Cause: Media-Typ konnte nicht ermittelt werden: file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt unopkg failed. The directory CalcAddins.oxt has not been created and the oxt file has not been unziped. What do I have to change to get a working addin using LibreOffice? Regards, Lars -- NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! Jetzt informieren: http://www.gmx.net/de/go/freephone I would check OOo to see if they have an updated version and check http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List and http://wiki.documentfoundation.org/Downloads/Templates . Plugins, unless they are official ones, may lag the release somewhat some if they need significant changes they may not work with the latest version. -- Jay Lozier jsloz...@gmail.com -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Date Format in Writer
Hi :) Good plan. It sounds like an Easy Hack and posting bug-reports like that can help people learn how to write code for LibreOffice. So, please post a bug-report http://wiki.documentfoundation.org/BugReport Good luck and regards from Tom :) From: rjw...@phonecoop.coop rjw...@phonecoop.coop To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 10:11:57 Subject: [libreoffice-users] Date Format in Writer To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International .mm.dd format included as an option (default?) in the fields for Writer? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to use the command /msoreg=1 ?
Hi :) I think you don't need the / at the start of a command like that. Try msoreg=1 However, i have no idea what that command does or what it is supposed to do so please double check what the command is supposed to do and don't just blindly accept some random unofficial guide, blog or forum post, especially about Windows. Even googling for the command might give some insight into what it really does. It would help if you could give us the link to the guide you are following. We only really deal with LibreOffice here but some kind person might be willing to try to help. Good luck and regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 9:23:44 Subject: Re: [libreoffice-users] How to use the command /msoreg=1 ? 2011/8/11 sobriquet c.sobriq...@gmail.com: My computer does not have Microsoft office installed; rather the minute Starter office is in place. I followed the instructions in the System Requirements and downloaded--mmsvc90.dll. My computer is running Win7, so I went to Programs--Accessories-- Command Prompt, where the screen shows C:\users\name_ I type the command /msoreg=1 at the prompt, and it refuses to acknowledge it. What went wrong? Tks, Sobriquet And exactly where comes LibreOffice into the picture? Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: unopkg error
Le 11/08/11 10:23, Lars Callenbach a écrit : Hi Lars, I have modified the QuantLib addin code so that it runs under Linux and Windows XP (using Openoffice 3.2.1). Under Libreoffice the code compiles and the oxt file will be created but loading of the addin (using the oxt file) fails with an error message under Linux. Was there any change in the api of Libreoffice? What do I have to change/add to get a working addin? Is there any documentation or are there any C++ addin examples that can be used? The examples in the SDK (code examples under $SDK/examples/cpp) are not helpful. It seems that there have been no changes. So I expect that the code for the Quantlib addin need not be modified. Any ideas? No, not in the LibreOffice API AFAIK, but the OOo extensions framework was changed during 3.3.x development. You would need to look up the archives of the OOo extensions/dev/api mailing lists to find out more information. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Macro not active when the document start
2011/8/11 Andreas Säger ville...@t-online.de: Am 11.08.2011 10:30, Johnny Rosenberg wrote: The macro is used as a cell function right? In that case, where did you put the macro? It should be placed in My Macros, I think, so you need to move it there if it's not there already. Wrong. It has to be stored in library Standard, either the document's one or the global one. Standard is loaded automatically and a cell function will be found immediately. Well, I have mine in My Macros/Standard but maybe that's not necessary. At the moment I have one cell function there and it works perfectly, but when I add another one, LibreOffice refuse to recognise it. What ever I do, the cell only displays ”#NAME?” no matter if I have it in the document's Standard library or in My Macros/Standard. Can someone give a step-by-step instruction how to create a simple cell function? Do I need to restart LibreOffice (did that too, but it didn't help)? I know I didn't create the thread, but still… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ The functions do not contain any references to UNO objects so they *should* work right from the start and they *should* update automatically if menu:ToolsCellContentsAutomatic Calculation is enabled and if (and only if) a referenced value has been modified. Otherwise recalculation should be triggered on key F9. Ctrl+shift+F9 enforces a complete recalculation of the whole workbook. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Macro not active when the document start
2011/8/11 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/11 Andreas Säger ville...@t-online.de: Am 11.08.2011 10:30, Johnny Rosenberg wrote: The macro is used as a cell function right? In that case, where did you put the macro? It should be placed in My Macros, I think, so you need to move it there if it's not there already. Wrong. It has to be stored in library Standard, either the document's one or the global one. Standard is loaded automatically and a cell function will be found immediately. Well, I have mine in My Macros/Standard but maybe that's not necessary. At the moment I have one cell function there and it works perfectly, but when I add another one, LibreOffice refuse to recognise it. What ever I do, the cell only displays ”#NAME?” no matter if I have it in the document's Standard library or in My Macros/Standard. Can someone give a step-by-step instruction how to create a simple cell function? Do I need to restart LibreOffice (did that too, but it didn't help)? I know I didn't create the thread, but still… Strange… I fiddled with it a bit and suddenly it works, I don't have a clue why… It also seems like it looks in the document's Standard library first, because if I had them at both places the local one was executed. I made a very simple one, this is the one in the document's standard library: Function DoStuff As Long DoStuff=3 End Function Here's the one in My Macros/Standard: Function DoStuff As Long DoStuff=4 End Function In a cell: =DOSTUFF The result was 3. When I removed the local one, the result was 4 after a Ctrl+Shift+F9. But still I don't have a clue why it works now and not a few minutes ago… Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to use the command /msoreg=1 ?
Hi :) Ahah, i have just found these links http://www.libreoffice.org/get-help/system-requirements/ I'm guessing that's the guide you used? It's definitely official and definitely for LibreOffice but it doesn't give a lot of detail. Jonny, it is to register all the various office formats that would 'normally' be opened by MS Office to be opened by LibreOffice instead. Normally when people install LibreOffice the final screen (the one with the Finish button rather than Next or Forwards) has a tick-box to make LibreOffice the default Office Suite. Generally i avoid that at first to allow people to continue using MS Office by default and just get used to LibreOffice at their own pace. Sobriquet an easier way to achieve the same result might be to try reinstalling LibreOffice but choose the Repair option instead of the full re-install. Hopefully the last screen will show those tick-boxes again. These links might provide more help with the route you are taking http://www.libreoffice.org/get-help/installation/windows/ and other official documentation is here http://www.libreoffice.org/get-help/documentation/ http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12918 It's an old guide and for OpenOffice.org but most things like that still work for LibreOffice because both Suites are very similar and we work together quite a bit sometimes. The LibreOffice code is smaller, cleaner and faster and has quite a lot of extra functionality and it's developing faster but still most of the basics are the same for both. Also although there is not a special section for Win7 the Vista and Xp guidance might help. This un-offical blog might help understand (i haven't read it yet so i don't know how good it is) http://minimumsystemrequirements.net/libreoffice.html If you do have to get java try to get their _20, _21 or _22 version, preferably the _21. The newer _24 _26 re great for web-browsers but really slow LibreOffice down quite badly. Hopefully you don't need java for Writer, Calc or anything except perhaps Base so you can leave Java until later. Somewhat insanely this guide might help! http://wikis.sun.com/display/StarOffice/StarOffice+9+Readme+for+Windows LibreOffice was developed from OpenOffice and we keep fairly close ties with them now that they are run by Apache. OpenOffice developed from StarOffice but that was about a decade ago. There are not many (a few but not many) that worked in StarOffice. The crazy thing is that Oracle were fairly bad at supporting or doing anything for OpenOffice during their brief ownership of it. They just seemed to try to kill it (imo). However, that link might be helpful??!! This guide was written a year or so before Oracle took ownership of OpenOffice. http://specs.openoffice.org/installation/filetyperegistration/foreign_file_type_registration.odt Sun were good at building up the community and keeping the product stable. They owned it for about a decade and were the ones that gave it the name OpenOffice.org rather than keeping it as StarOffice. The guide might try to download the Odt document onto your machine. I don't normally like links that do that. Many apols for that. It's very dry stuff and difficult to read. It's not really aimed at normal users so it might not be helpful. Hmm, this guide also looks like it might try to download itself, it's also very dry and also unlikely to really give quick easy answers. http://www.scribd.com/doc/53230646/readme-en-US Perhaps good for the detail tho, maybe. Hopefully someone else on this list might be able to give a quicker, easier answer. Good luck and regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 9:23:44 Subject: Re: [libreoffice-users] How to use the command /msoreg=1 ? 2011/8/11 sobriquet c.sobriq...@gmail.com: My computer does not have Microsoft office installed; rather the minute Starter office is in place. I followed the instructions in the System Requirements and downloaded--mmsvc90.dll. My computer is running Win7, so I went to Programs--Accessories-- Command Prompt, where the screen shows C:\users\name_ I type the command /msoreg=1 at the prompt, and it refuses to acknowledge it. What went wrong? Tks, Sobriquet And exactly where comes LibreOffice into the picture? Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?
Re: [libreoffice-users] How to use the command /msoreg=1 ?
2011/8/11 Tom Davies tomdavie...@yahoo.co.uk: Hi :) I think you don't need the / at the start of a command like that. Try msoreg=1 However, i have no idea what that command does or what it is supposed to do so please double check what the command is supposed to do and don't just blindly accept some random unofficial guide, blog or forum post, especially about Windows. Even googling for the command might give some insight into what it really does. It would help if you could give us the link to the guide you are following. We only really deal with LibreOffice here but some kind person might be willing to try to help. Good luck and regards from Tom :) I did some searching and found that this actually IS about OpenOffice.org/LibreOffice… :P It seems like if you install from the command line, you can add /msoreg=1 or /msoreg=0 to the installation command or something like that. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to use the command /msoreg=1 ?
2011/8/11 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Ahah, i have just found these links http://www.libreoffice.org/get-help/system-requirements/ I'm guessing that's the guide you used? It's definitely official and definitely for LibreOffice but it doesn't give a lot of detail. Jonny, it is to register all the various office formats that would 'normally' be opened by MS Office to be opened by LibreOffice instead. Yes, I just found out… But he operator could have been more detailed, couldn't he…? :D Well, it's all sorted out now anyway, isn't it? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Normally when people install LibreOffice the final screen (the one with the Finish button rather than Next or Forwards) has a tick-box to make LibreOffice the default Office Suite. Generally i avoid that at first to allow people to continue using MS Office by default and just get used to LibreOffice at their own pace. Sobriquet an easier way to achieve the same result might be to try reinstalling LibreOffice but choose the Repair option instead of the full re-install. Hopefully the last screen will show those tick-boxes again. These links might provide more help with the route you are taking http://www.libreoffice.org/get-help/installation/windows/ and other official documentation is here http://www.libreoffice.org/get-help/documentation/ http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12918 It's an old guide and for OpenOffice.org but most things like that still work for LibreOffice because both Suites are very similar and we work together quite a bit sometimes. The LibreOffice code is smaller, cleaner and faster and has quite a lot of extra functionality and it's developing faster but still most of the basics are the same for both. Also although there is not a special section for Win7 the Vista and Xp guidance might help. This un-offical blog might help understand (i haven't read it yet so i don't know how good it is) http://minimumsystemrequirements.net/libreoffice.html If you do have to get java try to get their _20, _21 or _22 version, preferably the _21. The newer _24 _26 re great for web-browsers but really slow LibreOffice down quite badly. Hopefully you don't need java for Writer, Calc or anything except perhaps Base so you can leave Java until later. Somewhat insanely this guide might help! http://wikis.sun.com/display/StarOffice/StarOffice+9+Readme+for+Windows LibreOffice was developed from OpenOffice and we keep fairly close ties with them now that they are run by Apache. OpenOffice developed from StarOffice but that was about a decade ago. There are not many (a few but not many) that worked in StarOffice. The crazy thing is that Oracle were fairly bad at supporting or doing anything for OpenOffice during their brief ownership of it. They just seemed to try to kill it (imo). However, that link might be helpful??!! This guide was written a year or so before Oracle took ownership of OpenOffice. http://specs.openoffice.org/installation/filetyperegistration/foreign_file_type_registration.odt Sun were good at building up the community and keeping the product stable. They owned it for about a decade and were the ones that gave it the name OpenOffice.org rather than keeping it as StarOffice. The guide might try to download the Odt document onto your machine. I don't normally like links that do that. Many apols for that. It's very dry stuff and difficult to read. It's not really aimed at normal users so it might not be helpful. Hmm, this guide also looks like it might try to download itself, it's also very dry and also unlikely to really give quick easy answers. http://www.scribd.com/doc/53230646/readme-en-US Perhaps good for the detail tho, maybe. Hopefully someone else on this list might be able to give a quicker, easier answer. Good luck and regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 9:23:44 Subject: Re: [libreoffice-users] How to use the command /msoreg=1 ? 2011/8/11 sobriquet c.sobriq...@gmail.com: My computer does not have Microsoft office installed; rather the minute Starter office is in place. I followed the instructions in the System Requirements and downloaded--mmsvc90.dll. My computer is running Win7, so I went to Programs--Accessories-- Command Prompt, where the screen shows C:\users\name_ I type the command /msoreg=1 at the prompt, and it refuses to acknowledge it. What went wrong? Tks, Sobriquet And exactly where comes LibreOffice into the picture? Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
Re: [libreoffice-users] How to use the command /msoreg=1 ?
Hi :) Lol, yup. I think we both found the same thing at the same time! I am not sure about missing the / now. All the guides i have seen do include it. So maybe the issue is about which folder you are in when you run the command. I might test it out from work later. If i can get onto a suitable Windows machine. Lol, this is going to be fun. Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 11:13:24 Subject: Re: [libreoffice-users] How to use the command /msoreg=1 ? 2011/8/11 Tom Davies tomdavie...@yahoo.co.uk: Hi :) I think you don't need the / at the start of a command like that. Try msoreg=1 However, i have no idea what that command does or what it is supposed to do so please double check what the command is supposed to do and don't just blindly accept some random unofficial guide, blog or forum post, especially about Windows. Even googling for the command might give some insight into what it really does. It would help if you could give us the link to the guide you are following. We only really deal with LibreOffice here but some kind person might be willing to try to help. Good luck and regards from Tom :) I did some searching and found that this actually IS about OpenOffice.org/LibreOffice… :P It seems like if you install from the command line, you can add /msoreg=1 or /msoreg=0 to the installation command or something like that. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Date Format in Writer
2011/8/11 rjw...@phonecoop.coop: To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International It IS international, it's ISO 8601 (and also Swedish standard, lucky me… ;P)! Except that there should be dashes, not dots: -mm-dd. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ .mm.dd format included as an option (default?) in the fields for Writer? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Date Format in Writer
Hi :) Ahhah, great. I prefer dashes - because after reading too much for too long my eyes get a bit muddled when people use / and dots still seem to confuse obscure Windows systems sometimes. I was told that the / was the European Standard but if - are used in one other country then that helps me argue the case with my boss. Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 11:18:39 Subject: Re: [libreoffice-users] Date Format in Writer 2011/8/11 rjw...@phonecoop.coop: To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International It IS international, it's ISO 8601 (and also Swedish standard, lucky me… ;P)! Except that there should be dashes, not dots: -mm-dd. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ .mm.dd format included as an option (default?) in the fields for Writer? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to use the command /msoreg=1 ?
2011/8/11 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Lol, yup. I think we both found the same thing at the same time! I am not sure about missing the / now. All the guides i have seen do include it. So maybe the issue is about which folder you are in when you run the command. I might test it out from work later. If i can get onto a suitable Windows machine. Lol, this is going to be fun. Regards from Tom :) I used Windows about 200 years ago, and as far as I remember, in the Windows command line, you use a ”/” instead of a ”-” for options, like ”dir /p /o /w” rather than ”dir -pow” which would be the Unix-style syntax. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to use the command /msoreg=1 ?
2011/8/11 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/11 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Lol, yup. I think we both found the same thing at the same time! I am not sure about missing the / now. All the guides i have seen do include it. So maybe the issue is about which folder you are in when you run the command. I might test it out from work later. If i can get onto a suitable Windows machine. Lol, this is going to be fun. Regards from Tom :) I used Windows about 200 years ago, and as far as I remember, in the Windows command line, you use a ”/” instead of a ”-” for options, like ”dir /p /o /w” rather than ”dir -pow” which would be the Unix-style syntax. Actually, what I', trying to say here, is that in this case, the command should look something like this: some_command /msoreg=1 Maybe install /msoreg=1 Well, something like that anyway. Just a guess, though. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Date Format in Writer
2011/8/11 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Ahhah, great. I prefer dashes - because after reading too much for too long my eyes get a bit muddled when people use / and dots still seem to confuse obscure Windows systems sometimes. I was told that the / was the European Standard but if - are used in one other country then that helps me argue the case with my boss. I though that ”/” was the US standard… Here (Sweden) we follow the ISO8601, except for time. Seems like we use dots instead of colons. Wish we and the rest of the world could just adapt the ISO 8601. There is a reason for why it was created… And personally I use it all the time. And of course every ”dygn” (sorry, there is no English translation for that word – yet…) is 24 hours, so why that silly 12 hour thing? If all analogue watches were made 24 hours, you could very easily also use it as a compass, at least when you can see the sun (if the hour hand point to the sun, then 24, or rather 0, will point to north, 6 to east, 12 to south and 18 to west). How can it be easier than that? Regards Johnny Rosenberg ジョニー・ローゼンバーグ 2011-08-11 12:36:51 Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 11:18:39 Subject: Re: [libreoffice-users] Date Format in Writer 2011/8/11 rjw...@phonecoop.coop: To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International It IS international, it's ISO 8601 (and also Swedish standard, lucky me… ;P)! Except that there should be dashes, not dots: -mm-dd. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ .mm.dd format included as an option (default?) in the fields for Writer? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] MS Works import
LibreOffice 3.4 is advertised as supporting import of MS Works files, but a search of the archives of this list shows very little about it. I have a colleague who has a rather large (66Mb) .wps file with loads of pictures that he wants to open on his Mac, and I suggested LO as an easy way. A quick play with my own LO (3.4.1) on Windows XP was inconclusive. I found a few sample .wps text documents on the web. Two of them opened OK, but had no formatting. The third opened as a blank document. A .wdb spreadsheet that I had been sent in the past also opened as a blank text document. How much experience of people had of Works import and does it actually work, or is it as I seem to be finding rather buggy? Dave http://www.davesergeant.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MS Works import
On 11/08/11 12:16, Dave Sergeant wrote: How much experience of people had of Works import and does it actually work, or is it as I seem to be finding rather buggy? Dave http://www.davesergeant.com No problem here using V 3.3.3 running on Ubuntu (that's the latest version for Ubuntu). See samples at www.writersedgeservice.com/filebrowser/proposalsfiction.asp . Formatting was fine. Charlie. -- M0WYM www.radiowymsey.org Sales @ radiowymsey http://shop.ebay.co.uk/gnome7763/m.html? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How can I build only libreoffice-writer instead of whole officesuite ?
Hi :) Yes, i have heard that of AbiWord before. Writer does have a lot more features. With LinuxFromScratch you might find Slackware forums helpful as i think they are the most similar to what you are doing. There will be slight differences of course but they are probably very used to the approach and the ideal of keeping the system streamlined. Othe distros forums might have soem tips but take care as they probably don't worry about adding 'bloat'. Also the forum http://www.linuxquestions.org is good for every distro but again take care as people might not worry about adding bloat which you may not want. Good to get ideas from tho! :) I have 1 machine that has Ubuntu and doesn't yet have LibreOffice installed but it's difficult for me to get to. If i do manage it i will try to remember to get a list of dependencies for Writer alone. I have a feeling that it is going to be the entirety of LibreOffice excluding only Base and possibly Java. Regards from Tom :) From: Partha Chowdhury parthachowdhur...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 6:04:26 Subject: Re: [libreoffice-users] Re: How can I build only libreoffice-writer instead of whole officesuite ? I have tried abiword, but when I try to open a doc document in abiword which was created by microsoft office 2003, the file looks gibberish.In addition , all indentation, margins,tables,frames etc look out-of-place.It cannot render the file properly.Atleast openoffice or Libreoffice renders it properly.And abiword being a lightweight lacks many features than LO-writer. I am using Linux from Scratch, http://www.linuxfromscratch.org, which teaches you to build a minimalist bootable GNU/Linux system entirely from source code.from there, One can easily install any software of his choice or need and have a minimal yet very fast,efficient and functional system. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MS Works import
On 11/08/11 12:16, Dave Sergeant wrote: How much experience of people had of Works import and does it actually work, or is it as I seem to be finding rather buggy? Be sure you installed the 'Legacy File Format Filters' when you installed it. You have to choose the 'Custom' install option to get to these... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: add ttf fonts to LibreOffice
Thanks for all who answered, creating the .fonts directory under /home/username/ and rerunning fc-cache was the solution that worked. Thanks for all of you! -- View this message in context: http://nabble.documentfoundation.org/add-ttf-fonts-to-LibreOffice-tp3241306p3245749.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MS Works import
On 11 Aug 2011 at 12:35, Charlie wrote: How much experience of people had of Works import and does it actually work, or is it as I seem to be finding rather buggy? No problem here using V 3.3.3 running on Ubuntu (that's the latest version for Ubuntu). See samples at www.writersedgeservice.com/filebrowser/proposalsfiction.asp . Formatting was fine. Thanks Charlie for that. I have just updated to 3.4.2 to see if that would change things, but it did not. And yes, I DO have the legacy filters installed, which you need for the old .sxw etc formats but I don't think they are needed for Works. The documents on writersedge were in fact the ones I had found myself. There are three .wps files on there, and these all open fine, complete with formatting, bolding etc in MS Word Viewer. In LO 3.4.2: cad7593009.wps - opens blank, if I look at the properties pane it claims it has 1 page with 0 characters. fot4813409.wps and mot6312910.wps open correctly as plain text but all the bolding, italics, paragraph indents, and other formatting is missing. They look totally different from how they do in Wordview. I wonder if it has changed between v3.3 and v3.4 or maybe it is a Windows issue? Dave http://www.davesergeant.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: New user to BASE
On 08/10/2011 04:50 AM, Alexander Thurgood wrote: Le 07/08/11 03:55, Wayne a écrit : Hi Wayne, A couple of three days ago someone, on this list, mention not to use BASE, as there wasn't much development going on. Their suggestion was to look for a different front end to use. Can someone make a suggestion as to what would be a good alternative to use? No wars please. Just good advice. Thanks LibreOffice Base can do quite a lot, but it requires a fairly steep initial investment once you realise that the wizards are a bit limited, and thus you become reliant on macro programming for the unmet features that would be found in other front end solutions like FMPro or Approach or Access, and dare I say it, the fairly numerous bugs that are now in the source code (and aren't yet being fixed). Having used Approach in the past, I would have to agree with Roland if all you want is to have a db front end that you can use on Linux (via Wine) and Windows. If you want it to provide a front end for Mac as well, then you will be stuck with either LibreOffice Base and a fairly sustantial choice of server backends, or using some other interface design tool for your db such as Ruby, XML forms, PHP, etc. Alex Would you include Python in that list? Wayne -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base 3.4.2 doesn't run on Windows 7
Hi, I saved the instructions for adding the Java for my future reference if needed. These are slightly modified over what had been in the post: *Older Java Version for LibreOffice and Open Office for Linux Install:* Overview: 1. Download the JRE archive (approx. 20 mb) 2. Extract in /tmp 3. as root, copy the extracted directory to /usr/lib/jvm 4. set this JRE as the JRE of choice in LO (ToolsOptionsJava) 5. Exit LO restart Instructions: 1.Download jre-6u21-linux-i586.bin (for i386) or jre-6u21-linux-x64.bin for x86_64 from http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive- http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPRdownloads-javase6-419409.html#jre-6u21-b07-oth-JPR http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPR Save to /tmp . Open Terminal and enter cd /tmp. Then do the following commands: 2.run it using: sh jre-6u21-linux-i586.bin . The JRE is now extracted to /tmp/jre1.6.0_21/ 3. copy to /usr/lib/jvm sudo cp -a jre1.6.0_21/ /usr/lib/jvm 4. Exit restart office. In ToolsOptionsJava, choose 1.6.0_21. Exit restart office 5. Load you Base file compare the speed. If you want to remove it simply set the JRE back to the old one in ToolsOptionsJava sudo rm -rf /usr/lib/jvm/jre1.6.0_21/ On 08/10/2011 09:31 AM, Tom Davies wrote: Hi :) Thanks for confirming that the _21 is the best version for LibreOffice. Is there any chance of joining the Documentation Team to write-up the instructions for installing a separate version of Java specifically for LibreOffice? I think a chapter about Java is likely to start off as being very small and it's not clear exactly where it could go but i think once written it could be moved fairly easily. Alternatively perhaps an Ubuntu Community Documentation page? Either a radical re-write of https://help.ubuntu.com/community/Java or something more specific to LibreOffice such as creating a new page https://help.ubuntu.com/community/Base/Java With a longer-term view of having a single main page about Base that then has sub-pages (such as the Java one) and/or links to proper LibreOffice documentation. Regards from Tom :) From: Don Myersdonmy...@myersfarm.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 4:09:06 Subject: Re: [libreoffice-users] Re: Base 3.4.2 doesn't run on Windows 7 Hi, When we had the long thread about Base working really slowly and the problem being Java, I thought someone said the issue only affected those running Base in Linux. I only run it (but on 4 machines) in Ubuntu. I have no Windows installs. When Ubuntu had 1.6.0_22 as the default, my base worked fine. When the Java 1.6.0_24 update was installed, base became horribly slow. When the 1.6.0_26 update was installed, it was still very slow. Someone in the thread said that in Linux you can have two Java versions installed on a system side by side, and he gave instructions on how to do it. Following those instructions, I've tried both 1.6.0_21 and 1.6.0_22. Base works well with both of them, but is just a tiny bit faster on my systems with the _21 version. When you install the second version as per the instructions this person gave, the older version is only used for LibreOffice. The browsers are still using the latest version, so you have all of the security protection of the latest version. I'm sorry I can't give you advise relative to Windows systems. I don't know if Windows has the same situation as Linux. The problem wasn't that Base didn't run in Linux. It was just very sluggish. On 08/09/2011 06:50 PM, Tom Davies wrote: Hi :) Except that quite a few people have reported problems with ultra-new java such as the _26 version. The _22 and _20 were ok but the _21 seems to be the best for LibreOffice Base. I think the _22 is the standard one in the Ubuntu repos but i'm not sure about other distros or Windows (or Mac or Bsd). It might mean you need to have 2 versions of Java installed as your web-browser might be using something other than the _20 - _22 Regards from Tom :) From: webmaster for Kracked Press Productionswebmas...@krackedpress.com To: users@global.libreoffice.org Sent: Sun, 7 August, 2011 14:00:59 Subject: Re: [libreoffice-users] Re: Base 3.4.2 doesn't run on Windows 7 I remember something about Sun/Oracle older version of Java having problem with LibreOffice, but there is an open-source version that would instead. The one on my Ubuntu system states it is Sun's Java, but the file's name [folder's name] of the runtime engine seems to be Java-6-openjdk. I know someone on this list would know what the best link for it is. Ubuntu seems to have it on its repository, but Windows would need a link to find/download it for their use. As for the latest version of Java, it is always a good
Re: [libreoffice-users] mailinglist
yeah,thought so On 10 August 2011 19:09, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Not really. It is nice to see different languages in here but native English-speakers are often unable to understand more than 1 language and many have trouble even with that one. There are many other lists for many other languages. Regards from Tom the monoglot :) From: soumalya ray drsouma...@gmail.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 14:12:31 Subject: Re: [libreoffice-users] mailinglist could any language be used to ask question in this mailing list? On 10 August 2011 14:41, Stan Goodman stan.good...@hashkedim.com wrote: On 08/10/2011 10:48 AM, RK wrote: Werte Damen und Herren, bitte meine E-Mail Adresse aus der mailinglist streichen. Danke Rainer Kretzschmar Kärrnerweg 25 09350 Lichtenstein e-Mail: srkretzsch...@vodafone.de -- For unsubscribe instructions e-mail to: users+help@global.libreoffice. ** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/ http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/ http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted Nobody here can do what you ask. The only one that can unsubscribe you is you yourself. To do so, READ the instructions just above (which appear at the bottom of each and every message you receive from the list. -- Stan Goodman Qiryat Tiv'on Israel -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/ http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/ http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Macro not active when the document start
Am 10.08.2011 09:23, toto wrote: I'm using macro's function and it doesn't start when the document start. It would start if I change the value of the variabel at the function. The code is to change numeric value to string. If I execute the code: ubah(123) the result is seratus dua puluh tiga. Any idea how to make the function executed when I open the document? The code is: Public Function ubah(x as currency) as String Currency is not a valid type to be used in a spreadsheet. From the Basic perspective all spreadsheet values are doubles or string, errors are Null, empty cells are empty strings. There are no date values in particular. This function works as expected: Function DOUBLE(n as Double) DOUBLE = n *2 End Function This function returns a text value. Function DOUBLE_CURR(n as Currency) DOUBLE_CURR = n *2 End Function I can not reproduce the recalculation problem, though. Both versions of the above functions recalculate when I load the document or when I modify A1 with auto-cacluation enabled. A1 =PI() =DOUBLE(A1) = 6.2832 (number) =DOUBLE_CURR(A1) = 6.2832 (text) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Am 11.08.2011 01:28, jorge wrote: Hi I'm sorry but I made an example with Style and the first column header (Title) wasn't changed. Besides, I refreshed the pilot table and lost the headers format. What did I wrong ? The pilot uses one distinct set of automatically generated styles. For column headers in the English GUI the style is named DataPilot_Category. When the pilot is rebuilt on refresh, all formatting falls back to that style. - Application of some other style will be reset to DataPilot_Category. - Hard attributes will be reset to the bare DataPilot_Category settings. - Modifying DataPilot_Category itself will format both, row headers and column headers. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Date Format in Writer
Am 11.08.2011 11:11, rjw...@phonecoop.coop wrote: To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International .mm.dd format included as an option (default?) in the fields for Writer? menu:ToolsOptionsLanguageSettingsLangugesLocale=Swedish applies Swedish formatting to all numbers in all components unless the locale has been set explicitly. When I send you a document where I explicitly applied the German locale, all numeric values look like 1.234,99 and 31.12.2011 regardless of your default setting. In Writer you can define an auto text with an ISO formatted date field as content. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Opening xls file with xhtml embedded
We have main frame reports that are generated using xhtml and saved as extension xls. When the user gets the report they would typically just open them with excel, no problem... Calc does not open them properly. When I ope CALC and manually open the spreadsheet, it eventually opens in Writer/Web and does not look like the same result as Excel does This is a major stumbling block for us to move over to Libre Office.. We are engaged with application vendor to change the report, but we all know how that can beSLOWWW.. -- View this message in context: http://nabble.documentfoundation.org/Opening-xls-file-with-xhtml-embedded-tp3245877p3245877.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MS Works import
On 08/11/2011 06:44 AM, Dave Sergeant wrote: On 11 Aug 2011 at 12:35, Charlie wrote: How much experience of people had of Works import and does it actually work, or is it as I seem to be finding rather buggy? No problem here using V 3.3.3 running on Ubuntu (that's the latest version for Ubuntu). See samples at www.writersedgeservice.com/filebrowser/proposalsfiction.asp . Formatting was fine. Thanks Charlie for that. I have just updated to 3.4.2 to see if that would change things, but it did not. And yes, I DO have the legacy filters installed, which you need for the old .sxw etc formats but I don't think they are needed for Works. The documents on writersedge were in fact the ones I had found myself. There are three .wps files on there, and these all open fine, complete with formatting, bolding etc in MS Word Viewer. In LO 3.4.2: cad7593009.wps - opens blank, if I look at the properties pane it claims it has 1 page with 0 characters. fot4813409.wps and mot6312910.wps open correctly as plain text but all the bolding, italics, paragraph indents, and other formatting is missing. They look totally different from how they do in Wordview. I wonder if it has changed between v3.3 and v3.4 or maybe it is a Windows issue? ... It's not a Windows issue... I've tested using OOo 3.2.1 (go-oo based), LO 3.3.3, and LO 3.4.2 - all linux, and get the same results in 3.4.2. OOo 3.2.1 and LO 3.3.3 opens cad7593009.wps (albeit without detailed formating). So I reckon that you've found a bug - please file a bug report using those files as examples. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MS Works import
Le 11/08/11 15:44, Dave Sergeant a écrit : Hi Dave, In LO 3.4.2: cad7593009.wps - opens blank, if I look at the properties pane it claims it has 1 page with 0 characters. fot4813409.wps and mot6312910.wps open correctly as plain text but all the bolding, italics, paragraph indents, and other formatting is missing. They look totally different from how they do in Wordview. I can confirm your described display of these files on Mac OSX with LibreOffice 3.4.2, but as far as I knew, WPS import was never perfect anyway. FWIW, in LO 3.3.2, the files display differently, with cad7593009 opening and showing bold and italic formatting. However, the other two files do not appear to show paragraph indents, bold or italic either in LO 3.3.2, so I would say that the import feature is less than perfect, and that something between 3.3.x and 3.4.x now prevents opening of certain content stored within WPS files. You'd best open a bug report. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: New user to BASE
Le 11/08/11 15:46, Wayne a écrit : Would you include Python in that list? Wayne Sure, any programming language that allows you to build a graphically driven frontend. AFAIK, Python can do that with tcl, wx, gtk, and no doubt other graphical toolkits so why not ? ;-) I actually went scouring for stuff like that the other day on sourceforge because I need to have a frontend I can design, implement and distribute over a network and multiple-OSes. I haven't had time to try the various bits out yet though, most of which looks PHP-based (but only because I have a vague understanding of PHP - my python skills are way too low to attempt something like that at the moment, but I did give it some thought :-)) Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] size of LibreOffice RAM when converting towards pdf
Hi, I have just a 10 Mo .ppt including around 30 jpeg images. I want to convert it towards PDF using LibreOffice, while using a Java program. To do so, I use the LibreOffice SDK from Java, with socket connection (due to streaming) between Java/LibreOffice. While the original document size sounds not that high, LibreOffice raises up to 3 Go (!) of RAM. What do you think about that numbers ? While looking for a way to decrease the RAM used by LibreOffice, I wondered about the folllowing: - what is the version of PDF for the created PDF doc ? - are you using JPXDecode (a lossy or lossless filter based on the JPEG 2000 standard, introduced in PDF 1.5) for not converting jpeg images ? - are you doing streaming during the transformation process ? Thanks for your responses. Regards, Dominique -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 05:23 PM, Simon Cropper wrote: It is obvious that you do not like OO or LO Calc, and that you don't like the fact that your data is continually corrupted. LO is a tool. I neither like or dislike it. As a tool, it has a major defect in that it periodically destroys the product which was built using it. You're right in that I don't like the tool I'm using to destroy my work. You also say you continuously have to rebuild your spreadsheet and that the process can take several days. Just spent 2 long days recreating the spreadsheet using 2 machines. Not fun. If you are so unhappy with the format, corruption and dirty code, my question is why do you persist? I've got a lot of investment in my macro code (9000 lines of it) that can only function within LO. I can't migrate it to something else as is. Had I known about the corruption when I started the project 6 years ago, I would have chosen a different platform. I would have never imagined that over the course of several years that corruption issues would be ignored. That's just inconceivable to me as a professional software developer, but that's apparently the reality. Change packages. Can't, as was mentioned above, unless I rewrite everything. Sad to say, LO is the only real competitor to MS Office and given its corruption history it will turn a lot of people off that might have moved away from MS Windows to Linux had the product been reliable. My real interest is in moving people away from a lousy operating system like Windows to something near bullet proof like Linux. We all need applications tools like word processing, spreadsheet, etc, so a tool like LO is vitally important to Linux adoption. If I could get MS Office compiled to run on Linux as a native application, I'd forget about LO in a heartbeat. MS Office is the best thing Microsoft has. It works well in its native environment. I wish I could say the same for LO, and that's why I'm critical of it. With the time and effort you have already put into recreating corrupted spreadsheets you could of written your own application or mastered alternative packages. I guess you don't write code for a living. I estimate a rewrite of my POS system would take well over a year of my time. While that's going on, I need something reliable to help run a business. I have sketched out a web based replacement much much more sophisticated than what I'm using now, and plan on developing it when I have the time. Wasting time reporting OO / LO bugs that never get taken seriously and recreating a spreadsheet periodically helps keeps me from such a new development effort. My wife (also a professional software developer) keeps telling me to stop wasting time reporting issues - that I'm tilting at windmills. She may be right. I am not trying to be rude here it just if I had a package that caused me so much wasted time I would just move on. I will move on in time, but in the interim, I'd like LO to thrive in the market, and that won't happen unless it becomes reliable. My problem is really with LO management. There isn't any. Despite what you may think, I'm more interested in LO's success than most people are, and I know it won't be successful long term unless its reliable. It hasn't been reliable for years and that's a problem. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5EEGMACgkQ7Orvev+eC8rvIACgly5u6U6eM9DeiCbJJ5++k8rf BpUAoIy9kOViLVFCssIwmN3BfCGnR+Dy =ct68 -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] size of LibreOffice RAM when converting towards pdf
Hi :) Which version of Java are you using? The more recent _26 and _24 versions create problems in LibreOffice. The ideal version is their _21 but the _22 and _20 are also quite good. Also which version of LibreOffice are you using? The 3.3.3 is the latest stable but the more adventurous 3.4.2 has some extra functionality. You can install both side-by-side but only by following the technique shown in this guide http://wiki.documentfoundation.org/Installing_in_parallel It might also make a difference which Operating System you are using; a Windows, Ubuntu, another GnuLinux, Bsd or Mac? Regards from Tom :) From: DE VITO Dominique dominique.dev...@thalesgroup.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Thu, 11 August, 2011 18:24:28 Subject: [libreoffice-users] size of LibreOffice RAM when converting towards pdf Hi, I have just a 10 Mo .ppt including around 30 jpeg images. I want to convert it towards PDF using LibreOffice, while using a Java program. To do so, I use the LibreOffice SDK from Java, with socket connection (due to streaming) between Java/LibreOffice. While the original document size sounds not that high, LibreOffice raises up to 3 Go (!) of RAM. What do you think about that numbers ? While looking for a way to decrease the RAM used by LibreOffice, I wondered about the folllowing: - what is the version of PDF for the created PDF doc ? - are you using JPXDecode (a lossy or lossless filter based on the JPEG 2000 standard, introduced in PDF 1.5) for not converting jpeg images ? - are you doing streaming during the transformation process ? Thanks for your responses. Regards, Dominique -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: New user to BASE
Hi On Thu, 2011-08-11 at 18:01 +0200, Alexander Thurgood wrote: Le 11/08/11 15:46, Wayne a écrit : Would you include Python in that list? Wayne Sure, any programming language that allows you to build a graphically driven frontend. AFAIK, Python can do that with tcl, wx, gtk, and no doubt other graphical toolkits so why not ? ;-) I actually went scouring for stuff like that the other day on sourceforge because I need to have a frontend I can design, implement and distribute over a network and multiple-OSes. I haven't had time to try the various bits out yet though, most of which looks PHP-based (but only because I have a vague understanding of PHP - my python skills are way too low to attempt something like that at the moment, but I did give it some thought :-)) Alex You have several options with databases: use Base only, use Base as the front end with another database as the back end, or use another database and hope there are decent graphical tools available. Base only may limit what you can do particularly with network access For Base with another back end you will need to set up the connection in Base and many common options are supported. Using another database completely can be tricky, some do not have nice front end tools. Two that do are MySQL/MariaDB (Linux uses MySQL Workbench) and PostgreSQL (pgadmin). SQLite is another possibility but it does not easily support all the data types that may be in a database. None of these will require any programming but will require varying knowledge of SQL to use effectively. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Libre Office being recommended on Microsoft Answers Forums!
Yes it's true! I see this more and more - LO being recommended to people who've bought a computer with a Trial version of Office 2010 that's expired... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Opening xls file with xhtml embedded
Hi On Thu, 2011-08-11 at 06:11 -0700, msaum@smi wrote: We have main frame reports that are generated using xhtml and saved as extension xls. When the user gets the report they would typically just open them with excel, no problem... Calc does not open them properly. When I ope CALC and manually open the spreadsheet, it eventually opens in Writer/Web and does not look like the same result as Excel does This is a major stumbling block for us to move over to Libre Office.. We are engaged with application vendor to change the report, but we all know how that can beSLOWWW.. -- View this message in context: http://nabble.documentfoundation.org/Opening-xls-file-with-xhtml-embedded-tp3245877p3245877.html Sent from the Users mailing list archive at Nabble.com. Instead of opening the file try importing the file into Calc using INSERT SHEET FROM FILE. You will be presented with an import wizard. If that does not work you link to data, also under INSERT. I think the problem is when the encoding is read by LO it sees as an XHTML page for Writer. Excel is a stand alone product, as all the MSO suite members while LO is an integrated suite (you get everything at once). So LO opens a file it tries to open it with what is normally the best option based on the actual encoding. Changing the file extension does not change the file encoding. This can cause problems because the opening program may incorrectly interpret the file format present gibberish. The best way for the main frame to output is with the correct extension or as a CSV file which any spreadsheet can handle. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Date Format in Writer
Johnny On Thu, 2011-08-11 at 12:36 +0200, Johnny Rosenberg wrote: 2011/8/11 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Ahhah, great. I prefer dashes - because after reading too much for too long my eyes get a bit muddled when people use / and dots still seem to confuse obscure Windows systems sometimes. I was told that the / was the European Standard but if - are used in one other country then that helps me argue the case with my boss. I though that ”/” was the US standard… Here (Sweden) we follow the ISO8601, except for time. Seems like we use dots instead of colons. / with mm/dd/ is the normal US standard (sometimes mm.dd. because / is mis interpreted in file names). Most Americans who have dealt with international trade are comfortable with either US or ISO styles and for dates. Wish we and the rest of the world could just adapt the ISO 8601. There is a reason for why it was created… And personally I use it all the time. And of course every ”dygn” (sorry, there is no English translation for that word – yet…) is 24 hours, so why that silly 12 hour thing? If all analogue watches were made 24 hours, you could very easily also use it as a compass, at least when you can see the sun (if the hour hand point to the sun, then 24, or rather 0, will point to north, 6 to east, 12 to south and 18 to west). How can it be easier than that? When I was in elementary school we were taught a 12 hour cycle with AM and PM to determine if it was morning or afternoon/evening. The US military, I believe, uses the 24 hour clock because 0900 is always in the morning while evening equivalent 2100 is always in the evening/night, much less likely to be misunderstood. Regards Johnny Rosenberg ジョニー・ローゼンバーグ 2011-08-11 12:36:51 Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 11:18:39 Subject: Re: [libreoffice-users] Date Format in Writer 2011/8/11 rjw...@phonecoop.coop: To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International It IS international, it's ISO 8601 (and also Swedish standard, lucky me… ;P)! Except that there should be dashes, not dots: -mm-dd. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ .mm.dd format included as an option (default?) in the fields for Writer? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office being recommended on Microsoft Answers Forums!
Gordon On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote: Yes it's true! I see this more and more - LO being recommended to people who've bought a computer with a Trial version of Office 2010 that's expired... +1 Where is this happening? -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] unopkg error
Lars On Thu, 2011-08-11 at 10:23 +0200, Lars Callenbach wrote: Hi Jay, I have modified the QuantLib addin code so that it runs under Linux and Windows XP (using Openoffice 3.2.1). Under Libreoffice the code compiles and the oxt file will be created but loading of the addin (using the oxt file) fails with an error message under Linux. Was there any change in the api of Libreoffice? What do I have to change/add to get a working addin? Is there any documentation or are there any C++ addin examples that can be used? The examples in the SDK (code examples under $SDK/examples/cpp) are not helpful. It seems that there have been no changes. So I expect that the code for the Quantlib addin need not be modified. Any ideas? Regards, Lars Truthfully, I do not know what changes, if any were made to the APIs. You might want to check some the developer documentation. Lars, On Wed, 2011-08-10 at 09:22 +0200, Lars Callenbach wrote: Hello, I have compiled an addin which works find under openoffice 3.2. Using either libreoffice 3.3 or 3.4 the following error message appears: ERROR: Fehler beim Hinzuf�gen von: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt Cause: Media-Typ konnte nicht ermittelt werden: file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt unopkg failed. The directory CalcAddins.oxt has not been created and the oxt file has not been unziped. What do I have to change to get a working addin using libreoffice? Regards, Lars -- NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! Jetzt informieren: http://www.gmx.net/de/go/freephone I would check OOo to see if they have an updated version and check http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List and http://wiki.documentfoundation.org/Downloads/Templates . Plugins, unless they are official ones, may lag the release somewhat some if they need significant changes they may not work with the latest version. -- Jay Lozier jsloz...@gmail.com -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How can I build only libreoffice-writer instead of whole office suite ?
Partha, On Wed, 2011-08-10 at 18:07 +0530, Partha Chowdhury wrote: Hallo all.This is my first post to the list. I have successfully build libreoffice-3.3.3.1 form source.However, I need office only to open and edit word documents and nothing else. So I want only to build the writer part and not the whole office.I have googled but have not found anything to this effect.The documentation covers only building from git and not the individual parts. So is it possible only to build a part of libreoffice instead of whole suite ? I might check out the source code, http://cgit.freedesktop.org/libreoffices. I am not sure what you need from the list. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office being recommended on Microsoft Answers Forums!
On 11/08/2011 20:43, planas wrote: Gordon On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote: Yes it's true! I see this more and more - LO being recommended to people who've bought a computer with a Trial version of Office 2010 that's expired... +1 Where is this happening? here's one thread: http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_install/have-windows-7-on-computer-try-and-open-a-doc-and/166d698d-b3a0-4a56-9dee-1fb0aba2a3a9 By an MVP no less! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Macro not active when the document start
On Thu, 2011-08-11 at 11:17 +0200, Andreas Säger wrote: Am 10.08.2011 09:23, toto wrote: I'm using macro's function and it doesn't start when the document start. It would start if I change the value of the variabel at the function. The code is to change numeric value to string. If I execute the code: ubah(123) the result is seratus dua puluh tiga. Any idea how to make the function executed when I open the document? The code is: Public Function ubah(x as currency) as String Currency is not a valid type to be used in a spreadsheet. From the Basic perspective all spreadsheet values are doubles or string, errors are Null, empty cells are empty strings. There are no date values in particular. Subtle little gotcha, use dates/time and currencies in the spreadsheet but the value must be converted to a valid Basic data type. This function works as expected: Function DOUBLE(n as Double) DOUBLE = n *2 End Function This function returns a text value. Function DOUBLE_CURR(n as Currency) DOUBLE_CURR = n *2 End Function I can not reproduce the recalculation problem, though. Both versions of the above functions recalculate when I load the document or when I modify A1 with auto-cacluation enabled. A1 =PI() =DOUBLE(A1) = 6.2832 (number) =DOUBLE_CURR(A1) = 6.2832 (text) -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How can I build only libreoffice-writer instead of whole office suite ?
On 2011-08-11, planas wrote: Partha, On Wed, 2011-08-10 at 18:07 +0530, Partha Chowdhury wrote: I have successfully build libreoffice-3.3.3.1 form source.However, I need office only to open and edit word documents and nothing else. So I want only to build the writer part and not the whole office.I have googled but have not found anything to this effect.The documentation covers only building from git and not the individual parts. So is it possible only to build a part of libreoffice instead of whole suite ? I might check out the source code, http://cgit.freedesktop.org/libreoffices. I am not sure what you need from the list. The OP asked the list if anyone knows if it is possible to compile just a single component, instead of the entire suite. As so far it seems noone knows here, I'd suggest the OP to post his question to the developers list, at least there I guess more people are used to play with the build system. The devs list mailman page: http://lists.freedesktop.org/mailman/listinfo/libreoffice There's also #libreoffice-dev at freenode (IRC). -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc will not save file after sheet deleted.
Le 10/08/11 01:46, Simon Cropper a écrit : Hi Simon, If I work back through the historical copies of the file, I can only reproduce the error in this years version. It is as if the file has become partially corrupted. The question is how and can it be easily fixed. Use xmlpp and xmldiff (perl scripts) to compare the content.xml of each ODS between a good (older) file and one of the recent ones where the problem started occurring. You may find that you have some odd difference in the two files that causes the behaviour you mention. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Date Format in Writer
On Thursday 11 August 2011 22:40:04 planas wrote: Johnny On Thu, 2011-08-11 at 12:36 +0200, Johnny Rosenberg wrote: 2011/8/11 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Ahhah, great. I prefer dashes - because after reading too much for too long my eyes get a bit muddled when people use / and dots still seem to confuse obscure Windows systems sometimes. I was told that the / was the European Standard but if - are used in one other country then that helps me argue the case with my boss. I though that ”/” was the US standard… Here (Sweden) we follow the ISO8601, except for time. Seems like we use dots instead of colons. / with mm/dd/ is the normal US standard (sometimes mm.dd. because / is mis interpreted in file names). Most Americans who have dealt with international trade are comfortable with either US or ISO styles and for dates. Wish we and the rest of the world could just adapt the ISO 8601. There is a reason for why it was created… And personally I use it all the time. And of course every ”dygn” (sorry, there is no English translation for that word – yet…) is 24 hours, so why that silly 12 hour thing? If all analogue watches were made 24 hours, you could very easily also use it as a compass, at least when you can see the sun (if the hour hand point to the sun, then 24, or rather 0, will point to north, 6 to east, 12 to south and 18 to west). How can it be easier than that? When I was in elementary school we were taught a 12 hour cycle with AM and PM to determine if it was morning or afternoon/evening. The US military, I believe, uses the 24 hour clock because 0900 is always in the morning while evening equivalent 2100 is always in the evening/night, much less likely to be misunderstood. Regards Johnny Rosenberg ジョニー・ローゼンバーグ 2011-08-11 12:36:51 Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 11:18:39 Subject: Re: [libreoffice-users] Date Format in Writer 2011/8/11 rjw...@phonecoop.coop: To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International It IS international, it's ISO 8601 (and also Swedish standard, lucky me… ;P)! Except that there should be dashes, not dots: -mm-dd. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ .mm.dd format included as an option (default?) in the fields for Writer? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscr ibe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubsc ribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubsc ribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted There is a limit to how comfortable such people can be, living in a mixed envirenment and trying to juggle mm/dd/ and dd/mm/. I wonder how many schedules or appointments have been missed, how much money lost, because of misinterpreting 8/11/2011 as a date in November rather than one in August, or vice versa. Not to mention applications that know only mm/dd/ although the OS is set for dd/mm/ (as here), so that one must analyse every date that is displayed. -- Stan Goodman Qiryat Tiv'on Israel -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office being recommended on Microsoft Answers Forums!
On Friday 12 August 2011 00:22:12 planas wrote: On Thu, 2011-08-11 at 20:59 +0100, Gordon Burgess-Parker wrote: On 11/08/2011 20:43, planas wrote: Gordon On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote: Yes it's true! I see this more and more - LO being recommended to people who've bought a computer with a Trial version of Office 2010 that's expired... +1 Where is this happening? here's one thread: http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_ install/have-windows-7-on-computer-try-and-open-a-doc-and/166d698d- b3a0-4a56-9dee-1fb0aba2a3a9 By an MVP no less! Priceless - getting a plug from the enemy's camp. The logical next step is for somebody to reply to that helpful hint, and suggest that the fellow go the whole hog and dump his Win7 altogether. -- Stan Goodman Qiryat Tiv'on Israel -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office being recommended on Microsoft Answers Forums!
On Fri, 2011-08-12 at 01:07 +0300, Stan Goodman wrote: On Friday 12 August 2011 00:22:12 planas wrote: On Thu, 2011-08-11 at 20:59 +0100, Gordon Burgess-Parker wrote: On 11/08/2011 20:43, planas wrote: Gordon On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote: Yes it's true! I see this more and more - LO being recommended to people who've bought a computer with a Trial version of Office 2010 that's expired... +1 Where is this happening? here's one thread: http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_ install/have-windows-7-on-computer-try-and-open-a-doc-and/166d698d- b3a0-4a56-9dee-1fb0aba2a3a9 By an MVP no less! Priceless - getting a plug from the enemy's camp. The logical next step is for somebody to reply to that helpful hint, and suggest that the fellow go the whole hog and dump his Win7 altogether. -- Stan Goodman Qiryat Tiv'on Israel +1 -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office being recommended on Microsoft Answers Forums!
On Thursday, August 11, 2011 03:07:54 PM Stan Goodman wrote: On Friday 12 August 2011 00:22:12 planas wrote: On Thu, 2011-08-11 at 20:59 +0100, Gordon Burgess-Parker wrote: On 11/08/2011 20:43, planas wrote: Gordon On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote: Yes it's true! I see this more and more - LO being recommended to people who've bought a computer with a Trial version of Office 2010 that's expired... +1 Where is this happening? here's one thread: http://answers.microsoft.com/en-us/windows/forum/windows_7-window s_ install/have-windows-7-on-computer-try-and-open-a-doc-and/166d69 8d- b3a0-4a56-9dee-1fb0aba2a3a9 By an MVP no less! Priceless - getting a plug from the enemy's camp. The logical next step is for somebody to reply to that helpful hint, and suggest that the fellow go the whole hog and dump his Win7 altogether. +5 that's what I did 12 years ago when my Win ME died. -- Russ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] minor install/config issues
Installing LO 3.4.2 and a long list of add-ons (+90) had few problems than several prior OO installs. The Extension Manager GUI stability is greatly improved. No crashes! Yea! Problems encountered were largely due to the EM installing (or attempting to install) defective packages, primarily .zips. Some only vaguely resembled an OXT package. IMO at a minimum a package that cannot be uninstalled with standard tools, i.e.: unopkg. should be rejected. It seems that the presence of bogus packages in the cache prevented persistent completion of component registration. Repeatedly, start-up (QuickStart) and first document opening were painfully slow. Each process consuming IO in the high tens of megabytes. Changing the JRE used to 6.21 produce a geometric run-time reduction. Apparently, removing offending extensions has allowed registration processing to be completed and saved. There has been a significant and stable reduction in start-up time and IO. Opening documents after the first is fast. Subjectively much better than OO. The platform is XP SP3 running on legacy hardware: P4 - 2 MHz, 1 GB 266MHz DDR, PCI 133. No errors were reported from several invocations of unopkg validate (at different points in the above process). The command unopkg reinstall --shared -v produced the following message: ERROR: cannot get file url from system path: -env:INIFILENAME=vnd.sun.star.pathname:c:\Software\Office\Libre\v3\program\redirect.ini Exception details: (com.sun.star.uno.RuntimeException) { { Message = cannot get file url from system path: -env:INIFILENAME=vnd.sun.star.pathname:c:\\Software\\Office\\Libre\\v3\\program\\redirect.ini, Context = (com.sun.star.uno.XInterface) @0 } } redirect.ini has on entry: URE_BOOTSTRAP=${ORIGIN}/fundamental.ini fundamental.ini does not have a URE_BOOTSTRAP entry. None was found in any .ini file examined. LanguageTool-1.4 was uninstalled. It was generating a runtime exception about not finding a start class, locales directory not found, it couldn't write a record because it could find saxon9-dom.jar and was reporting the use of JRE version 17 (not installed on the system). The exception continued after saxon9-dom.jar was added to the system class path and to LO Java options for jre-6.21. Do any of the issues above require corrective action? If so what needs to done and/or where should I look for answers? david -- View this message in context: http://nabble.documentfoundation.org/minor-install-config-issues-tp3247894p3247894.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]
Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware. First, why? Well after testing the file that I recreated by copying the text, formula and styles I could not cause the error to occur again. This is what I reported yesterday. I then proceeded with importing the few images and 'artwork' objects from the old file to the new. After several saves and sheet manipulations I noticed the file became unstable again. The outcome of my investigation was that one of the image files used on one of the sheets had become corrupted* and adding this file in caused the file to become unstable - eventually exhibiting the problem I mentioned about not being able to save after a sheet was deleted. These 'corrupted' files are relatively benign with the error only becoming apparent *once* you attempt to delete the sheet. So somehow the error caused problems with the broader 'workbook' structure not the sheet structure. Although I compared files between different versions of the file the XML were too varied (usually style names and definitions; content was identical). * note I say corrupted but it rendered OK and only resulted in the observed behaviour one a sheet is deleted. I 'deem' it corrupted as once replaced with a clean version render and saved as a new file by GIMP, the problem disappeared. The error was with the particular corrupt objects. On recreating new images and inserting them into a file I have not been able to trigger any problems. If I cut-and-paste from the original 'corrupt' file the file becomes unstable after a few saves and sheet manipulations. So the steps for salvage is... 1. recreate a new file with the exact number of sheets as the original. Ensure each sheet names are the same. 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the content being placed in the new file to text, numbers, date time, formulas and formats. 3. If you have images in the file. Recreate / Save using another package. As mentioned I used GIMP. 4. Insert new copies of the images into file. *Don't* cut-and-paste objects from the old file. 5. If you have any lines, text boxes and artwork; recreate them from new. During this process... - Save as a new version (+tabs, +data, +images, +other objects) following each step. - Test each version thoroughly before proceeding. - Only add one object at a time, so if something goes wrong you can isolate the problem component. - To check it is not a bug try and recreate with a fresh file. A couple of quick notes that may be valuable to others... - ODS files are archives. Use an archive facility to extract the data inside. Inspect the contents in the folders to see what is different. - On every 'Save as' the file size changes. This is not due to changes in the file contents, but rather in changes in how the components of the file is compressed/archived. If you open a file, add objects then save, the file size with be so big. Open that file and Save as a new name and the file will be a different size. If you extract the files the contents of all the files and directories are identical. It is just the internal archive facility in LO will decide the best compaction routine based on what it encounters. - The content.xml file can be quite large and has no internal end-of-line characters. This make it difficult to open and be parse by various text editors, xml viewers and comparison facilities. To insert a EOL character after the end of each tag (i.e. ), I used the following command in the terminal (requires Linux). cat content.xml | sed -e 's//\n/g' content_with_linebreaks.xml cat just spews the content of the text file to the standard output. I then pipe it to sed, where I used regular expressions to find '' and replace every instance of it with '\n'. I then compared the contents with Diffuse. On 11/08/11 14:44, jorge wrote: Congratulations,... it was an interesting investigation. Regards, Jorge Rodríguez __ El jue, 11-08-2011 a las 11:50 +1000, Simon Cropper escribió: On 10/08/11 16:41, Simon Cropper wrote: *The upshot* Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. I have drawn this conclusion because (a) I can only reproduce the error on the effected file, (b) the comment insert/delete trick is suggestive but not consistent (or at least from what I can tell) - random sheets cause the file save error if comments are inserted; inserting comments into new sheets also trigger the error. I just hope that recreating this file does not corrupt the new file as I will need to copy blocks of text, numbers and formulas. *My attempts at recreating a clean file* ATTEMPT 1 Created a new file with one less tab. All tabs were named the same as the original. I then cut-and-paste all the data from the original to this newly created file. This took about 10
Re: [libreoffice-users] Date Format in Writer
At 10:11 11/08/2011 +0100, R J Weir wrote: To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International .mm.dd format included as an option (default?) in the fields for Writer? Isn't it already there? When entering a new field: o Go to Insert | Fields | Other... | Document. o Under Type select Date and make the appropriate choice under Select. o Under Format, you can select 1999-12-31. (As has already been suggested, the international format uses hyphens, in fact, not dots.) o Alternatively, if you prefer the dots, under Format select Additional formats...; in the Number Format dialogue, under Format code, enter .MM.DD. If you have an existing date field you need to modify, either go to right-click | Fields... or put the cursor in front of the date field and go to Edit | Fields... in order to reach the same dialogues and options. Note that the default date format depends on the language of your text at that point - and the default language is that set at Tools | Options... | Language Settings | Languages | Default languages for documents | Western. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]
Hi I'm some confused. Was the comment or the image the problem ? or Both ? Regards, Jorge Rodríguez _ El vie, 12-08-2011 a las 13:52 +1000, Simon Cropper escribió: Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware. First, why? Well after testing the file that I recreated by copying the text, formula and styles I could not cause the error to occur again. This is what I reported yesterday. I then proceeded with importing the few images and 'artwork' objects from the old file to the new. After several saves and sheet manipulations I noticed the file became unstable again. The outcome of my investigation was that one of the image files used on one of the sheets had become corrupted* and adding this file in caused the file to become unstable - eventually exhibiting the problem I mentioned about not being able to save after a sheet was deleted. These 'corrupted' files are relatively benign with the error only becoming apparent *once* you attempt to delete the sheet. So somehow the error caused problems with the broader 'workbook' structure not the sheet structure. Although I compared files between different versions of the file the XML were too varied (usually style names and definitions; content was identical). * note I say corrupted but it rendered OK and only resulted in the observed behaviour one a sheet is deleted. I 'deem' it corrupted as once replaced with a clean version render and saved as a new file by GIMP, the problem disappeared. The error was with the particular corrupt objects. On recreating new images and inserting them into a file I have not been able to trigger any problems. If I cut-and-paste from the original 'corrupt' file the file becomes unstable after a few saves and sheet manipulations. So the steps for salvage is... 1. recreate a new file with the exact number of sheets as the original. Ensure each sheet names are the same. 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the content being placed in the new file to text, numbers, date time, formulas and formats. 3. If you have images in the file. Recreate / Save using another package. As mentioned I used GIMP. 4. Insert new copies of the images into file. *Don't* cut-and-paste objects from the old file. 5. If you have any lines, text boxes and artwork; recreate them from new. During this process... - Save as a new version (+tabs, +data, +images, +other objects) following each step. - Test each version thoroughly before proceeding. - Only add one object at a time, so if something goes wrong you can isolate the problem component. - To check it is not a bug try and recreate with a fresh file. A couple of quick notes that may be valuable to others... - ODS files are archives. Use an archive facility to extract the data inside. Inspect the contents in the folders to see what is different. - On every 'Save as' the file size changes. This is not due to changes in the file contents, but rather in changes in how the components of the file is compressed/archived. If you open a file, add objects then save, the file size with be so big. Open that file and Save as a new name and the file will be a different size. If you extract the files the contents of all the files and directories are identical. It is just the internal archive facility in LO will decide the best compaction routine based on what it encounters. - The content.xml file can be quite large and has no internal end-of-line characters. This make it difficult to open and be parse by various text editors, xml viewers and comparison facilities. To insert a EOL character after the end of each tag (i.e. ), I used the following command in the terminal (requires Linux). cat content.xml | sed -e 's//\n/g' content_with_linebreaks.xml cat just spews the content of the text file to the standard output. I then pipe it to sed, where I used regular expressions to find '' and replace every instance of it with '\n'. I then compared the contents with Diffuse. On 11/08/11 14:44, jorge wrote: Congratulations,... it was an interesting investigation. Regards, Jorge Rodríguez __ El jue, 11-08-2011 a las 11:50 +1000, Simon Cropper escribió: On 10/08/11 16:41, Simon Cropper wrote: *The upshot* Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. I have drawn this conclusion because (a) I can only reproduce the error on the effected file, (b) the comment insert/delete trick is suggestive but not consistent (or at least from what I can tell) - random sheets cause the file save error if comments are inserted; inserting comments into new sheets also trigger the error. I just hope that recreating this file does not corrupt the new file as I will need
Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]
On Fri, 2011-08-12 at 13:52 +1000, Simon Cropper wrote: Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware. First, why? Well after testing the file that I recreated by copying the text, formula and styles I could not cause the error to occur again. This is what I reported yesterday. I then proceeded with importing the few images and 'artwork' objects from the old file to the new. After several saves and sheet manipulations I noticed the file became unstable again. The outcome of my investigation was that one of the image files used on one of the sheets had become corrupted* and adding this file in caused the file to become unstable - eventually exhibiting the problem I mentioned about not being able to save after a sheet was deleted. These 'corrupted' files are relatively benign with the error only becoming apparent *once* you attempt to delete the sheet. So somehow the error caused problems with the broader 'workbook' structure not the sheet structure. Although I compared files between different versions of the file the XML were too varied (usually style names and definitions; content was identical). * note I say corrupted but it rendered OK and only resulted in the observed behaviour one a sheet is deleted. I 'deem' it corrupted as once replaced with a clean version render and saved as a new file by GIMP, the problem disappeared. The error was with the particular corrupt objects. On recreating new images and inserting them into a file I have not been able to trigger any problems. If I cut-and-paste from the original 'corrupt' file the file becomes unstable after a few saves and sheet manipulations. So the steps for salvage is... 1. recreate a new file with the exact number of sheets as the original. Ensure each sheet names are the same. 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the content being placed in the new file to text, numbers, date time, formulas and formats. 3. If you have images in the file. Recreate / Save using another package. As mentioned I used GIMP. 4. Insert new copies of the images into file. *Don't* cut-and-paste objects from the old file. 5. If you have any lines, text boxes and artwork; recreate them from new. During this process... - Save as a new version (+tabs, +data, +images, +other objects) following each step. - Test each version thoroughly before proceeding. - Only add one object at a time, so if something goes wrong you can isolate the problem component. - To check it is not a bug try and recreate with a fresh file. A couple of quick notes that may be valuable to others... - ODS files are archives. Use an archive facility to extract the data inside. Inspect the contents in the folders to see what is different. - On every 'Save as' the file size changes. This is not due to changes in the file contents, but rather in changes in how the components of the file is compressed/archived. If you open a file, add objects then save, the file size with be so big. Open that file and Save as a new name and the file will be a different size. If you extract the files the contents of all the files and directories are identical. It is just the internal archive facility in LO will decide the best compaction routine based on what it encounters. - The content.xml file can be quite large and has no internal end-of-line characters. This make it difficult to open and be parse by various text editors, xml viewers and comparison facilities. To insert a EOL character after the end of each tag (i.e. ), I used the following command in the terminal (requires Linux). cat content.xml | sed -e 's//\n/g' content_with_linebreaks.xml cat just spews the content of the text file to the standard output. I then pipe it to sed, where I used regular expressions to find '' and replace every instance of it with '\n'. I then compared the contents with Diffuse. Snip +1 I wonder how the images got corrupted, interesting. Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Hi Thank you, I understand now. I used it as you say and I could modify all the headers (The first Column included), but the data headers (Where the sum, average or other calcs are), change to its original formats when the pilot data is refreshed (The first column header and Data Title keep its format changed. Regards, Jorge Rodríguez _ El jue, 11-08-2011 a las 11:24 +0200, Andreas Säger escribió: Am 11.08.2011 01:28, jorge wrote: Hi I'm sorry but I made an example with Style and the first column header (Title) wasn't changed. Besides, I refreshed the pilot table and lost the headers format. What did I wrong ? The pilot uses one distinct set of automatically generated styles. For column headers in the English GUI the style is named DataPilot_Category. When the pilot is rebuilt on refresh, all formatting falls back to that style. - Application of some other style will be reset to DataPilot_Category. - Hard attributes will be reset to the bare DataPilot_Category settings. - Modifying DataPilot_Category itself will format both, row headers and column headers. -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Date Format in Writer
FWIW - I prefer mmmdd or ddmmm where the 'm' is alphabetic; - unambiguous! nvsoar On Thu, Aug 11, 2011 at 1:46 PM, Stan Goodman stan.good...@hashkedim.comwrote: On Thursday 11 August 2011 22:40:04 planas wrote: Johnny On Thu, 2011-08-11 at 12:36 +0200, Johnny Rosenberg wrote: 2011/8/11 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Ahhah, great. I prefer dashes - because after reading too much for too long my eyes get a bit muddled when people use / and dots still seem to confuse obscure Windows systems sometimes. I was told that the / was the European Standard but if - are used in one other country then that helps me argue the case with my boss. I though that ”/” was the US standard… Here (Sweden) we follow the ISO8601, except for time. Seems like we use dots instead of colons. / with mm/dd/ is the normal US standard (sometimes mm.dd. because / is mis interpreted in file names). Most Americans who have dealt with international trade are comfortable with either US or ISO styles and for dates. Wish we and the rest of the world could just adapt the ISO 8601. There is a reason for why it was created… And personally I use it all the time. And of course every ”dygn” (sorry, there is no English translation for that word - yet…) is 24 hours, so why that silly 12 hour thing? If all analogue watches were made 24 hours, you could very easily also use it as a compass, at least when you can see the sun (if the hour hand point to the sun, then 24, or rather 0, will point to north, 6 to east, 12 to south and 18 to west). How can it be easier than that? When I was in elementary school we were taught a 12 hour cycle with AM and PM to determine if it was morning or afternoon/evening. The US military, I believe, uses the 24 hour clock because 0900 is always in the morning while evening equivalent 2100 is always in the evening/night, much less likely to be misunderstood. Regards Johnny Rosenberg ジョニー・ローゼンバーグ 2011-08-11 12:36:51 Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 11 August, 2011 11:18:39 Subject: Re: [libreoffice-users] Date Format in Writer 2011/8/11 rjw...@phonecoop.coop: To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the less ambiguous International It IS international, it's ISO 8601 (and also Swedish standard, lucky me… ;P)! Except that there should be dashes, not dots: -mm-dd. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ .mm.dd format included as an option (default?) in the fields for Writer? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscr ibe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubsc ribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubsc ribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted There is a limit to how comfortable such people can be, living in a mixed envirenment and trying to juggle mm/dd/ and dd/mm/. I wonder how many schedules or appointments have been missed, how much money lost, because of misinterpreting 8/11/2011 as a date in November rather than one in August, or vice versa. Not to mention applications that know only mm/dd/ although the OS is set for dd/mm/ (as here), so that one must analyse every date that is displayed. -- Stan Goodman Qiryat Tiv'on Israel -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted