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 ?
Sincerely
Ian Graham
Wales
UK
--
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