Re: [GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Eric Chapman
Hi, Michael, Some others responded also, so now I have successfully exported to HTML and opened the files in a spreadsheet. I didn't know that was possible. Now I do. All's well, and I'm thankful for your help! Eric On 12/5/23 16:16, Michael or Penny Novack wrote: On 12/5/2023 8:57 AM,

Re: [GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Michael or Penny Novack
On 12/5/2023 8:57 AM, Eric Chapman wrote: How do I export data from reports to csv files or Excel/LibreOffice Calc files? a) To use the last (as an example) LibreOffice Calc does NOT require the files it opens to be "LibreOffice Calc files" << it of course does prefer the open document

Re: [GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Eric Chapman
OK, sounds like it's doable. Will try. Thank you. Eric On 12/5/23 10:38, Adrien Monteleone wrote: #1 - Run Report, Select-All, Copy, Open Spreadsheet app, Paste #2 - Run Report, Export as HTML, Open resulting file with Spreadsheet app. #3 - Run Report, Export, Use 'Insert from File' in

Re: [GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Eric Chapman
OK, thank you! I will try it. On 12/5/23 10:41, Maf. King wrote: On Tuesday, 5 December 2023 15:11:26 GMT Eric Chapman wrote: When I try to print to file from GnuCash 4.14, I only see the three options in the screenshot attached: PDF, PostScript, and SVG. Hmmm… On 12/5/23 10:08, Eric Chapman

Re: [GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Maf. King
On Tuesday, 5 December 2023 15:11:26 GMT Eric Chapman wrote: > When I try to print to file from GnuCash 4.14, I only see the three > options in the screenshot attached: PDF, PostScript, and SVG. Hmmm… > > On 12/5/23 10:08, Eric Chapman wrote: > > I did find this, but it does not appear to have

Re: [GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Adrien Monteleone
#1 - Run Report, Select-All, Copy, Open Spreadsheet app, Paste #2 - Run Report, Export as HTML, Open resulting file with Spreadsheet app. #3 - Run Report, Export, Use 'Insert from File' in Spreadsheet app. With the last two, you will likely be asked to confirm formatting ala importing a CSV

Re: [GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Eric Chapman
When I try to print to file from GnuCash 4.14, I only see the three options in the screenshot attached: PDF, PostScript, and SVG. Hmmm… On 12/5/23 10:08, Eric Chapman wrote: I did find this, but it does not appear to have any solution:

Re: [GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Eric Chapman
I did find this, but it does not appear to have any solution: https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html Is it true that GnuCash only exports to HTML? On 12/5/23 08:57, Eric Chapman wrote: How do I export data from reports to csv files or Excel/LibreOffice Calc

[GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Eric Chapman
How do I export data from reports to csv files or Excel/LibreOffice Calc files? -- Eric Chapman GnuCash 4.14 (moving soon to 5.4, I think) on MacOS 14.1 Sonoma running on an Apple M3 Max computer. ___ gnucash-user mailing list