[users] Re: Hot question, need advice (Linux2MacOSX)
i try set , and . as comma symbol, but won't work with csv :( scientific number look like 1E-19 -- All the best. From Pavel V Subach 23.03.2011, в 22:26, Johnny Rosenberg написал(а): ons 2011-03-23 klockan 22:09 +0600 skrev Павел Субач: I live in Russia, and set Russian preferences, but i try switch comma in configuration, can't do this (switch ok, but not effect). Ok, i will save as non CSV format, but how i can remove E and show full 19 symbols decimal ? (0,001). Need for work, show traffic and analyzing it... -- All the best. From Pavel V Subach Tell me EXACTLY what you are doing when you try to import that CSV file. Are your operativsystem set to Russian in every aspect? Do you use comma for decimal separator in Russia? Exactly what does those scientific numbers look like? Is it like ”1E-19” or ”1e-19” or is there a space somewhere, like ”1 e-19” or similar? -- Best regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help smime.p7s Description: S/MIME cryptographic signature
[users] Re: Hot question, need advice (Linux2MacOSX)
I live in Russia, and set Russian preferences, but i try switch comma in configuration, can't do this (switch ok, but not effect). Ok, i will save as non CSV format, but how i can remove E and show full 19 symbols decimal ? (0,001). Need for work, show traffic and analyzing it... -- All the best. From Pavel V Subach 22.03.2011, в 21:27, Johnny Rosenberg написал(а): mån 2011-03-21 klockan 21:46 +0600 skrev Павел Субач: Hot question: - How to remove E and show full length decimal number ?? - How to convert .009 - 0,009 when import in calc from CSV format ??? In previous version, but for Linux (OpenOffice 3.1), it was perfect show my decimal with 19-20 zero after zero, without E (decimal has anything size) And convert .009-0,009 use English(USA), when import document But all is it won't work in LibreOffice 3.3 and OpenOffice 3.3 for MacOSX I have Ubuntu 10.10 (Linux), OpenOffice.org 3.3.0 and LibreOffice 3.3.1. I created a simple CSV using my text editor, Gedit and I opened it in OpenOffice.org and LibreOffice. I selected English (USA) and I also tried English (GBR) and it worked properly in both cases: The decimal points were converted to decimal commas, which is correct in my case, since my system is set to Swedish, and we use decimal commas here. So I don't know what you are doing wrong, but it works as expected for me. -- Best regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help smime.p7s Description: S/MIME cryptographic signature
[users] Re: Hot question, need advice (Linux2MacOSX)
ons 2011-03-23 klockan 22:09 +0600 skrev Павел Субач: I live in Russia, and set Russian preferences, but i try switch comma in configuration, can't do this (switch ok, but not effect). Ok, i will save as non CSV format, but how i can remove E and show full 19 symbols decimal ? (0,001). Need for work, show traffic and analyzing it... -- All the best. From Pavel V Subach Tell me EXACTLY what you are doing when you try to import that CSV file. Are your operativsystem set to Russian in every aspect? Do you use comma for decimal separator in Russia? Exactly what does those scientific numbers look like? Is it like ”1E-19” or ”1e-19” or is there a space somewhere, like ”1 e-19” or similar? -- Best regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Hot question, need advice (Linux2MacOSX)
mån 2011-03-21 klockan 21:46 +0600 skrev Павел Субач: Hot question: - How to remove E and show full length decimal number ?? - How to convert .009 - 0,009 when import in calc from CSV format ??? In previous version, but for Linux (OpenOffice 3.1), it was perfect show my decimal with 19-20 zero after zero, without E (decimal has anything size) And convert .009-0,009 use English(USA), when import document But all is it won't work in LibreOffice 3.3 and OpenOffice 3.3 for MacOSX I have Ubuntu 10.10 (Linux), OpenOffice.org 3.3.0 and LibreOffice 3.3.1. I created a simple CSV using my text editor, Gedit and I opened it in OpenOffice.org and LibreOffice. I selected English (USA) and I also tried English (GBR) and it worked properly in both cases: The decimal points were converted to decimal commas, which is correct in my case, since my system is set to Swedish, and we use decimal commas here. So I don't know what you are doing wrong, but it works as expected for me. -- Best regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help