Re: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc
Just a thought I do not know if Widows 7 has compatibility mode, but if it does, try Windows XP compatibility and see if the problem goes away. regards John B - On 17/07/2011 14:26, John B wrote: Hi On my XP SP3, LO 3.4. build 1OOO340m1 (Build:103) - the same as yours I saved as .ods, .xls, .xls (95) .xml and .xmlx, and they all came back perfect Must be a Windows 7, and an iMac bug - worth a report. regards John B -- On 17/07/2011 13:31, Tom Davies wrote: Hi :) I try to make it a triple negative by using red, brackets and a minus sign just to equally annoy everyone Regards from Tom :) From: Tinkererj_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 12:56:35 Subject: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc I have just realised. When showing negative numbers in Red, you should not prefix the number with the minus sign. This makes it a double negative, therefore making the number Red should be minus the minus sign. BTW. Is that a pun? Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3176644.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Displaying Negative Numbers as red in Calc
I have just realised. When showing negative numbers in Red, you should not prefix the number with the minus sign. This makes it a double negative, therefore making the number Red should be minus the minus sign. BTW. Is that a pun? Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3176644.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Displaying Negative Numbers as red in Calc
Hi :) I try to make it a triple negative by using red, brackets and a minus sign just to equally annoy everyone Regards from Tom :) From: Tinkerer j_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 12:56:35 Subject: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc I have just realised. When showing negative numbers in Red, you should not prefix the number with the minus sign. This makes it a double negative, therefore making the number Red should be minus the minus sign. BTW. Is that a pun? Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3176644.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Displaying Negative Numbers as red in Calc
Hi On my XP SP3, LO 3.4. build 1OOO340m1 (Build:103) - the same as yours I saved as .ods, .xls, .xls (95) .xml and .xmlx, and they all came back perfect Must be a Windows 7, and an iMac bug - worth a report. regards John B -- On 17/07/2011 13:31, Tom Davies wrote: Hi :) I try to make it a triple negative by using red, brackets and a minus sign just to equally annoy everyone Regards from Tom :) From: Tinkererj_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 12:56:35 Subject: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc I have just realised. When showing negative numbers in Red, you should not prefix the number with the minus sign. This makes it a double negative, therefore making the number Red should be minus the minus sign. BTW. Is that a pun? Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3176644.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Displaying Negative Numbers as red in Calc
Tom How do you do it? I try to make it a triple negative by using red, brackets and a minus sign. Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3176846.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Displaying Negative Numbers as red in Calc
I have an iMac, System 10.6.8 and Libre 3.4.1 In Calc I have no problems with red negatives, two decimal places and comma separated thousands when saved as odf However, when saved as xls, the red negatives are all black, but the thousand separator and the two decimals are OK. In xml, fods, format, everything works OK. Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3172925.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Displaying Negative Numbers as red in Calc
Hi :) That sounds like a bug to me http://wiki.documentfoundation.org/BugReport On Ubuntu the LibreOffice 3.3.2 has no trouble. Can you try the 3.3.3 to see if you have the same trouble? http://wiki.documentfoundation.org/Installing_in_parallel Regards from Tom :) From: Tinkerer j_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Fri, 15 July, 2011 19:47:00 Subject: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc I have an iMac, System 10.6.8 and Libre 3.4.1 In Calc I have no problems with red negatives, two decimal places and comma separated thousands when saved as odf However, when saved as xls, the red negatives are all black, but the thousand separator and the two decimals are OK. In xml, fods, format, everything works OK. Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3172925.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Displaying Negative Numbers as red in Calc
Tom, Yes, it appears to be a bug in 3.4.1. I uninstalled 3.4.1, installed 3.3.3 and the display now works as expected. I will submit a bug report in the near future. Oh, and for what it is worth, I am running Windows 7 64-bit. Thank you. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3173362.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: Displaying Negative Numbers as red in Calc
Hi :) The guide for installing 2 versions of LO on the same machine might need a bit of thinking about but it should work http://wiki.documentfoundation.org/Installing_in_parallel It is possible to buy Dvd versions to avoid having to download and they tend to be very reasonably priced Regards from Tom :) From: Tinkerer j_taylo...@btinternet.com To: users@global.libreoffice.org Sent: Fri, 15 July, 2011 22:48:52 Subject: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc On 15 Jul 2011, at 22:15, bikerbrent [via Document Foundation Mail Archive] wrote: Tom, Yes, it appears to be a bug in 3.4.1. I uninstalled 3.4.1, installed 3.3.3 and the display now works as expected. I will submit a bug report in the near future. Oh, and for what it is worth, I am running Windows 7 64-bit. Many thanks. I have been having trouble with my downloads of late. Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3173450.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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 -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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