Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.