<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Save Tabular Data to JSON"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=103498#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Save Tabular Data to JSON"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=103498">bug 103498</a>
from <span class="vcard"><a class="email" href="mailto:launchpad@startport.com" title="launchpad@startport.com">launchpad@startport.com</a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>