I use Calc to run a monthly (non-financial) spreadsheet for a small charity I'm secretary to - a page per month, client cases on the vertical, various circumstantial details across the columns, SUM at the bottom of each column, the first of them a simple 'tally' column ( '1' entered for each caes to give a monthly total.)

Last month's page had 22 rows. When I came to sum up and report, I realised the tally total wasn't in fact agreeing with the other totals. The same formula applies (they are all drag-copied from an original entry on a page some months back), but the SUM total in the Tally column is simply wrong - out by 1 to everything else.

Since it was such a small page, it was easily spotted and allowed for. In a larger page, it might have been a 2-coffee hold-up.

I report it more out of curiosity than anything else. Has anyone come across similar instances ?


Ian Graham

To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to