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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: 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.