To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=67499
User discoleo changed the following:
What |Old value |New value
================================================================================
Summary|HEADER for Calc-Worksheets|HEADER: Defining Named-Ran
| |ges in Calc-Sheets
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri May 23 21:54:41 +0000
2008 -------
The ODF-solution for issue 66886 as proposed by David Wheeler touches also this
issue, see:
http://lists.oasis-open.org/archives/office/200608/msg00001.html
This feature request is aimed to extend the original proposal:
- the sheet-headers would contain the definitions for the
locally scoped named-expressions / named-ranges
- but will extend the concept to allow declaration of locally scoped
constants / variables
-- constants / variables are not yet available in spreadsheets
This feature basically will separate the data-layer from the various variables
declared within a spreadsheet. Why mix i.) the data with ii.) the formulas and
with iii.) declarations of other variables.
The i.) and ii.) points are covered in a distinct issue (Multidimensional
Spreadsheets), while this issue covers point (iii).
This will lead to a more structured spreadsheet and reduce the rate of errors.
Also, users should be able to add useful comments to these named ranges and
declared variables (e.g. to specify what the named range / variable actually
represents).
e.g. soemthing like:
[sorry IF I srewed the XML up, I don't understand much of it]
<define name="table-table">
<element name="table:table">
[...]
<optional>
<ref name="table-named-expressions"/>
<table:named-expressions>
<table:named-range table:name=""
table:cell-range-address="$D$2:$D$101"
<comment>Range containing first 100 dates<comment/>
<table:named-range />
<table:named-expression
table:name="MakeFour"
table:expression="2+2"/>
<comment>Computes locally the time in years<comment/>
<table:named-expression />
<table:named-constant
table:name="LocalTimePeriod"
table:expression="4">
<comment>Stores locally the time in years<comment/>
<table:named-constant />
</table:named-expressions>
</optional>
</element>
</define>
---------------------------------------------------------------------
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]
