sheetjs/sheetjs
43
Fork 45
Code Issues 201 Pull Requests 13 Wiki Activity

Sheetjs cell formula invalid #3148

New Issue
Closed
opened 2024-07-10 11:34:30 +00:00 by fendo · 2 comments
fendo commented 2024-07-10 11:34:30 +00:00
Copy Link

1.My sheet data format is in the sheetjs.txt file I uploaded，

2.My exported code is displayed in the figure below
image

3.The current design rendering
The red box in the figure is where the cell formula should be set. I have already set it in the code, but for some reason, there is still a problem and it does not set in. Please help me to see what the problem is. Thank you very much!

image

1.My sheet data format is in the sheetjs.txt file I uploaded， 2.My exported code is displayed in the figure below ![image](/attachments/5d4f33a9-952f-4f20-8e73-cad8b111c76f) 3.The current design rendering The red box in the figure is where the cell formula should be set. I have already set it in the code, but for some reason, there is still a problem and it does not set in. Please help me to see what the problem is. Thank you very much! ![image](/attachments/6285e4db-9647-4eb6-bebb-a4d6006a67b6)
sheetjs.txt
599 KiB
image.png
42 KiB
image.png
50 KiB
image.png
148 KiB
image.png
fendo commented 2024-07-11 01:11:05 +00:00
Author
Copy Link

I have identified the cause of this issue. The reason is that I used the xlsx style module to export, which resulted in the formula not being set to xlsx. If I exported using native xlsx, the formula would be set to xlsx, but this would make my xlsx look ugly. Is there any other way to set the style

I have identified the cause of this issue. The reason is that I used the xlsx style module to export, which resulted in the formula not being set to xlsx. If I exported using native xlsx, the formula would be set to xlsx, but this would make my xlsx look ugly. Is there any other way to set the style
sheetjs commented 2024-07-28 19:10:15 +00:00
Owner
Copy Link

This is a feature of Pro Basic and may eventually be added to SheetJS CE.

This is a feature of [Pro Basic](https://sheetjs.com/pro/) and may eventually be added to SheetJS CE.
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
2 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#3148
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?