Re: [GNC] Reports in whole currency units
Thanks Adrien. My real wish is to simply print my report without the extra step. My question comes because I can see how to print with decimal places 1 to however many. Before I think about submitting a request for modification I throw out the question to anyone with better knowledge than mine of GNU Cash(very low bar) is there any technical reason why reports can go to 1 decimal place but not to no decimal places. Out of curiosity I will explore your other Excel ideas and try html file in Libre Office which I also have. (Mainly use Excel for compatibility with accountants and through that have done intensive skills development over time. Thanks & regards Richard Richard Gaede On 19/01/2019 10:08, Adrien Monteleone wrote: Richard, You can also select-all and copy/paste from the report without exporting first, that *should* get you some sane column widths. I don’t use Excel, but I know this works rather well in LibreOffice. Others on here may have some better experience with Excel. (note, as with LibreOffice, Excel might have multiple ways to bring in data. Other than just trying to open an HTML file, see if there is an ‘insert sheet from file’ or similar option) Regards, Adrien On Jan 18, 2019, at 5:03 PM, Richard Gaede wrote: Thanks Adrien. I have been the export/spreadsheet route before. Reports get exported as .html files which read into Excel OK except that the column widths are all over the place and its far more time consuming to format them satisfactorily than to surrender and accept 2 decimal place reports. Thanks & regards Richard On 18/01/2019 12:24, Adrien Monteleone wrote: Other than entering your transactions in whole dollars, no. An option would be to export or copy/paste to a spreadsheet and format those cells to truncate or round the amounts. There you can also show amounts as multiples of any value you like, for example, reporting in K’s or M’s of dollars. Regards, Adrien On Jan 17, 2019, at 6:39 PM, Richard Gaede wrote: Hi, I have explored every avenue I could see to get reports to use whole dollar amounts rather than dollars and cents. Is there some way I have missed to configure reports to display whole dollars only? Any input welcomed. Thanks & regards -- Richard Gaede ___ 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.
Re: [GNC] Reports in whole currency units
Thanks Adrien. I have been the export/spreadsheet route before. Reports get exported as .html files which read into Excel OK except that the column widths are all over the place and its far more time consuming to format them satisfactorily than to surrender and accept 2 decimal place reports. Thanks & regards Richard On 18/01/2019 12:24, Adrien Monteleone wrote: Other than entering your transactions in whole dollars, no. An option would be to export or copy/paste to a spreadsheet and format those cells to truncate or round the amounts. There you can also show amounts as multiples of any value you like, for example, reporting in K’s or M’s of dollars. Regards, Adrien On Jan 17, 2019, at 6:39 PM, Richard Gaede wrote: Hi, I have explored every avenue I could see to get reports to use whole dollar amounts rather than dollars and cents. Is there some way I have missed to configure reports to display whole dollars only? Any input welcomed. Thanks & regards -- Richard Gaede ___ 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. -- Richard Gaede Trustee ___ 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.
Re: [GNC] Reports in whole currency units
Richard, You can also select-all and copy/paste from the report without exporting first, that *should* get you some sane column widths. I don’t use Excel, but I know this works rather well in LibreOffice. Others on here may have some better experience with Excel. (note, as with LibreOffice, Excel might have multiple ways to bring in data. Other than just trying to open an HTML file, see if there is an ‘insert sheet from file’ or similar option) Regards, Adrien > On Jan 18, 2019, at 5:03 PM, Richard Gaede wrote: > > Thanks Adrien. I have been the export/spreadsheet route before. Reports get > exported as .html files which read into Excel OK except that the column > widths are all over the place and its far more time consuming to format them > satisfactorily than to surrender and accept 2 decimal place reports. > > Thanks & regards > > Richard > > On 18/01/2019 12:24, Adrien Monteleone wrote: >> Other than entering your transactions in whole dollars, no. >> >> An option would be to export or copy/paste to a spreadsheet and format those >> cells to truncate or round the amounts. There you can also show amounts as >> multiples of any value you like, for example, reporting in K’s or M’s of >> dollars. >> >> Regards, >> Adrien >> >> >>> On Jan 17, 2019, at 6:39 PM, Richard Gaede >>> wrote: >>> >>> Hi, >>> >>> I have explored every avenue I could see to get reports to use whole dollar >>> amounts rather than dollars and cents. Is there some way I have missed to >>> configure reports to display whole dollars only? >>> >>> Any input welcomed. >>> >>> Thanks & regards >>> >>> -- >>> >>> Richard Gaede > ___ 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.
Re: [GNC] Reports in whole currency units
Other than entering your transactions in whole dollars, no. An option would be to export or copy/paste to a spreadsheet and format those cells to truncate or round the amounts. There you can also show amounts as multiples of any value you like, for example, reporting in K’s or M’s of dollars. Regards, Adrien > On Jan 17, 2019, at 6:39 PM, Richard Gaede wrote: > > Hi, > > I have explored every avenue I could see to get reports to use whole dollar > amounts rather than dollars and cents. Is there some way I have missed to > configure reports to display whole dollars only? > > Any input welcomed. > > Thanks & regards > > -- > > Richard Gaede > > ___ > 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. > ___ 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.
[GNC] Reports in whole currency units
Hi, I have explored every avenue I could see to get reports to use whole dollar amounts rather than dollars and cents. Is there some way I have missed to configure reports to display whole dollars only? Any input welcomed. Thanks & regards -- Richard Gaede ___ 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.
