[Libreoffice-bugs] [Bug 128863] New: error in SUM formula - generated automatic by python libraru xlsxwriter

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Nov 17 18:44:33 UTC 2019


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

            Bug ID: 128863
           Summary: error in SUM formula - generated automatic by python
                    libraru xlsxwriter
           Product: LibreOffice
           Version: 6.3.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: carlosmonari at gmail.com

Created attachment 155901
  --> https://bugs.documentfoundation.org/attachment.cgi?id=155901&action=edit
Simulated error file.

when we use 'SUM' formula in  cell's, the sumarize don't occurr.

in my example =SUM(B2:B5) - file expenses02.xlsx.

this file is generated with a python library xlsxwriter
(se the site https://xlsxwriter.readthedocs.io/ )

i open this file in MIcrosoft Excel and this error don t occurr.

I open this file in Google SpreadSheet and this error don t occurr.


Manually to correct this error, i enter editing cell 'B6', add a blankspace at
final express and press enter.

After this the formula is running normally. 

its very strange

Thanks a lot.

Carlos Monari

-- 
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/20191117/ac34aeac/attachment.html>


More information about the Libreoffice-bugs mailing list