ruilisi / fortune-sheet

A drop-in javascript spreadsheet library that provides rich features like Excel and Google Sheets
https://ruilisi.github.io/fortune-sheet-docs/
MIT License
2.54k stars 227 forks source link

Font Styling gets removed when viewing cell with /n linebreak #622

Open Erivess opened 2 days ago

Erivess commented 2 days ago

Describe the bug When I have a cell with a lot of text and a newline characters /n , the styling gets removed after opening the cell in full and then closing it again.

To Reproduce Steps to reproduce the behavior - see images.

  1. Have a cell with lots of text
  2. View the cell in full
  3. Close the cell again
  4. -> Formatting removed

JSON output from the example: { "r": 33, "c": 2, "v": { "v": "There shall be a defined and documented method for determining the impact of any disruption to the organization (cloud provider, cloud consumer) that must incorporate the following:\n • Identify critical products and services\n • Identify all dependencies, including processes, applications, business partners, and third party service providers\n • Understand threats to critical products and services\n • Determine impacts resulting from planned or unplanned disruptions and how these vary over time\n • Establish the maximum tolerable period for disruption\n • Establish priorities for recovery\n • Establish recovery time objectives for resumption of critical products and services within their maximum tolerable period of disruption\n • Estimate the resources required for resumption", "f": null, "ct": { "fa": "General", "t": "g" }, "bg": "#ffffff", "bl": 0, "it": 0, "ff": "Calibri", "fs": 11, "fc": "#333333", "ht": 1, "vt": 1, "tr": "0", "tb": "2" } },

Expected behavior Cell should contain the data and not remove the styling Screenshots See screenshots Additional context I tried removing the special characters, but it only worked when removing the /n Screenshot at Nov 13 08-17-54 Screenshot at Nov 13 08-18-22 Screenshot at Nov 13 08-24-49

sanchit3008 commented 2 days ago

https://github.com/ruilisi/fortune-sheet/pull/615

@Corbe30 this change might have caused it