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

Hi :)
Personally i would rather see Base becoming much easier and much more
reliable.  So instead of duplicating the database functionality it would
just be easier to incorporate it's use into spreadsheets that have grown a
bit further than might have been planned.

I feel like there are signs of this beginning to happen though.  The move
away from an internal java-based back-end to using a non-java-based one is
a good step imo.  The database experts on this mailing-list have pointed
out that much more needs to be done but i think getting away from java as
quickly as reasonably possible has been a crucial 'first' step.
Regards from
Tom :)




On 20 August 2014 14:52, dave boland <dboland9@fastmail.fm> wrote:

> 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

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