quadratic icon indicating copy to clipboard operation
quadratic copied to clipboard

Change string escaping to match Excel's behavior

Open HactarCE opened this issue 2 years ago • 2 comments

Right now, Quadratic formulas use \ as the escape character. Excel doesn't do this; instead, " can be escaped using "".

And similarly in single-quoted strings: 'don''t' is equivalent to "don't"

In addition to updating parsing, be sure to update:

  • [ ] escape_string() (in quadratic_core::formulas as of writing)

HactarCE avatar May 18 '23 21:05 HactarCE

Advanced spreadsheet usage that may be irrelevant for our audience atm, plz reopen if desired as a feature/higher prio

luke-quadratic avatar Feb 04 '24 02:02 luke-quadratic

Reopening, since this is a compatibility concern. We should either change all formulas on import from Excel, or we could support Excel's string escaping.

HactarCE avatar Oct 23 '24 20:10 HactarCE