Leonard Mada schrieb:
What are shared formulas? Is it the same as the concept I presented in a previous e-mail, where one can have a default formula for a column? This is indeed a very useful feature to have in OOo Calc and is one issue that gets into my TOP 5 of major design flaws of existing spreadsheets.
You cannot create shared formulas by yourself, neither in Calc nor in Excel. Excel creates them automatically e.g. when pasting a formula cell to a range selection. They are not visible in the user interface. A similar concept to have a named formula definition for multiple cells are "defined names" (Insert->Name->Define).
It definitely helps reduce the spaghetti code inherent to spreadsheets and is also an important concept when extending the simple spreadsheet to multidimensional spreadsheets. I will file a new feature request when I will have some time.
Shared formulas are intended to reduce memory usage and file size, don't know if they would help you. What do you mean with spaghetti code?
Daniel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
