Sheetjs cell formula invalid #3148

Open
opened 2024-07-10 11:34:30 +00:00 by fendo · 1 comment

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)
Author

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
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#3148
No description provided.