[Libreoffice-bugs] [Bug 125154] New: writer calculation using variable within table does not work with formated numbers

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue May 7 12:43:13 UTC 2019


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

            Bug ID: 125154
           Summary: writer calculation using variable within table does
                    not work with formated numbers
           Product: LibreOffice
           Version: 6.2.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: one at frostinfo.de

Description:
using Libre Office portable 6.2.2.2

Steps to Reproduce:
1. create table
2. select cell (a) set variable with value 1000, number formating with thousand
separator i.e. #.##0
3. select another cell (b) and insert value of variable using "show variable",
number formating with thousand separator i.e. #.##0
4. select a third cell (c), press F2 and enter cell b x 10
5. press F9 to calculate values

Actual Results:
cell c gives 0 as result

Expected Results:
cell c should give 1000 x 10 = 10.000 as result


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
change the numberformat of the variable in cell b to no thousand separator,
press F9
-> cell c shows the correct value of 10.000

this is reproducible with other formating that contains non digits 
(like adding m² #.##0" m²")

reproducable on two machines

this issue was observed after changing from LibreOffice portable 6.1.2 to 6.2.2
it can not be reproduced on 6.1.2

-- 
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/20190507/74d0dbca/attachment.html>


More information about the Libreoffice-bugs mailing list