Re: [libreoffice-users] Re: why filled alignment for cells?

2014-12-07 Thread Lera Goncharuk
Hi Urmas, Thank you a lot. I had not thought about that. Lera В письме от 7 декабря 2014 01:50:05 пользователь Urmas написал: > This feature was used for making horizontal rulers in text mode spreadsheets > and is kept for roundtrip compatibility. -- To unsubscribe e-mail to: users+unsubscr...

Re: [libreoffice-users] Re: Document Page Numbering Problems

2014-12-07 Thread jonathon
On 06/12/14 12:38, Brian Barker wrote: > I'm not an expert, but I believe not. As you say, the Windows operating > system certainly works this way: a copy you purchase with a new computer > cannot be transferred. But I don't think this generally applies to > Microsoft's application software, suc

Re: [libreoffice-users] calc and bookkeeping

2014-12-07 Thread Wiebe van der Worp
On 07-12-14 15:03, Dan Lewis wrote: On 12/07/2014 08:12 AM, Wiebe van der Worp wrote: Input: In order to keep things simple: three columns with Description, Amount and a LedgerCode. Output: Sums per LedgerCode The question: What is the most efficient approach in order to keep the sheet alive

Re: [libreoffice-users] calc and bookkeeping

2014-12-07 Thread Tom Davies
Hi :) Ahh, just had a quick look at a set of accounts and noticed that b/fwd and c/fwd ARE used the logical way around. For some reason i've always thought they were counter. So the c/fwds figures ARE at the bottom of the sheet and show the sub-totals of that sheet. The b/fwds figures ARE at the

Re: [libreoffice-users] calc and bookkeeping

2014-12-07 Thread Wiebe van der Worp
On 07-12-14 14:36, Tom Davies wrote: Spreadsheets are not really made to be good at accounting and bookkeeping. GnuCash or other dedicated programs might be better. Spreadsheets are designed to do a lot of calculations. GnuCash... haven't used it for so long that I forgot it did exist. Nice s

Re: [libreoffice-users] calc and bookkeeping

2014-12-07 Thread Stefan Weigel
Hi, Am 07.12.2014 um 14:12 schrieb Wiebe van der Worp: > Input: In order to keep things simple: three columns with > Description, Amount and a LedgerCode. > > Output: Sums per LedgerCode PivotTable aka DataPilot is exaktly what you are looking for. It´s a feature of Calc, of course. ;-) Here i

Re: [libreoffice-users] calc and bookkeeping

2014-12-07 Thread Tom Davies
Hi :) Spreadsheets are not really made to be good at accounting and bookkeeping. GnuCash or other dedicated programs might be better. Spreadsheets are designed to do a lot of calculations. So, spreadsheets ARE great for doing "working papers" such as to; * "reconciliations" (although the dedicat

Re: [libreoffice-users] calc and bookkeeping

2014-12-07 Thread Dan Lewis
On 12/07/2014 08:12 AM, Wiebe van der Worp wrote: First post, not sure it is the right place, hi there! For 2015 I would like to keep a shadow bookkeeping in Calc in order to check our bookkeeping program for a while. Input: In order to keep things simple: three columns with Description, Amo

[libreoffice-users] calc and bookkeeping

2014-12-07 Thread Wiebe van der Worp
First post, not sure it is the right place, hi there! For 2015 I would like to keep a shadow bookkeeping in Calc in order to check our bookkeeping program for a while. Input: In order to keep things simple: three columns with Description, Amount and a LedgerCode. Output: Sums per LedgerCode