Abe, please remember to reply-all or reply-list that way others can
benefit from the conversation, and may be able to help where I can't.
-----
You should be able to edit everything in a spreadsheet app with ease.
Every report is just an HTML table, so it has cells with labels and data
which map *mostly* nicely to columns and rows in a spreadsheet.
If you're having import issues, try just saving the report and opening
it with your spreadsheet app of choice. (Libreoffice and relatives are
known to work well, and some people say Excel works fine too.) Of
course, a Select-All/Copy/Paste works fine too. Some methods carry over
formatting, and others let you easily copy over plain text.
The Title Extension is just the name of your budget. You can just select
that cell and edit as needed. (or rename your budget to something you'd
prefer as a title extension) I'm sure a crafty spreadsheet text formula
can find the ":" separator in the title and then replace the text after it.
If you haven't yet played around with spreadsheet formulas affecting
text, logic, or 'information' about the sheet/cell, I encourage you to
do so. There is lots of power there which might meet your needs, or at
least some of them. And those skills are useful for many things other
than GnuCash of course.
-----
The Totals column is entirely independent of the Report Title parts, so
not sure what issue you are having.
-----
As for scripting/macros, macros are usually something used in a
spreadsheet app to automate stuff, like formatting, or adding in
formulas, etc. You'd have to investigate your preferred app as to how
they work, and where they might be useful to you.
Scripting is usually done to process a file outside of an 'app'. For
example, if using Linux or Mac, you can use 'shell' scripting using
'sed' or 'awk' (among others) to edit the resulting HTML file that you
export/save from GnuCash. This could do things like search and replace
titles, column headings, etc. Other options are Python & Perl. Windows
can also use some of these, but I'm not sure which.
Then you can either open the resulting edited file manually or as part
of the script in a spreadsheet for further processing. (applying
'styles' for instance) Or you can open the file in your browser of
choice, and either view, print, or 'save to PDF'.
Part of your scripting can handle CSS changes to the Report file beyond
perhaps what works withing the CSS Stylesheet in GnuCash. (Technically,
GnuCash uses Webkit rendering engine, same as used in Safari, to display
reports, but not all useful parts of a report are easily stylable via
CSS there.) Your script could insert CSS ID's, Classes, or otherwise add
styling or even entire HTML elements to be styled as part of your 'text
processing'. (HTML files are 'plain text' in a Markup language)
Getting the CSS right will allow you a 'pretty' version of the report
for viewing/printing in a browser.
On that note, see my other reply about CSS basics. If you're going to
get to this level of customization, you should be aware of these things
and how to manipulate them.
For starters, open the exported/saved report in a text editor. Start
learning HTML. (the basics, plus tables) Any scripting will need to be
able to edit HTML properly.
-----
There are also automation tools in the wild that can assist with all or
part of anything you find yourself manually having to change or do
often. Some can even record mouse movements and 'replay' them! (the link
to such an app has been posted on this list before, but I seem to have
misplaced it. You might find it in a well crafted search.)
*note, I'd advise to play with the report Options and Stylesheets from
*within* GnuCash to get as close as you can to your desired end goal.
That will save you lots of work outside of GnuCash to get it looking
like you want.
-----
You'll still have to learn new things to accomplish this task, but it
doesn't have to be Scheme! (no hate on Scheme, it just isn't the easiest
thing to tackle)
Regards,
Adrien
On Oct 10, 2022 w42d283, at 4:17 PM, Abe Sternberg
<abe.h.sternb...@gmail.com> wrote:
Love your response.
I had tried exporting to a spreadsheet, but didn't get anything I knew how to play with.
I had experimented with the title, but couldn't get rid of your title extension if I
wanted the "accumulated" totals.
Could you go into a little more detail for option #3 Scripting and Macros? The
scripting and/or macro is done in the spreadsheet and not in GnuCash, correct?
_______________________________________________
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.
