[Libreoffice-bugs] [Bug 112780] New: Incompatibility in 5.3.1.2 for spreadsheet created with 5.1 ( wrong data type)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 112780
           Summary: Incompatibility in 5.3.1.2 for spreadsheet created
                    with 5.1 (wrong data type)
           Product: LibreOffice
           Version: 5.3.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dominique at d-meeus.be

Description:
Everything OK in a spreadheet under LibreOffice Calc 5.1
When opening in 5.3, I get "Erreur : type de données incorrect" (Wrong data
type, I suppose, in English).
The cell is the sum of three others showing no error.
The error disappears if the other cells are filled. The error does not reappear
if the content of the other cells is deleted.
It seems that 5.3 does not consider the terms of the sum as numbers when
opening the file. 

Steps to Reproduce:
1. Open a sample of the template
http://www.d-meeus.be/verkelec/municipal/Zetelverdel-provincie.ots in 5.1
2. Open a sample of the template
http://www.d-meeus.be/verkelec/municipal/Zetelverdel-provincie.ots in 5.3

Actual Results:  
In 5.1, no errors in D6 to D25
In 5.3, wrong data type in D6 to D25

Expected Results:
5.3 should be compatible with 5.1


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:55.0) Gecko/20100101
Firefox/55.0

-- 
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/20170930/a45eba0f/attachment-0001.html>