Re: [libreoffice-users] java error
Il 23/01/2013 07:55, Gabriel Risterucci ha scritto: This is a dump file, made when the JVM crash. If you have regular crash, it can be helpful to find the cause. If you found only one, it mean only one crash, so it's probably not a big problem. To answer your question, it's complicated to tell who is at fault for this one: it seem that a call to getenv() caused a segfault, which seems odd. Only cause I can see for this is calling getenv() with a NULL value, which would be quite hard from a Java program since the call should be wrapped by the JVM, but it's not impossible either. thanks. yes, I found it only once till now. soffice.bin sometimes shows some strange behaviour... I will see if i find other similar errors. -- Cley Faye http://cleyfaye.net 2013/1/23 Paolo Debortoli paolo_debort...@yahoo.com mailto:paolo_debort...@yahoo.com hi. i have found (ubuntu with libreoffice 4.0) a file named 'hs_err_pid11845.log' saying: A fatal error has been detected by the Java Runtime Environment: # # SIGSEGV (0xb) at pc=0x7f5a779caf5c, pid=11845, tid=140025396197120 # # JRE version: 7.0_09-b30 # Java VM: OpenJDK 64-Bit Server VM (23.2-b09 mixed mode linux-amd64 compressed oops) # Problematic frame: # C [libc.so.6+0x3af5c] getenv+0x9c # # Failed to write core dump. Core dumps have been disabled. To enable core dumping, try ulimit -c unlimited before starting Java again . Dynamic libraries: 0040-00401000 r-xp 08:05 41859 /opt/libreoffice4.0/program/soffice.bin 0060-00601000 rw-p 08:05 41859 /opt/libreoffice4.0/program/soffice.bin etc... etc... is it a problem with java or with LO ? -- www.libreoffice.org http://www.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org mailto:users%2bh...@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 -- www.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
[libreoffice-users] how to tell m$ about ods formula behaviour failure
Readers, Despite the opinion of the original poster (https://bugs.freedesktop.org/show_bug.cgi?id=38113), the loss in information is not the fault of LO, but m$, who claim not to support such compatibility (http://office.microsoft.com/en-za/excel-help/differences-between-the-opendocument-spreadsheet-ods-format-and-the-excel-xlsx-format-HA010355787.aspx). In the differences web page published by m$, it is also claimed that formulas are supported. When a spreadsheet was created in LO (of course to the native ods format, because we are not using LO as a free m$ clone and saving documents to m$ formats, but instead using ods to promote odf, aren't we??? ;) ), after opening in m$ excel 2010 (yes, m$ can open ods spreadsheets, so use that format please!!!) , the formulas were lost, leaving only the result values in the spreadsheet cells. Instead of reporting another erroneous LO bug, does someone know how to forward this error with m4 excel 2010 to m$ bug reporting service? Thanks. -- 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 tell m$ about ods formula behaviour failure
Hi e-letter, e-letter schrieb: Readers, Despite the opinion of the original poster (https://bugs.freedesktop.org/show_bug.cgi?id=38113), the loss in information is not the fault of LO, but m$, who claim not to support such compatibility (http://office.microsoft.com/en-za/excel-help/differences-between-the-opendocument-spreadsheet-ods-format-and-the-excel-xlsx-format-HA010355787.aspx). In the differences web page published by m$, it is also claimed that formulas are supported. When a spreadsheet was created in LO (of course to the native ods format, because we are not using LO as a free m$ clone and saving documents to m$ formats, but instead using ods to promote odf, aren't we??? ;) ), after opening in m$ excel 2010 (yes, m$ can open ods spreadsheets, so use that format please!!!) , the formulas were lost, leaving only the result values in the spreadsheet cells. LO saves to ODF1.2, but Excel 2010 does not claim to support that version, but only supports ODF1.1. Excel 2010 does not claim to support OpenFormula, but supports only its own formula namespace. So it is not a bug in Excel 2010 but a missing feature. Showing the result is better than LO does. LO shows an error message when getting an unknown function. So there is no need to tell Microsoft a bug. Instead of reporting another erroneous LO bug, does someone know how to forward this error with m4 excel 2010 to m$ bug reporting service? Register for the trial of Excel 2013. It has an icon to report bugs. But be aware, that Excel 2013 supports ODF1.2. If you find, that a document, that has been generated by LO and which has no foreign elements (elements which are not defined in ODF1.2 but are in the OpenOffice.org or LibreOffice namespace) is not treated correctly in Excel 2013, than sent a bug report via this icon. Kind regards Regina -- 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] [Solved] Re: Keyboard Shortcuts for Buttons in Base
Hi Tom Drew, Thanks for your replies. I've been on holiday for a week, but prior to that I came up with a work around that sort of worked, but was pretty clunky! Thanks Drew for letting me know about using the tilde - it was exactly what I was looking for. (Although for a start I thought it wasn't working - the underlined letter shows up at run time but not in design mode!) Thanks again, Noel -- Noel Lodge lodg...@gmail.com -- View this message in context: http://nabble.documentfoundation.org/Keyboard-Shortcuts-for-Buttons-in-Base-tp4026266p4029949.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 -- 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] First occurrence of a negative number in a column
Den 23.01.2013 14:32, skreiv Brian Barker: At 13:44 23/01/2013 +0100, Kolbjørn Stuestøl wrote: Den 23.01.2013 07:29, skreiv Brian Barker: At 22:57 22/01/2013 +0100, Kolbjørn Stuestøl wrote: Is there any way to find the first occurrence of a number less (or greater) than a given number in an unsorted array or a column? Example: A1:A31 contains a list of temperatures a given month. I would like to find the first day the temperature is below 0 degrees (metric). What happens if there is no day in the month when the temperature was negative? Let's say you want the value zero for the resulting day number in this case. This is a little messy, but it works: o In B1, enter =A10 and fill it down the column to B31. This generates TRUE for your negative values and FALSE otherwise. o In your result cell, enter =N(MATCH(TRUE;B1:B31;0)) . The MATCH() function searches for the first TRUE value in the column B values and returns the relative position in the array of the first match. (Note that this is not necessarily the row number, though will be in your example.) This would return the #N/A error if there is no negative temperature; the N() function makes no change to real dates but converts this error to zero. Alas the N() function does not works as supposed. It returns #N/A if there are no numbers below zero. I have to figure out a solution. Oh dear: sorry. It indeed appears that the behaviour of N() was changed (between versions 3.5. and 3.6) and it no longer works as I'd imagined. So you'll need something (even messier) such as =IF(ISERROR(MATCH(TRUE;B1:B31;0));0;MATCH(TRUE;B1:B31;0)) instead. Thanks. I think this will help me out. Although I would have preferred a simpler version :-) I am new to LibreOffice. I do have a working program calculating meteorological statistics written in a Pascal variant many years ago. But rewriting it in Calc 4.0 just to learn a bit about this program too. Kolbjoern 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
[libreoffice-users] Reconnaissance vocale
Bonjour, Je suis surpris de ne pas pouvoir utiliser la reconnaissance vocale de Windows 7 avec Writer alors que cela fonctione avec Wordpad. J'ai essayé de choisir les enregistrements .odt, .doc (2003), et .rtf rien n'y fait. Merci pour votre aide -- 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 tell m$ about ods formula behaviour failure
ODF 1.0/1.1 did not specify a standard for spreadsheet formulas. Formulas were left implementation-specific. Microsoft did not support the OpenOffice.org-specific formulas. Instead, they used Excel-specific formulas in ODF 1.1. On input of a not-supported formula expression, Excel in Office 2007 and 2010 drops the formula and preserves the last-calculated value. Whether a wise choice or not, that is what's done. As Regina says, Office 2013 supports ODF 1.2, including its OpenFormula specification. OpenFormula is also used by current implementations of LibreOffice and Apache OpenOffice when their documents are saved as ODF 1.2, so there is interoperability of formulas shared between ODF 1.2 implementing software. - Dennis -Original Message- From: James Knott [mailto:james.kn...@rogers.com] Sent: Wednesday, January 23, 2013 05:20 To: LibreOffice Subject: Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure e-letter wrote: after opening in m$ excel 2010 (yes, m$ can open ods spreadsheets, so use that format please!!!) , the formulas were lost, leaving only the result values in the spreadsheet cells. Instead of reporting another erroneous LO bug, does someone know how to forward this error with m4 excel 2010 to m$ bug reporting service? That is a well known feature of MS Office. Excel would replace formulas with calculated values. For some reason, MS thought that was appropriate, even though no other spreadsheet app does that. This was back in the days when MS was ramming their OOXML standard through ISO. I believe, though don't know, that this has been corrected in later versions of MS Office. This is one bug that can be laid squarely at the feet of MS and one might even suspect it was deliberate. Bottom line, there's nothing for LO to fix. -- 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] Reconnaissance vocale
Bonjour Henry, all, I'm redirecting Henry on the FR user list. On 23/01/2013 16:43, Henry SCHOORENS wrote: Bonjour, Je suis surpris de ne pas pouvoir utiliser la reconnaissance vocale de Windows 7 avec Writer alors que cela fonctione avec Wordpad. J'ai essayé de choisir les enregistrements .odt, .doc (2003), et .rtf rien n'y fait. Vous avez posté sur une liste dont la langue est l'anglais. Pour obtenir de l'aide de la communauté des utilisateurs francophones, vous pouvez vous inscrire sur la liste ou utiliser Nabble. Toutes les instructions sont données ici : http://fr.libreoffice.org/forums/ Merci également d'indiquer la version de LibreOffice que vous utilisez. Bien cordialement Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org Tel:+33683901545 Membership Certification Committee Member - Co-founder The Document Foundation -- 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] First occurrence of a negative number in a column
Hi :) Working out the first day temperatures plummeted below zero here was the only day this year that i got a chance to sleep outdoors. I completely missed all of the long hot summer due to moving. I got a bit of a surprise when i poked my head out of ny bivvie and saw the landscape covered in frost! Regards from Tom :) From: Kolbjørn Stuestøl kolbjo...@stuestoel.no To: users@global.libreoffice.org Sent: Wednesday, 23 January 2013, 15:16 Subject: Re: [libreoffice-users] First occurrence of a negative number in a column Den 23.01.2013 14:32, skreiv Brian Barker: At 13:44 23/01/2013 +0100, Kolbjørn Stuestøl wrote: Den 23.01.2013 07:29, skreiv Brian Barker: At 22:57 22/01/2013 +0100, Kolbjørn Stuestøl wrote: Is there any way to find the first occurrence of a number less (or greater) than a given number in an unsorted array or a column? Example: A1:A31 contains a list of temperatures a given month. I would like to find the first day the temperature is below 0 degrees (metric). What happens if there is no day in the month when the temperature was negative? Let's say you want the value zero for the resulting day number in this case. This is a little messy, but it works: o In B1, enter =A10 and fill it down the column to B31. This generates TRUE for your negative values and FALSE otherwise. o In your result cell, enter =N(MATCH(TRUE;B1:B31;0)) . The MATCH() function searches for the first TRUE value in the column B values and returns the relative position in the array of the first match. (Note that this is not necessarily the row number, though will be in your example.) This would return the #N/A error if there is no negative temperature; the N() function makes no change to real dates but converts this error to zero. Alas the N() function does not works as supposed. It returns #N/A if there are no numbers below zero. I have to figure out a solution. Oh dear: sorry. It indeed appears that the behaviour of N() was changed (between versions 3.5. and 3.6) and it no longer works as I'd imagined. So you'll need something (even messier) such as =IF(ISERROR(MATCH(TRUE;B1:B31;0));0;MATCH(TRUE;B1:B31;0)) instead. Thanks. I think this will help me out. Although I would have preferred a simpler version :-) I am new to LibreOffice. I do have a working program calculating meteorological statistics written in a Pascal variant many years ago. But rewriting it in Calc 4.0 just to learn a bit about this program too. Kolbjoern 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 -- 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] LibreOffice 3.6.4 Romanian installer translation is HORRIBLY broken
Hi, I have recently tried to install LibreOffice 3.6.4 on my Windows 7 PC, and since my system locale is set to Romanian, the LibreOffice .msi installer also defaulted to Romanian as the installation language. As a native Romanian speaker, I can vouch that the translation job is so extremely poor that I couldn't go forward with the installation, since I wasn't sure what features I was installing. I do not remember this happening before 3.6. I am reporting this for the LibreOffice installer only, since I have no idea if and how broken the LibreOffice translation is. I changed my system locale to English so that I could install the LibreOffice package. I have never, ever seen an English to Romanian translation so utterly broken. I know this is a volunteer-run project, but such oversights are absolutely inexcusable in a project so big as this. Please fix this as soon as possible, because it's embarrassing and reeks of lack of professionalism. At least revert to some older version, or have some competent Romanian people take a look at the translation before releasing it. Thank you. -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-6-4-Romanian-installer-translation-is-HORRIBLY-broken-tp4031344.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] Base Query Sort and Reports
LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) I have created a query from one table. In the query design grid I sort, ascending, on a 'name' field. The query works as expected with results sorted on the 'name' field. When creating a report, using the wizard, with the query as the source, no matter what I do the query sort does not carry over to the report. It appears that no matter what field the query is sorted on, the report always sorts via the ID field, which is also the primary key. I have tried using the query sort, then using the same field in the report's sort option; I've tried using the report control to change SQL Command as source to the query, and order by 'name' in the report control. All of this makes no change. The report does not sort the way the query is made. Any help would be appreciated. Thanks. -- View this message in context: http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350.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] Now using LibreOffice: Need help with files created in OpenOffice...
Hello, I recently upgraded my OS from Kubuntu 8.04 with OpenOffice 2.4 to Kubuntu 12.04 with LibreOffice. Unfortunately, when I open a file in LibreOffice that was created in OpenOffice, the text on one page now flows over to a second page. My laptop has LibreOffice, and I compared all line spacing, margin settings. etc. to the same document on another desktop that still has OpenOffice 2.4 installed.All settings look identical. In fact, I am comparing the same document using a flash drive to go between systems. Has anyone had a similar problem?How do I resolve this without reformatting the entire document? I'll be happy to send screen shots, if that will help. -- Red bar **John Bentham** Global Marketing Communications Social Media Community Professional jbent...@yahoo.com mailto:jbent...@yahoo.com. +1 (512) 828-1930 LinkedIn Profile http://www.linkedin.com/in/bentham Twitter @john_bentham http://twitter.com/john_bentham -- 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: Base Query Sort and Reports
There was a bug in LO 3.5.x versions discussed at the end of this post http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159i20.html#a3961330 which might be relevant to you. I seem to recall any query you use in a report is not automatically updated when you edit/amend the corresponding query via the LO query list, so you have to manually 'paste' any changed query code into the mentioned COMMAND control of the report. Maybe that's the reason for your problem. -- View this message in context: http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350p4031362.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] Now using LibreOffice: Need help with files created in OpenOffice...
On 01/23/2013 06:26 PM, John Bentham wrote: Hello, I recently upgraded my OS from Kubuntu 8.04 with OpenOffice 2.4 to Kubuntu 12.04 with LibreOffice. Unfortunately, when I open a file in LibreOffice that was created in OpenOffice, the text on one page now flows over to a second page. My laptop has LibreOffice, and I compared all line spacing, margin settings. etc. to the same document on another desktop that still has OpenOffice 2.4 installed.All settings look identical. In fact, I am comparing the same document using a flash drive to go between systems. Has anyone had a similar problem?How do I resolve this without reformatting the entire document? I'll be happy to send screen shots, if that will help. I had this problem with the OOo 3.0 with LO 3.3. The problem then was the default fonts. LO installs some fonts and uses them for the defaults. Are the fonts you are using in the .fonts hidden folder? I have heard than some systems had OOo and LO fonts installed in other folders than the .fonts folder, including the .libreoffice/3/user/fonts folder. I keep that folder empty and only use the font files in the.fonts folder. OOo may have a similar package defined folder where it places some of the fonts, like LO does. There seems to be some differences in some fonts that seem to have the same name. I use Ubuntu 12.04 and 12.10 with the MATE desktop environment instead of the KDE desktop environment, but I have that option installed if I want to open Ubuntu using the KDE d.e.. KDE's System Settings - Font Management utility will group your fonts into System and Personal fonts. My used document fonts tend to alway be listed on the Personal font list and not the System font list. There are a lot of fonts in the System font list I never used and many were installed by Ubuntu 12.04 that were not installed with 10.04. Then things change again with 12.10. ALSO, even if the font that is displayed on the font drop down menu for the document, does not mean you actually have that font installed in the laptop. If you create a document with Al Heavenly for the text, then place it on a flash drive and open it with a different laptop, the font name of Al Heavenly willshow in the document even though the second laptop does not have that font installed. It shows the font that is tagged with the text and does not have than font grayed-out or other indicator that you do not have it installed. So have you checked your font folder[s] to make sure the font is installed in bothsystems? I tend toinstall a set of fonts on all my systems so I do not have this problem. When you have over 100,000 [14 GB] of font files on your system, with a few hundred installed at any one time, it can be a problem to make sure you have the needed fonts installed for a document, if you keep changing which fonts are installed on your 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