I'm sorry that you feel I flamed you; I wasn't. I simply pointed out that GnuCash's job with HTML export is to provide valid HTML, and if it has done that, then the problem less with the import on the other end.
Since you disagree, I think your next step would be to determine what aspect of the GnuCash HTML causes the problem for you. Getting that info would further clarify whether the problem is GnuCash's HTML, or OpenOffice's import logic. David T. On October 20, 2026 11:02:35 PM GMT+05:30, Geoff Jankowski <[email protected]> wrote: >Hi David, > >Thanks for your response but please don’t flame me for trying to bring an >issue to other people’s attention. I know how to copy and paste and have done >the analysis I wanted to do through that route but the issue is the software >is not working for me (and possibly others) which is why I am raising it. > >I have no phantom monitors, I have a second monitor and I have searched all >over my system and cannot ssee a dialog box. I have just updated to 5.17 and >the problem is identical. > > > > >Geoff Jankowski >+44 20 7100 1092 >+44 7770 58 48 38 >+33 9 56 54 56 54 >+33 6 22 93 00 53 > > > > > > > > >> On 20 Oct 2026, at 19:16, David T. <[email protected]> wrote: >> >> You didn't say whether you had ever had a second monitor; I strongly suspect >> that's your problem. The dialog is displaying on a phantom monitor. >> >> As for HTML going to other programs: does the HTML display properly in a >> browser? If it does, then GnuCash has done its job. Whether or not >> OpenOffice (or any other random application, for that matter) imports that >> HTML into a spreadsheet is an issue to be raised with that application. >> >> Besides, if copy-paste works, what's your issue? Do what works. >> >> David T. >> >> >> On October 20, 2026 10:17:28 PM GMT+05:30, Geoff Jankowski via gnucash-user >> <[email protected]> wrote: >>> The HTML file is fine but it does not come into open office well. Hence >>> trying Numbers, which definitely does not accept it. >>> >>> I know I can copy and paste but I have raised the issue to see if it is a >>> problem with the code. >>> >>> When you say it worked as expected, did it give you a dialog box to select >>> options and filename etc. because this is what I did not get. >>> >>> It does not get as far as generating a file at all. It was not the pop up >>> dialog box that I saw, just a flicker on the side of the register as if the >>> box was hiding itself under the window but it was not there. As I said >>> earlier, I looked everywhere for it! >>> >>> First off I will move to 5.17 and try again. No point worrying about 5.16 >>> if it is working in 5.17. >>> >>> I will come back to say what happened. >>> >>> >>> >>> >>> Geoff Jankowski >>> +44 20 7100 1092 >>> +44 7770 58 48 38 >>> +33 9 56 54 56 54 >>> +33 6 22 93 00 53 >>> >>> >>> >>> >>> >>> >>> >>> >>>> On 20 Oct 2026, at 18:06, Adrien Monteleone >>>> <[email protected]> wrote: >>>> >>>> I don't recall any issue opening an exported (HTML) report in >>>> Libre/OpenOffice, but if the office version is really old, that could be a >>>> thing. (I've used LibreOffice since it forked a decade or so ago) I'm not >>>> at my Mac right now, but will test opening in Numbers later for >>>> completeness. I don't recall if it does so properly or not. >>>> >>>> Try CTRL+A to Select All while viewing the report, then CTRL+V in a >>>> spreadsheet tab to paste. >>>> >>>> As for the Export Active Register from a Search Results window, that >>>> worked for me as expected. (though I'm already on 5.17) >>>> >>>> Does your resulting files have a zero size? If not, can you open them with >>>> a text editor? If so, do they respectively look like proper HTML or CSV >>>> formatted data? >>>> >>>> You first mentioned seeing the export pop-up, then not seeing it. Did it >>>> only show up on the top of the window stack the first time? Have you tried >>>> Expose to show all windows? Are you running a multi-monitor setup? >>>> (sometimes, not having or disconnecting an additional display when you >>>> previously had it on or connected with GnuCash running can cause issues >>>> where GnuCash remembered your previous window placements *with* the extra >>>> display, which isn't there now) Have you tried running GnuCash >>>> non-maximized if you are so you can play with window arrangement to find >>>> it? >>>> >>>> Regards, >>>> Adrien >>>> >>>> On 10/20/26 09:26, Geoff Jankowski via gnucash-user wrote: >>>>> I am using Gnucash 5.16 on a Mac (iMac24 using the Apple M1 chip) running >>>>> OSX Tahoe 26.4.1. >>>>> I am trying to move my search results to my spreadsheet for analysis. >>>>> I first generated the search as a report and I then exported the search >>>>> report to an html file. I tried to open it in Open Office (the default >>>>> offering) but Open Office does not do a good job (and I usually do not >>>>> use it). I then tried Numbers and apparently I cannot open an html file >>>>> in it. >>>>> So I turned to csv format and this is where the problem started. When I >>>>> select Export Active Register to csv, nothing happens. When I selected >>>>> Export Transactions or Account Tree I get a window pop up to define the >>>>> report and filename etc. >>>>> I have restarted Gnucash but it exhibits the same behaviour. I have >>>>> checked all desktops and sent all running apps to the dock but the pop up >>>>> window cannot be seen. >>>>> I noticed a flash or flicker on the account tab tree so I moved the tabs >>>>> from the right (my default) to the top but it also made no difference. >>>>> Anyone else had this behaviour? >>>>> Any ideas on how to resolve it? >>>> gnucash-user mailing list >>>> [email protected] >>>> 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 >>> [email protected] >>> 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 [email protected] 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.
