You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Package cannot handle cells in which a single quote is used to escape an equal sign at the beginning of the cell, i.e. in my excel file there is a cell with content "'= this is a test" (please note single quote at the beginning of the string) which raises the error "formulas.errors.FormulaError: ('Not a valid formula:\n%s', '= this is a test')".
The text was updated successfully, but these errors were encountered:
done712
changed the title
formulas.errors.FormulaError: ('Not a valid formula:\n%s', '= this is a test')
Cells with single quote to escape equal sign
Aug 12, 2020
This is still an issue when exporting a workbook as a dictionary. The single quote escape is not in the exported vale, so when the dictionary is reloaded it's interpreted as a formula.
Package cannot handle cells in which a single quote is used to escape an equal sign at the beginning of the cell, i.e. in my excel file there is a cell with content "'= this is a test" (please note single quote at the beginning of the string) which raises the error "formulas.errors.FormulaError: ('Not a valid formula:\n%s', '= this is a test')".
The text was updated successfully, but these errors were encountered: