Formula is missing randomly.

Question

Formula is missing randomly.

safiir opened this issue 6 years ago · 9 comments

Desc

I try to open a excel file, then fill it with some dynamic data, but after the cell is filled and the excel is written to disk, some formula type cell's formula could be missing randomly.

Environment:

Ruby: ruby 2.3.1p112 (2016-04-26) [x86_64-linux-gnu]
Spreadsheet (1.1.5)

Code And File

script for test
.xls file for test

Answer 1 · 2018-05-08T18:49:42.000Z

Interesting. Please provide sample code and file.

Answer 2 · 2018-05-10T13:02:59.000Z

@zdavatz The test code and the file have been added. please check it, thanks!

Answer 3 · 2018-05-10T13:37:26.000Z

Thanks. But we do not support XLSX. I will need an XLS File to test. Also: what software created the original XLS file?

Answer 4 · 2018-05-10T15:17:16.000Z

@zdavatz Sorry, I updated the code and the file again, and I created the .xls file in WPS(like Microsoft Excel) for Debian-like Linux.

Answer 5 · 2018-05-10T15:30:14.000Z

Try creating the file using LibreOffice or OpenOffice, then it should work. I have no idea what WPS is. They probably do not attend to all the format Rules of MS Excel. It makes a big difference to which software created the original file.

Answer 6 · 2018-05-10T15:34:22.000Z

The output file "filled.xls" is not missing any data AFAICT.

Answer 7 · 2018-05-11T07:31:56.000Z

@zdavatz The formula in power column is missing instead of current and previous data.

Answer 8 · 2018-05-11T09:34:37.000Z

I guess you have to write that as well when writing the new file.

Answer 9 · 2018-05-11T09:40:22.000Z

Have you tried to write just the formulas from one file to another?