Keep formula inside a cell from the input excel file after genarte the output xls file #300

Closed
opened 2015-09-12 17:03:45 +00:00 by wawanopoulos · 5 comments
wawanopoulos commented 2015-09-12 17:03:45 +00:00 (Migrated from github.com)

Hi,

My input xls file contain a formula inside the D1 cell. (SUM of B1 and C1).
After generate the output xls file with js-xlsx library, my formula is lost.

Is there a way to keep my formul ?

Thanks a lot for your help.

Hi, My input xls file contain a formula inside the D1 cell. (SUM of B1 and C1). After generate the output xls file with js-xlsx library, my formula is lost. Is there a way to keep my formul ? Thanks a lot for your help.
fabiooshiro commented 2015-10-17 01:29:29 +00:00 (Migrated from github.com)

+1

+1
AniLau commented 2015-11-10 23:41:29 +00:00 (Migrated from github.com)

Same issue here

Same issue here
AniLau commented 2015-11-11 17:50:38 +00:00 (Migrated from github.com)

This works for me mcsf@d439645

This works for me mcsf@d439645
evk0 commented 2017-03-16 13:41:35 +00:00 (Migrated from github.com)

+1

+1
SheetJSDev commented 2017-03-18 00:56:44 +00:00 (Migrated from github.com)

We updated the write test with an example

We updated the [write test](https://github.com/SheetJS/js-xlsx/blob/master/tests/write.js#L82-L93) with an example
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#300
No description provided.