Option to output formulae to JSON #1370
Labels
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
No Milestone
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: sheetjs/sheetjs#1370
Loading…
Reference in New Issue
No description provided.
Delete Branch "%!s(<nil>)"
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?
I'm using
.sheet_to_json
for easier testing (instead of comparing thews
object with an expected one). The problem is that formula cells don't show up in the JSON output. Is there a way to make that happen (other than sheet_to_formulae)? If not, an option likeformulas: true
forsheet_to_json
would be very useful for test automation.I also met the same problem. Has this problem been solved?
Sure, how would you handle cells that have a raw value (like a number or raw string)?
It's been a while since I filed this issue do I don't remember the entire context, but if I understand the question correctly, it's about deciding between outputting the raw value and the formula of a cell, in case both exists?
In that case, I would prefer the formula to be output, since the raw value represents a particular calculation for the formula at a point in time.
For cells that have formula expressions and values, you clearly would return the formula. The question is about cells that just have a value (no associated formula expression).
Currently the formula output utility function guesses based on the type of cell. Numeric cell values are stringified, and string cell values are prepended with a single quote (how it would appear in the formula bar if you entered the value manually)
I think that's a good solution.
(Naively, I would like the values coerced to
Number
orString
according to the cell type, but then you'd have to distinguish between literal strings starting with the=
sign, and formulas.)@SheetJSDev Can I take this issue?
Hola, Buenas estoy en el coienzo del curso y por ejemplo no me aparece la parte que decie en los primeros pasos, no me aparece la palabra fork. alguno tiene idea por que puede ser ?
For anyone still looking for this, I'm using a function based on @Mithgol algorithm from #270 with some tweaks: