[Libreoffice-bugs] [Bug 103498] Save Tabular Data to JSON

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=103498

--- Comment #4 from launchpad at startport.com ---
There are multiple ways to represent a spreadsheet using JSON, but the most
expected way would probably be an array of objects where each row is an object
and each column-name becomes a property of each of those objects. Yeah, that's
verbose, but it is probably what most people would expect from a "Save as JSON"
option.

For this request, I was not thinking about super complicated spreadsheets. I
was mainly thinking about simple tables that you can currently save to a csv.
Any spreadsheet that can be saved as csv can certainly also be converted to
JSON almost as easily.

One nice thing about JSON is that it already handles edge cases that might
corrupt a CSV file (a cell with its on internal commas for example is
problematic with CSV).

Does Excel offer this feature? If so, I say just do it a little better than how
they do it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200715/6de80674/attachment.htm>