Sorry, I should have clarified, my tests were done on a Mac. I don’t have a Windows setup to test.
I did find some forums concerning LO paste issues with respect to Windows however. Regards, Adrien > On Jan 3, 2019, at 3:59 PM, David Carlson <[email protected]> wrote: > > Hello All, > > Happy New Year. > > I am sending this from an Android tablet that sometimes makes really > punctuation and language errors, including dropping words like stupid from in > front of the word errors. > > I have yet to solve my strange GMAIL problem in Firefox on my laptop, but I > did succeed in copying the message that was stuck in the drafts folder before > it crashed to a different machine and send it to the Gnucash user maillist, > Where it currently resides in the archive and in my sent folder of some of > my devices, but I am not sure if it was sent to others on the list. > > I see that Adrien reports that he performed several tests with the current > versions of LibreOffice. And Gnucash in a windows environment without > encountering the problems that Barry has seen. Not knowing exactly why he > wants to use that mix, it is hard to say whether certain rough edges are of > concern to him. > > Hopefully we are giving him clues that he will find helpful, and if he is > still having issues, more details about his situation. > > David C > > > On Thu, Jan 3, 2019, 3:15 PM Adrien Monteleone > <[email protected] wrote: > I just tested the following using LibreOffice 6.1.0.3 and GnuCash 3.4: > > 1. ctrl+a (select-all) and ctrl+c (copy) from the report within the GnuCash > report tab (not a saved file), then ctrl+v (paste) on a blank Calc > spreadsheet. > > I was given a dialog to choose import coding, select my delimiters, and > otherwise fine-tune the import (paste) with a preview of my actual data. > > The result is the data was imported without formatting into their respective > cells, except that ’Totals’ somehow had a newline character before the > figures which would necessitate some additional copy/paste to align them > correctly. > > 2. Save the report to an .html file, open that file with Firefox and then > repeat the above select/copy/paste commands. > > This gave me a less useful dialog box with little control over the end > result. I was able to only select the import language and asked if I wanted > to detect ’special numbers’ like dates. > > I ended up with a formatted version of the report as it appeared in Firefox > but with each respective title or figure in a proper cell > > 3. File > Open the .html file from within Calc as suggested by Chris Lam. > > Without a dialog box, this resulted in a similar situation to #2, but with no > grid lines within the report. (like a sheet of paper overlaying the grid) > > 4. Sheets > Insert Sheet from File (or Insert Sheet and then choose ‘From > File’ radio button) > > I chose to ‘insert’ the .html file. This gave me the same dialog box as #2, > but the result was the same as #3. I could choose to insert before or after > the current sheet. > > > Note, options 1-2 place the data on the current Calc notebook sheet. > > Option 3 opens an entirely new workbook with only 1 sheet as your report. > (unless you’ve set default # of sheets higher) > > Option 4 is *adding* a sheet to the notebook, so you can only place it before > or after the current one. > > In every case, the data came through just fine, though I’d probably find 3 or > 4 most useful as everything is already lined up. If you wanted no empty > columns between your account titles and the values, 1 or 2 would work best, > but as noted, you’ll have to do some adjusting if you included parent account > total lines. > > Though I used the keyboard shortcuts, Edit > Paste was always available. > Perhaps there is an issue with the workbook or the sheet itself that is > disabling it? Try a websearch on ‘Edit > Paste not available, just Paste > Only’ for LibreOffice. > > A cursory search turns up possibilities of a protected sheet, a read-only > workbook, and a long-standing bug on the Windows platform that doesn’t seem > to be easily reproducible. However, for those first two possibilities, I > would think none of the paste functions would be available. > > I also see a suggestion that 3rd party clipboard managers sometimes don’t > play nice with LO. > > > Regards, > Adrien > > > > On Jan 3, 2019, at 6:09 AM, Finbar Mahon <[email protected]> wrote: > > > > Thanks both, but I still seem to be having a problem. > > > > I have a file - > > > > .... /gnu p&l2018.html > > > > If I try to cut and paste the data to a new libreoffice calc file I get > > only 'paste only' as an option under >edit, and nothing else recognisable > > from >insert. > > > > I have tried 'insert sheet' under >insert but only get the option to insert > > before or after and then cannot copy the 'new' sheet into an existing one, > > if I add 'after' > > > > There doesn't seem to be a method of cut and paste directly, afaics. > > > > Thanks, Barry > > > > On 02/01/2019 17:51, David Carlson wrote: > >> Finbar, > >> > >> You may need to first open a new blank spreadsheet then cut and paste from > >> the html document into the spreadsheet rather than trying to directly open > >> HTML with Calc. > >> > >> My experience with LibreOffice Calc is that it will import several > >> different kinds of files. I use it regularly to convert transaction > >> detail exports from a certain department store website to a form from > >> which I can manually extract data to enter into GnuCash, although I have > >> not figured out how to restructure it to use the CSV importer for that > >> case. > >> > >> David C > >> > >> On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon <[email protected] > >> <mailto:[email protected]>> wrote: > >> > >> Hello, > >> > >> I exported a GNUCash report to HTMl, but I don't seem to be able to > >> import it to LibreOffice Calc, the LibreOffice xl equivalent. > >> > >> Does anybody know if I must use 'real' MS XL to receive the HTML > >> file? > >> In LibreOffice you can save calc files in MS format. Are there any > >> special tricks for importing? > >> > >> I am using 3.3 on Windows 10. > >> > >> Thanks, Barry > >> > >> _______________________________________________ > >> gnucash-user mailing list > >> [email protected] <mailto:[email protected]> > >> 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. > >> > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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. > > > _______________________________________________ > gnucash-user mailing list > [email protected] > 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. _______________________________________________ gnucash-user mailing list [email protected] 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.
