felixbuenemann / xlsxtream

Streaming & Fast XLSX Spreadsheet Writer for Ruby
MIT License
216 stars 38 forks source link

Encode strings that look like hexcodes with underscores #56

Open lavham opened 1 year ago

lavham commented 1 year ago

Ensure that we escape the first underscore character in plaintext strings that match the format for Excel escape sequences. This ensures that these strings are displayed as plaintext and not incorrectly parsed as escape sequences by Excel. See Microsoft Excel spec here: https://learn.microsoft.com/en-us/openspecs/office_standards/ms-oi29500/d34ae755-c53f-4a44-a363-c6dd3ee018a4