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: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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
Context
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.