sheetjs/sheetjs
37
Fork 37
Code Issues 193 Pull Requests 12 Wiki Activity

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

New Issue
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)
Copy Link

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)
Copy Link

+1

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

Same issue here

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

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)
Copy Link

+1

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

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 Branch/Tag Specified
Branches Tags
Labels
Clear labels   
DBF

   
Dates

   
Defined Names

   
Features

   
Formula

   
HTML

   
Images

   
Infrastructure

   
Integration

   
International

   
ODS

   
Operations

   
Performance

   
PivotTables

   
Pro

   
Protection

   
Read Bug

   
SSF

   
SYLK

   
Style

   
Write Bug

   
good first issue
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
Milestone
Clear milestone
No items
No Milestone
Assignees
Clear assignees
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.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?