Re: [GNC] How to get a report in a format which is easy to edit?
You might export as CSV and print it from excel, Google Sheets, libreOffice Sheets or as a spreadsheet into table in a word processing document. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
That is installed by default in Ubuntu for many years now. I would suspect the same is true of its various flavors. Regards, Adrien On 3/6/24 4:17 AM, Alan Hopkins wrote: You just need CUPS-PDF installed as a print driver for producing pdf files. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
Chris, LibreOffice uses Draw for PDF editing, not Writer. That doesn't mean the text isn't text. Everything is essentially in various text boxes. But having used it quite a bit, I can attest it is way more of a pain for large edits than either HTML or using Calc. For a small change though, it is just fine. I've edited many GnuCash reports using Calc. It is by far the easiest route and the most useful. (you can do additional math if needed) But of course, use whatever tool you prefer. Also, as I mentioned, investigate stylesheets in GnuCash. You might achieve what you want without using an outside tool at all. Regards, Adrien On 3/6/24 3:42 AM, Chris Green wrote: On Wed, Mar 06, 2024 at 08:01:36PM +1100, Alan Hopkins wrote: Chris Are you "printing to file" or are you doing something else? As Adrien has pointed out, you have not really given us enough info to help you. I tried various ways. If you provide all info on the OS system & the version of GnuCash you are using & steps you have taken, you might just find a GnuCash user on this list who can help you more directly. It's xubuntu and I'm running GnuCash 4.8 and LibreOffice 7.3.7.2. However I have spotted my basic problem, opening a PDF file with libreoffice opens it in lodraw and thus it *looks like* I have a PDF with images. I don't seem to be able to force libreoffice to open a PDF in lowriter. I have managed a way round this now, pandoc will convert from HTML directly to an loffice ODT file which gets me to the result I want, a report I can edit reasonably easily in lowriter. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
If are you going from HTML to PDF then that sounds like the method employed by that converter and not GNC itself. Once you run the report, if you look at the top of the report window, there is 'Make PDF' button/icon (at least I see it on Windows version of it). Pressing that should save it as a true PDF formatted file. On Windows platform, I just ran a report, saved it as PDF using afore-said method and was able to edit individual "cells" in ABBYY FineReader PDF app. Since GNC is cross-platform, I don't think that behavior is likely to be different between Windows, Linux or Mac. Platform might customize how the dialogues are displayed at each step but the underlying facility is like to function in same manner. -Original Message- From: Chris Green Sent: Wednesday, March 06, 2024 2:56 AM To: gnucash-user@gnucash.org Subject: Re: [GNC] How to get a report in a format which is easy to edit? On Wed, Mar 06, 2024 at 10:09:03AM +1100, Alan Hopkins wrote: > > Additionally, there are pdf editors out there that do a good job (some > are > cross-platform) - my pdf's produced from GnuCash are all editable (I > use > Linux) - not graphic images - maybe look for another driver/app to > achieve what you need? This is what I'm after. I'm all Linux based but so far whatever route I take to get from GnuCash's HTML to PDF I end up with a PDF file with images rather than text in it. What do you use to convert to PDF? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
You just need CUPS-PDF installed as a print driver for producing pdf files. On Wed, 6 Mar 2024, 9:12 pm Alan Hopkins, wrote: > Glad to hear it > > On Wed, 6 Mar 2024, 8:43 pm Chris Green, wrote: > >> On Wed, Mar 06, 2024 at 08:01:36PM +1100, Alan Hopkins wrote: >> > Chris >> > >> > Are you "printing to file" or are you doing something else? As Adrien >> has >> > pointed out, you have not really given us enough info to help you. >> > >> I tried various ways. >> >> > >> > If you provide all info on the OS system & the version of GnuCash you >> are >> > using & steps you have taken, you might just find a GnuCash user on this >> > list who can help you more directly. >> > >> It's xubuntu and I'm running GnuCash 4.8 and LibreOffice 7.3.7.2. >> >> However I have spotted my basic problem, opening a PDF file with >> libreoffice opens it in lodraw and thus it *looks like* I have a PDF >> with images. I don't seem to be able to force libreoffice to open a >> PDF in lowriter. >> >> I have managed a way round this now, pandoc will convert from HTML >> directly to an loffice ODT file which gets me to the result I want, a >> report I can edit reasonably easily in lowriter. >> >> -- >> Chris Green >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
Glad to hear it On Wed, 6 Mar 2024, 8:43 pm Chris Green, wrote: > On Wed, Mar 06, 2024 at 08:01:36PM +1100, Alan Hopkins wrote: > > Chris > > > > Are you "printing to file" or are you doing something else? As Adrien has > > pointed out, you have not really given us enough info to help you. > > > I tried various ways. > > > > > If you provide all info on the OS system & the version of GnuCash you are > > using & steps you have taken, you might just find a GnuCash user on this > > list who can help you more directly. > > > It's xubuntu and I'm running GnuCash 4.8 and LibreOffice 7.3.7.2. > > However I have spotted my basic problem, opening a PDF file with > libreoffice opens it in lodraw and thus it *looks like* I have a PDF > with images. I don't seem to be able to force libreoffice to open a > PDF in lowriter. > > I have managed a way round this now, pandoc will convert from HTML > directly to an loffice ODT file which gets me to the result I want, a > report I can edit reasonably easily in lowriter. > > -- > Chris Green > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Wed, Mar 06, 2024 at 08:01:36PM +1100, Alan Hopkins wrote: > Chris > > Are you "printing to file" or are you doing something else? As Adrien has > pointed out, you have not really given us enough info to help you. > I tried various ways. > > If you provide all info on the OS system & the version of GnuCash you are > using & steps you have taken, you might just find a GnuCash user on this > list who can help you more directly. > It's xubuntu and I'm running GnuCash 4.8 and LibreOffice 7.3.7.2. However I have spotted my basic problem, opening a PDF file with libreoffice opens it in lodraw and thus it *looks like* I have a PDF with images. I don't seem to be able to force libreoffice to open a PDF in lowriter. I have managed a way round this now, pandoc will convert from HTML directly to an loffice ODT file which gets me to the result I want, a report I can edit reasonably easily in lowriter. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
As an afterthought Chris, check to see if you have Ghostscript installed - it effectively provides a pdf printer (with editable files) On Wed, 6 Mar 2024, 8:01 pm Alan Hopkins, wrote: > Chris > > Are you "printing to file" or are you doing something else? As Adrien has > pointed out, you have not really given us enough info to help you. > > Most Linux systems I am aware of allow printing to file & selecting file > type as pdf. I have not encountered a pdf from this method which couldn't > be edited - try something like MasterPDFEditor - it was free for basic > editing. > > As you are using Linux & libreoffice you can just export the HTML & import > into Writer, adjust as required, then export to pdf. > > But, again as Adrien noted, you might achieve what you want via the Report > Options pathway. > > If you provide all info on the OS system & the version of GnuCash you are > using & steps you have taken, you might just find a GnuCash user on this > list who can help you more directly. > > Cheers > > A. > > On Wed, 6 Mar 2024, 6:58 pm Chris Green, wrote: > >> On Tue, Mar 05, 2024 at 11:54:35PM -0600, Adrien Monteleone wrote: >> > Yes, those PDFs are indeed reasonably editable. Even LibreOffice can >> > pull it off. >> > >> Which PDFs? All the ones I have produced are images. What's the >> 'standard' route from a GnuCash report to PDF (on Linux, so >> LibreOffice etc. are here by default). >> >> -- >> Chris Green >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
Chris Are you "printing to file" or are you doing something else? As Adrien has pointed out, you have not really given us enough info to help you. Most Linux systems I am aware of allow printing to file & selecting file type as pdf. I have not encountered a pdf from this method which couldn't be edited - try something like MasterPDFEditor - it was free for basic editing. As you are using Linux & libreoffice you can just export the HTML & import into Writer, adjust as required, then export to pdf. But, again as Adrien noted, you might achieve what you want via the Report Options pathway. If you provide all info on the OS system & the version of GnuCash you are using & steps you have taken, you might just find a GnuCash user on this list who can help you more directly. Cheers A. On Wed, 6 Mar 2024, 6:58 pm Chris Green, wrote: > On Tue, Mar 05, 2024 at 11:54:35PM -0600, Adrien Monteleone wrote: > > Yes, those PDFs are indeed reasonably editable. Even LibreOffice can > > pull it off. > > > Which PDFs? All the ones I have produced are images. What's the > 'standard' route from a GnuCash report to PDF (on Linux, so > LibreOffice etc. are here by default). > > -- > Chris Green > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Tue, Mar 05, 2024 at 11:54:35PM -0600, Adrien Monteleone wrote: > Yes, those PDFs are indeed reasonably editable. Even LibreOffice can > pull it off. > Which PDFs? All the ones I have produced are images. What's the 'standard' route from a GnuCash report to PDF (on Linux, so LibreOffice etc. are here by default). -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Wed, Mar 06, 2024 at 10:09:03AM +1100, Alan Hopkins wrote: > > Additionally, there are pdf editors out there that do a good job (some are > cross-platform) - my pdf's produced from GnuCash are all editable (I use > Linux) - not graphic images - maybe look for another driver/app to achieve > what you need? This is what I'm after. I'm all Linux based but so far whatever route I take to get from GnuCash's HTML to PDF I end up with a PDF file with images rather than text in it. What do you use to convert to PDF? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
Yes, those PDFs are indeed reasonably editable. Even LibreOffice can pull it off. Otherwise, your answer is to either edit the HTML (which is the native format of the reports once rendered) or put them in a spreadsheet which relieves you of the HTML and leaves you with rows and cells that are easily customizable, manipulable, and upon which you can perform functions since the cell contents aren't just 'images' but rather actual text and/or numbers some of which have known formats. What exactly are you asking for otherwise? Magic? What *exactly* (with maybe an example?) do you mean by "look nice?" I'd hazard whatever you are attempting is easily achievable via moving to a spreadsheet app. But let us back up one step. You are now speaking not of editing per se, but of presentation. That's a different beast entirely. And for that, GnuCash offers some features. Look into and investigate (play with) stylesheets for reports. You might be able to customize an existing one either using its preset features, or even use the 'custom css' stylesheet. Otherwise, you can of course, delve in to writing your own, but now you're treading into that 'dreaded HTML' ground you erroneously think is so treacherous. Regards, Adrien On 3/5/24 4:17 PM, Chris Green wrote: You are a glutton for punishment!!! Who on earth would try to make a report 'look nice' (which is what I'm trying to do) using a spreadsheet!?? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
Chris I support Adrien here - he is trying to assist you to get to the end-point you want. HTML reports can be imported into any decent word processing software. You don't need to edit the HTML code. And you can make financial reports look great using a spreadsheet - I've been doing that for decades. Perhaps you might consider doing a short course on using spreadsheets for layout? Additionally, there are pdf editors out there that do a good job (some are cross-platform) - my pdf's produced from GnuCash are all editable (I use Linux) - not graphic images - maybe look for another driver/app to achieve what you need? Years ago when using Windoze & the earliest versions of Quickbooks which didn't print to pdf I used a free app - I think it was called something like PDF24 creator - the pdfs produced by it were also editable. Anyway, keep trying & you'll find a suitable method to do what you want. Cheers Alan On Wed, 6 Mar 2024, 9:18 am Chris Green, wrote: > On Tue, Mar 05, 2024 at 02:16:57PM -0600, Adrien Monteleone wrote: > > You can also select-all and copy/paste into a spreadsheet while viewing > > any report. > > > You are a glutton for punishment!!! Who on earth would try to make a > report 'look nice' (which is what I'm trying to do) using a > spreadsheet!?? > > -- > Chris Green > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Tue, Mar 05, 2024 at 02:16:57PM -0600, Adrien Monteleone wrote: > You can also select-all and copy/paste into a spreadsheet while viewing > any report. > You are a glutton for punishment!!! Who on earth would try to make a report 'look nice' (which is what I'm trying to do) using a spreadsheet!?? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
On Tue, Mar 05, 2024 at 02:16:27PM -0600, Adrien Monteleone wrote: > The standard export/save of reports is an HTML table. > > You can edit that with any decent text editor, and/or open/import it > into a spreadsheet app for further manipulation. > Editing HTML is *NOT* my favourite occupation. Any other format, whether markup of some sort or word-precessor is infinitely better. -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
You can also select-all and copy/paste into a spreadsheet while viewing any report. Regards, Adrien On 3/5/24 10:43 AM, Chris Green wrote: Is there any way to get a report from GnuCash in some sort of editable format? I have tried various ways, including printing to file as a PDF but I always end up with a PDF file made up of images which is quite useless for editing. I want to be able to change the size and typeface of some of the entries. Surely there's a way to get an edtable report!? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to get a report in a format which is easy to edit?
The standard export/save of reports is an HTML table. You can edit that with any decent text editor, and/or open/import it into a spreadsheet app for further manipulation. Regards, Adrien On 3/5/24 10:43 AM, Chris Green wrote: Is there any way to get a report from GnuCash in some sort of editable format? I have tried various ways, including printing to file as a PDF but I always end up with a PDF file made up of images which is quite useless for editing. I want to be able to change the size and typeface of some of the entries. Surely there's a way to get an edtable report!? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to get a report in a format which is easy to edit?
Is there any way to get a report from GnuCash in some sort of editable format? I have tried various ways, including printing to file as a PDF but I always end up with a PDF file made up of images which is quite useless for editing. I want to be able to change the size and typeface of some of the entries. Surely there's a way to get an edtable report!? -- Chris Green ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.