Tablora · Library
Store formula-looking content as text
A cell that starts with an equals sign, like =1+1, may be literal text. The text-safe XLSX stores it as text so it never runs as a formula.
When an equals sign is just text
Notes, part numbers and imported comments sometimes begin with =, +, - or @. In a source document, =1+1 might be a note someone typed, a code, or an instruction meant to be read rather than calculated. Open such data in a spreadsheet as CSV and the program may treat the cell as a formula, show 2 instead of the text, or run something you did not intend.
The text-safe converter writes every cell as an explicit text cell in the workbook. A value beginning with an equals sign is stored as those characters and is never turned into a formula.
Exporting =1+1 as text
- Paste the rows that contain the note into Table text and set the Delimiter your source uses.
- Press Calculate and check that the note column shows =1+1 in the preview, with nothing added or removed.
- Use Download (XLSX) and open tablora-table.xlsx.
- In the spreadsheet, confirm that the cell shows =1+1 as text and that the formula bar does not show a calculated value.
The note column example
The page example has one column named note and one value, =1+1. The expected cell text is =1+1, stored as an explicit text cell: not a formula and not a number. Because it is text, the cell will not recalculate if you later change other cells, and you should not describe it as a calculation in anything you write about the file.
CSV downloads add an apostrophe
The other browser tools, such as the delimited inspector and the numeric normalizer, offer Download (CSV) instead of XLSX. In those files, any cell that begins with =, +, - or @, after optional leading spaces, gets a leading apostrophe, so =1+1 is written as '=1+1. That prefix is a common guard against formula evaluation, but it is now part of the text in the file. If you need the exact characters with no prefix, use the text-safe XLSX instead.
In the Tablora app, the XLSX export never writes formulas: a cell like =1+1 is stored as text. The app's CSV export writes cells exactly as read, without the apostrophe, so the program that opens the CSV decides what happens to it.
Deciding what the cell should be
If the source really meant a calculation, keep the text version as a record and rebuild the formula in your spreadsheet yourself, with references you have checked.
If you are unsure, export the text-safe version first. You can turn text into a formula later, but a formula that already ran may have replaced the original text with its result.
Original synthetic example
- Input
- note =1+1
- Expected cell text
- =1+1
- Cell storage
- Explicit text, not a formula or numeric cell