And indeed, I just tested this in LibreOffice.

Both methods work to automatically resize the columns to line up, though export/open retains fonts, background, etc.

Select-All followed by Copy/Paste into a blank sheet brings up the Text Import dialog, and I left the default options.

This method will stick everything in the spreadsheet cells with no formatting carried over. (it will insert as plain text, so your spreadsheet styles will override)

You may find this easier as you can define your spreadsheet styles perhaps more intuitively using an office app than via CSS in GnuCash.

Then simply multi-select and apply those styles to the relevant cells.

The amount of setup work you need to do just depends on how you want it to look and how often you need to do this. Templates can help here considerably.

Regards,
Adrien

On 3/23/22 12:34 PM, Adrien Monteleone wrote:
Carl-Kensaku,

No need to dig into Scheme or HTML to fix this.

The devs will address it soon enough I'm sure, but this is a 'presentation' issue.

That can always be fixed in the short term by either exporting and opening in a spreadsheet, or Select-All & Copy/Paste to a spreadsheet.

From there you can easily fix the first label column to the same size. (it might even do it automatically since it will import both tables into one sheet)

Many people make their reports 'pretty' using spreadsheet apps. It also allows for additional math that would be difficult to write having to learn Scheme. (such as Variance columns or other various aggregate subtotals)

_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to