On Mon, 04 Aug 2014 09:45:20 +0200 Alex Thurgood <[email protected]> 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: [email protected] 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
