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

[bugzilla-daemon]

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

BogdanB  changed:

   What|Removed |Added

 Blocks||108254
 CC||buzea.bog...@libreoffice.or
   ||g


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108254
[Bug 108254] [META] File format filters (import/export) bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #4 from launch...@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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Mike Kaganski  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||3974

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||tietze.he...@gmail.com
 Ever confirmed|0   |1

--- Comment #3 from Heiko Tietze  ---
How about an extension?

Was looking for a solution and found very quickly
http://www.csvjson.com/csv2json. The request needs to define precisely
constraints and needed options. But I guess it's a good enhancement either per
extension or inbuilt -> NEW.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #2 from Urmas  ---
Is there a single way to represent spreadsheets in JSON?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #1 from launch...@startport.com ---
I don't think it will be hard to find open source code that already does this.
Mainly, the effort would be a matter of incorporating that code into the Libre
Calc project.

For example, I'm currently using this to do it:
https://www.npmjs.com/package/csvtojson

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs