In a spreadsheet I get all the information I require and it is easy to get
additional information if needed. I can add, modify, and delete headers both
horizontally and vertically. I can add, modify, or delete cells, rows, or
columns at will. As long as I leave the original data alone, I can add as
many calculated columns or rows as I wish. One of my spreadsheets is a
complete double entry bookkeeping system. I can use split or freeze to keep
the column and row titles visible while scrolling through the data of the
According to what I read last night, you must be very careful or you may
compromise essential data. The implication was that it would be easier and
safer to create a new database than to modify it. From the
"Fields can be added or deleted, but adding a field requires you to enter
the data for that one field for every existing record with an entry for that
"Deleting a field deletes all the data once contained in that field."
"Changing the field type of a field can lead to data being lost either
partially or completely."
"Deleting a table removes all of the data contained in every field of the
I will continue reading, but so far it seems that a spreadsheet has all the
advantages and none of the disadvantages of a database.
My knowledge of databases is very limited. If there is any advantage in
using a database over a spreadsheet, please share it with me.
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
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
Impressum (Legal Info)
: 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