To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85825
------- Additional comments from [EMAIL PROTECTED] Tue Aug 12 20:55:43 +0000 2008 ------- This is a quote from the MS-forums and it highlights another use case for the proposed functionality. The post might better explain what I tried to accomplish with multidimensional spreadsheets (although the concept of multidimensionality goes far beyond this simple case): [I have corrected some misspellings] > Why not a HEADER FORMULA. > When I bring data through queries, I typically end up adding calculated > columns on the excel side. Each column has the same formula, I just copy > the formula up to the last record. At every refresh, the number of records > may change and I could need to copy further down. When I am tired to repeat > the process, I copy the formula for more rows than enough and typically, > I end up having unnecessary calculated rows. Usually, I keep a copy of > the formula over the header line. In this case, since we can treat the data > as a "table", we could prevent this copy process by defining the calculated > columns from the top line, the HEADER FORMULA. The calculated rows would > adjust automatically the same way the filters does. > > Jean --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
