Bug 128863 - error in SUM formula - generated automatic by python library xlsxwriter
Summary: error in SUM formula - generated automatic by python library xlsxwriter
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-17 18:44 UTC by Carlos Monari
Modified: 2019-11-18 18:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Simulated error file. (5.35 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-11-17 18:44 UTC, Carlos Monari 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Carlos Monari 2019-11-17 18:44:33 UTC 
Created attachment 155901 [details]
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
Comment 1 Oliver Brinzing 2019-11-18 18:55:55 UTC 
(In reply to Carlos Monari from comment #0)
> when we use 'SUM' formula in  cell's, the sumarize don't occurr.
> in my example =SUM(B2:B5) - file expenses02.xlsx.

You need to do a hard recalc after loading:
Menu Data/Calculate/Recalculate Hard.

or change option:

Menu Tools/Options/LibreOffice Calc/Formula
 Recalculation on File Load:
  Excel 2007 and newer: [Always Recalculate]