[libreoffice-users] Re: database or spreadsheet

Am 06.02.2012 18:24, Paul D. Mirowsky wrote:
> Everybody knows how write simple math statement as a formula. Everybody
> doesn't know how to right an SQL statement.

"My users" can not fill out spreadsheets properly. They have no idea how 
to write formulas, they don't understand cell formats, subtile input 
methods nor do they want to expand any formulas for growing lists.

Even for the most simple protocols and item inventories I provide them a 
set of input forms. They pick options from list boxes, write dates into 
date fields (or pick them from a calendar), check boolean options, type 
numbers into numeric fields and remarks into multi-line boxes.
Automatic time stamps and user names are not even visible.
I use to keep older versions of my forms so everybody can choose the 
preferred input form for the job.
For each virtual item they use, they see who has introduced it at which 
time, who else used that item today and how many items are left.
"My users" never have to think about storing any file in some file 
format. Every record is stored on a server when they move to another 
record unless the record is invalid.
"My users" update/insert/delete full records without bothering about 
references nor formattings.
When you pull the plug out of the wall the currently edited record is 
the maximum you lose.
When they want to print something, they hit a button which generates a 
spreadsheet from template with charts and formulas dumping the requested 
data into preformatted import range(s) and print areas.
The whole system works with a tiny amount of macro programming.


--
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