[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 Andreas Zieritz changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||4420 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 --- Comment #11 from Oliver Brinzing --- > But then my first question is, why can I do calculation with strings at all? please have a look at: https://help.libreoffice.org/Calc/Converting_Text_to_Numbers > The other thing is that you should have a look at "Data/Text to columns...", > because I really would not understand what this function would do. with "Locale Setting" Englisch (UK) - select column B - open dialog Data/Text to columns... - press [OK] this function will convert text values to float. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 --- Comment #10 from Andreas Zieritz --- Apparently there are 2 things going on here. 1.) Decimal delimiters 2.) Type of content Apparently the contents of the cells are strings. The only way to see that is checking View/Value Highlighting. But then my first question is, why can I do calculation with strings at all? As the calculations do show, I can divide the contents of the cell by 10, and do the same logical test to those results. And voila - the result suddenly is correct. In my opinion, a string '+' of 10 + 10 should be 1010, and not 20, as it actually does. So those operations do not behave like string operations, but numeric ones. But when it comes to > they do behave like string operations. The other thing is that you should have a look at "Data/Text to columns...", because I really would not understand what this function would do. But ok, if I do open this function, I can choose e.g. column B. Column type however gives me no choice to choose anything useful (standard, text, date). Maybe I am missing something here. Last thing: Wouldn't it be nice if LibreOffice used the Windows Decimal Delimiter setting for Windows builds? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #8 from Roman Kuznetsov <79045_79...@mail.ru> --- read about locale settings for decimal separator and about problems with working in Calc when you import data from one locale to another -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 --- Comment #9 from Oliver Brinzing --- ok, i changed my settings to "English (UK)" and after a restart i opened your test file: numbers are displayed (e.g. B6) as text: ' 10.00 notice: there is a leading and trailing space, xml representation is "string" too: content.xml: 10.00 you can select each row and use Menu "Data/Text to Columns..." to convert text to numbers, or, if your source data file is a *.csv for example, you will see the "Text Import" dialog during opening. tip: select Menu "View/Value Highlighting", so numbers will appear blue. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 --- Comment #7 from Oliver Brinzing --- (In reply to Andreas Zieritz from comment #6) > Yes, correct. > I changed that one to English / Great Britain, and checked Decimal Delititer > to local setting(.). > Btw., I have no idea what it means if this checkbox is unticked. from help: Decimal separator key - Same as locale setting Specifies to use the decimal separator key that is set in your system when you press the respective key on the number pad. If this checkbox is activated, the character shown after "Same as locale setting" is inserted when you press the key on the number pad. If this checkbox is not activated, the character that your keyboard driver software provides is inserted. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 --- Comment #6 from Andreas Zieritz --- Yes, correct. I changed that one to English / Great Britain, and checked Decimal Delititer to local setting(.). Btw., I have no idea what it means if this checkbox is unticked. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #5 from Oliver Brinzing --- (In reply to Andreas Zieritz from comment #4) > We need to have dot as decimal delimiter, there are other programs that > require that. > > In Windows settings we have changed that setting on all PC's. > > I have manually set language to english for that file. Did you change "Tools/Options.../Language Settings/Languages" -> Locale Setting ? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 --- Comment #4 from Andreas Zieritz --- We need to have dot as decimal delimiter, there are other programs that require that. In Windows settings we have changed that setting on all PC's. I have manually set language to english for that file. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 --- Comment #3 from Roman Kuznetsov <79045_79...@mail.ru> --- Created attachment 145207 --> https://bugs.documentfoundation.org/attachment.cgi?id=145207=edit Test file after replace all dots to commas -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||79045_79...@mail.ru --- Comment #2 from Roman Kuznetsov <79045_79...@mail.ru> --- In your file all numbers have a dot as decimal separator and set up Norvegian language for cells. But in this country should be comma as decimal separator. Replace all dots to commas and check your "problem" else one IMHO -> NOTABUG -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120149] Calc gives wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 --- Comment #1 from Andreas Zieritz --- Created attachment 145206 --> https://bugs.documentfoundation.org/attachment.cgi?id=145206=edit Testfile for checking numbers Check field N69 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs