[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2019-03-31 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 Andreas Zieritz changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-28 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de ---

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=120149 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

2018-09-27 Thread bugzilla-daemon
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