Thank you, Paul. I have followed the convolutions of the discussion with interest but you have more clearly presented what I tried to say in the beginning. After much of the discussion I now see many of the difficulties involved but I will follow your suggestion and see if I can phrase this clearly enough to present it as a Calc feature request. I must express my thanks to all who contributed. It is this type of interaction that can lead to a more useful product.
Paddy On 5 August 2014 16:15, Paul <[email protected]> wrote: > 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 > > -- 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
