Dotan Cohen wrote:
Input masks are made for database forms where you have fields and records
rather than cells:
http://user.services.openoffice.org/en/forum/viewtopic.php?t=22506&p=102636#p102636
I knew that I was using the wrong term, but what I meant was: "a way
to tell the computer that an integer [0,23] should be read as
belonging to the hour".
If [0,23] means two integers 0 and 23 to be read as hours and minutes:
A1: 0
B1: 23
other cell, formatted as time: =A1/24+B1/1440
Anyway, I always recommend to NOT store any lists of constant values
within a spreadsheet. Always try to store lists of data in some type of
(networkable/multi-user/rlational/scalable) database and use the very
same data in all your office documents and many other applications able
to read from your database.
The most simple database (local/single-user/non-relational) consists of
a directory where you save your flat spreadsheet list(s) in the dBase
file format. Then you connect a so called "Base document" (actually a
configuration file) to the dBase directory, analog to that insane
"Bibliography" example database.
Tweak the table fields a little bit so your fields are unique or not,
mandatory or optional and use the right lengths and digits.
Using imported database ranges, Calc can do some magic that used to be
impossible with unstructured cell ranges. Simply set the extra options
of your import range (Data>Define...[More])
- The sizes of formatted ranges and adjacent formula ranges do update
with your record sets as your table grows and shrinks.
- All references update likewise (references in formulas, charts,
conditional formattings, validations,...).
- Simple queries allow you to use the database data in predefined orders
of rows and columns.
- You may decide to not store copies of imported data in the spreadsheet.
- Filters and sort orders are not as restricted as in a spreadsheet.
- A simple input form for your table is a matter of a minute.
- The Sun Report Builder Extension creates professional reports.
Base can do so much more than Calc alone. Just do not try to build a
fully functional database solution with Base.
[Tutorial] Using registered datasources in Calc :
http://user.services.openoffice.org/en/forum/viewtopic.php?f=75&t=18511
Simple, flat database table used in a spreadsheet:
http://user.services.openoffice.org/en/forum/viewtopic.php?t=21099&p=96427#p96427
(input form, user defined filter form, data pilot, free of macro code)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
