[libreoffice-users] Feature Request for Calc - input forms and reports

All,

Spreadsheets are wonderful applications for financial analysis and
collections of information.  We use Calc to store information about the
tools in my tool chest, items in the pantry, and I know a lady that uses
a spreadsheet for the shoes in her closet.  Basically, Calc is being
used as a flat-file database, which spreadsheets do well and they are
easy to understand.  Calc offers the ability to sort and to filter,
which is really a type of query.
 
What Calc doesn't offer though is the ability to have input forms and
reports.  Consider a spreadsheet for the tools in a tool chest.  It may
have the following fields (columns): ChestNumber, DrawerNumber,
SectionNumber, ToolName, ToolDesc, Comment.  On sheet 2 there are
columns for verification for ChestNumber, DrawerNumber, SectionNumber
and ToolName.
 
It would be nice if a custom data input form could be created like is
done with Base, though a little easier to create.  It would also be nice
if there was a report function so I can have a printout of all of my
tools.  The report may look something like this:
 
Title: Tool Chest Contents
Report Date: 8/20/14
 
Chest  Drawer  Section  Tool Name                Tool
Description/Comment
-----  ------  -------  -----------------------  ----------------------- 
1      3       1        Combination wrenches     Wrench sizes: 3mm-33mm
                                                 7mm wrench missing

Notice that the Comment field has been placed under the Description
field.  This is commonly done in database reports because most records
don't have comments, so there is not much need for a separate column.
 
So, yes, I'm asking for more database features in Calc.  However, simple
databases are a very common use for spreadsheets, so why not embrace the
situation with more functionality?
 
Thanks,
Dave
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - Send your email first class


-- 
To unsubscribe e-mail to: users+unsubscribe@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