[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libreoffice-users] Re: CALC - How to count blank cells?
- Subject: [libreoffice-users] Re: CALC - How to count blank cells?
- From: Andreas Säger <firstname.lastname@example.org>
- Date: Tue, 10 Jul 2012 11:52:27 +0200
- To: email@example.com
Am 10.07.2012 05:34, Simon Cropper wrote:
IMHO, the tone and content of your response is not very helpful and
belittles other peoples attempts to assist.
Do you know how much a client feels belittled by misleading (overly complicated) answers?
Outlining the keystrokes
mentioned and how databases might assist in what you presume he needs
would have been more useful.
I can't write one tutorial for each client. I just wanted to indicate that Michael doesn't have to deal with convoluted formulas when he adjusts himself to the mere basics of the given simple tool. For more convenience (and for untrained users) there are more sophisticated tools such as input forms bound to databases.
Something like INDEX(OFFSET(COUNTA)) is not reliable enough because it assumes no gaps. The second shaky assumtion is that the area below the assumed list is always completely blank.
The concept of a manual sort order where the editor of a list has to append/insert at particular positions is highly questionable. Any order of rows should be enforcable by a defined sort order. If the order of entry really matters, you've got to insert new data together with an automatic time stamp.
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
|Re: [libreoffice-users] CALC - How to count blank cells?||Michael Reich <email@example.com>|
|Re: [libreoffice-users] CALC - How to count blank cells?||Simon Cropper <firstname.lastname@example.org>|
|Re: [libreoffice-users] CALC - How to count blank cells?||MiguelAngel <email@example.com>|
|[libreoffice-users] Re: CALC - How to count blank cells?||Andreas Säger <firstname.lastname@example.org>|
|Re: [libreoffice-users] Re: CALC - How to count blank cells?||Simon Cropper <email@example.com>|
- Prev by Date: [libreoffice-users] Which template categories are built-in, how to name custom ones?
- Next by Date: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc
- Previous by thread: Re: [libreoffice-users] Re: CALC - How to count blank cells?
- Next by thread: [libreoffice-users] a little math problem with Calc