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