[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] Re: Schema in Calc


On Mon, 04 Aug 2014 09:45:20 +0200
Alex Thurgood <alex.thurgood@gmail.com> wrote:

> Le 31/07/2014 00:08, Paul a écrit :
> > Just out of interest, why would a db driver come into play? This is
> > a spreadsheet we're talking about.
> >
> > The mention of db schema was merely to ask why Calc doesn't have
> > something like it.
> >
>
> How else would one obtain the schema in the first place ?

I believe one of us is misunderstanding things. My understanding is
that the OP didn't actually want a database schema, he just wanted
something similar for normal spreadsheets.

So basically, create normal spreadsheet from scratch, develop it over
time to do some fancy calculations on multiple worksheets (or maybe
even only one). Then, sometime later, want to make changes, but
being unsure of what effects those changes will have in terms of other
formulae relying on cells you want to modify, you would like some sort
of outline of how all the data in the spreadhseet interacts.

At no point in this is a database ever introduced. The word schema
makes one think of a database, but I think the OP only used it to say he
wanted something like it. He doesn't actually want a database schema.

Now for spreadsheets, as they store unstructured data whereas databases
store structured data, a schema-like outline would be well-nigh
impossible to generate. But some sort of filterable listing of formulae
would help a lot with the above scenario, and is what I have proposed.

I think this should be a feature request for Calc, personally.

Paul

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

Follow-Ups:
Re: [libreoffice-users] Re: Schema in Calcdave boland <dboland9@fastmail.fm>
Re: [libreoffice-users] Re: Schema in CalcPat Brown <mistyhaven@gmail.com>
References:
[libreoffice-users] Schema in CalcPat Brown <mistyhaven@gmail.com>
[libreoffice-users] Re: Schema in CalcAlexander Thurgood <alex.thurgood@gmail.com>
Re: [libreoffice-users] Re: Schema in CalcPaul <paulsteyn1@afrihost.co.za>
[libreoffice-users] Re: Schema in CalcAlex Thurgood <alex.thurgood@gmail.com>
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.