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

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120149

--- Comment #9 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
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.000000 

notice: there is a leading and trailing space,
xml representation is "string" too:

content.xml:
<table:table-cell office:value-type="string" calcext:value-type="string">
  <text:p>
  <text:s/>10.000000 </text:p>
</table:table-cell>

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180927/f6a3fb84/attachment.html>