Last year I found the process of getting a budget report in a spreadsheet
confusing (
https://lists.gnucash.org/pipermail/gnucash-user/2020-May/091064.html). I
understood it after help from the community and twigging to turning off the
white background colour for the cells on the page. It would be
Rich
I just managed to get a balance sheet report into calc on LM20 by copying the
html from the report to the clipboeard then used Edit->Paste Special-
>Unformatted Text then selected only the tab separator (having comma or space
selected is a disaster). It copied from the clipboard with no prob
Ah I didn't think of that - been a long while since I stopped writing
design docs and had to link in an external object :-) So we're both still
learning which is good !!!
Cheers David H.
On Fri, 25 Jun 2021 at 08:58, Rich Shepard wrote:
> On Fri, 25 Jun 2021, David H wrote:
>
> > You'll proba
On Fri, 25 Jun 2021, David H wrote:
You'll probably have to do a bit of cleaning up whichever way you go if
you want to get rid of all the extraneous headers the are in the html file
to get to a true .csv looking file :-)
David,
Figured out how to do it. In Calc -> Sheet -> Link to external d
I just used Ubuntu's file explorer to open the folder with the .html file
in and then right clicked which gives me a dialog box that I can choose
lots of options one of which is what I want to do - it's actually the 2nd
option down not the bottom one which says "Other Application"...
Cheers David
You'll probably have to do a bit of cleaning up whichever way you go if you
want to get rid of all the extraneous headers the are in the html file to
get to a true .csv looking file :-)
Cheers David H.
On Fri, 25 Jun 2021 at 08:46, Rich Shepard wrote:
> On Fri, 25 Jun 2021, David H wrote:
>
>
On Fri, 25 Jun 2021, David H wrote:
Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open
the .html file directly and you can save it as .csv from there - you just
have to make sure when you are asked what you want to open the .html file
with you click on "Other Application"
On Fri, 25 Jun 2021, David H wrote:
Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open
the .html file directly and you can save it as .csv from there - you just
have to make sure when you are asked what you want to open the .html file
with you click on "Other Application"
On Fri, 25 Jun 2021, David H wrote:
What about the cut and paste from html into Calc ?
David,
I'd first have to remove all the html markup. If I do that I have a plain,
ASCII text file regardless of where it's used. And I can reformat it in
emacs however I want.
Regards,
Rich
__
Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open
the .html file directly and you can save it as .csv from there - you just
have to make sure when you are asked what you want to open the .html file
with you click on "Other Application" at the bottom of the dialog box and
sc
What about the cut and paste from html into Calc ?
Cheers David H.
On Fri, 25 Jun 2021 at 08:15, Rich Shepard wrote:
> On Fri, 25 Jun 2021, David H wrote:
>
> > Don't know what your objective is but if it helps MS Excel on MacOS will
>
> David,
>
> That's fine if you run Apple and Microsoft sof
On Fri, 25 Jun 2021, David H wrote:
Don't know what your objective is but if it helps MS Excel on MacOS will
David,
That's fine if you run Apple and Microsoft software; the linux spreadsheets
I use, gnumeric and LibreOffice's Calc won't work with .pdf or anything
other than .xls(x) or .csv.
On Thu, 24 Jun 2021, David Carlson wrote:
I have not tested this, but sometimes one can either open a pdf file with
a spreadsheet application or copy a PDF file and paste it into a new
spreadsheet. Once that is done it is often relatively easy to clean up
stray cells and save in CSV format.
Da
On Thu, 24 Jun 2021, John Ralls wrote:
It usually works to copy-and-paste the report into a spreadsheet.
John,
Oh. Okay.
Thanks,
Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
Rich,
Don't know what your objective is but if it helps MS Excel on MacOS will
open a txn report html directly - looks ok and you could probably save as
csv from there ? Also Numbers won't open it directly but you can highlight
everything and paste it into a blank sheet which you could export to
I have not tested this, but sometimes one can either open a pdf file with a
spreadsheet application or copy a PDF file and paste it into a new
spreadsheet. Once that is done it is often relatively easy to clean up
stray cells and save in CSV format.
On Thu, Jun 24, 2021 at 4:32 PM Rich Shepard
w
> On Jun 24, 2021, at 2:31 PM, Rich Shepard wrote:
>
> Is there a way to export a transaction report as a .csv or .txt file? I
> looked at all options and didn't see any place to select the export format.
> When I did export the file it defaulted to .html; that would take a lot of
> cleaning a
Is there a way to export a transaction report as a .csv or .txt file? I
looked at all options and didn't see any place to select the export format.
When I did export the file it defaulted to .html; that would take a lot of
cleaning and it would be nice to export to .csv or .txt.
Any thoughts?
Ri
18 matches
Mail list logo
