[Libreoffice-bugs] [Bug 122025] New: Cell format change back cause sum function problem.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122025
           Summary: Cell format change back cause sum function problem.
           Product: LibreOffice
           Version: 5.2.3.3 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: szabod at dd-inox.eu

Description:
When I changed the cell format from text to number, sum function was not
working on those cells (even they were numbers). It is because all numbers get
a hidden ' character.

Steps to Reproduce:
1. Write numbers to A1:A5 (cell format is number) A6 Sum(A1:A5)
2. Change the cell format of A2:A5 to text. (Sum function is still works well.)
3. Change the text format to "@ XY" (Sum function is not working any more.
Still ok.)
4. Change back the text format to "@". (Sum function should work, but it is
not.)
5. Change the cell format back to number. (Sum function should work, but it is
not.) The numbers get an ' sign into the first character. (It is hidden until
you click in the cell, and watch the above line.) Sum function still not
working.
6. I have to delete the added caracter from each cell.

Actual Results:
The problem is reproduced.

Expected Results:
Sum the numbers of the cells.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:

-- 
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/20181211/5013cac2/attachment-0001.html>