proposals for charts: error-indicators, text-auto-scaling

[Lars Oppermann <Lars.Oppermann@Sun.COM>]

Dear TC members,

I am forwarding the following two proposals created by the
OpenOffice.org-Chart development team concerning chart axes
for inclusion into OpenDocument 1.2...

----------------------------------------------------------------------

Chart: Error Indicators from Cell Range

Add a possibility to have error bar values from cell-ranges. Add an item 
cell-range to the list of possible error categories in section 15.33.2:

* Use values from cell ranges for positive and negative error indicators

<define name="style-chart-properties-attlist" combine="interleave">
     <optional>
         <attribute name="chart:error-category" a:defaultValue="none">
             <choice>
                 <value>none</value>
                 <value>variance</value>
                 <value>standard-deviation</value>
                 <value>percentage</value>
                 <value>error-margin</value>
                 <value>constant</value>
                 <value>cell-range</value>
             </choice>
         </attribute>
     </optional>
</define>

In addition there are two attributes needed to indicate the ranges. Add 
the following text to section 15.33.2 before Error Indicators:

Cell Ranges for Lower and Upper Error If the error category is set to 
cell-range, the chart:error-lower-range and chart:error-upper-range 
attributes determine the cell ranges which contain the values to be used 
for the lower and upper error indicators.

<define name="style-chart-properties-attlist" combine="interleave">
     <optional>
         <attribute name="chart:error-lower-range">
             <ref name="cellRangeAddress"/>
         </attribute>
     </optional>
     <optional>
         <attribute name="chart:error-upper-range">
             <ref name="cellRangeAddress"/>
         </attribute>
     </optional>
</define>

----------------------------------------------------------------------

Chart: Text Auto-Scaling

Allow the chart:scale-text property for more objects than only the 
chart:chart element. Note, that the specification says nothing about 
where this property can appear at the moment. Obviously, the 
implementation never has exported it. The old description of section 
15.29.1 just said: The chart:scale-text property is used to specify that 
all text objects in the chart should be scaled whenever the size of the 
chart changes., so one could imply that it can be used for the 
chart:chart element, but it is not explicitly stated.

Some thoughts on this are on the Ooo-Wiki:
http://wiki.services.openoffice.org/wiki/Chart2#Autoscaling_of_Text_relative_to_Diagram_Size

* Add:
15.32.4 Automatically Calculated Postion and Size

Some chart elements support automatic positioning. If an object should 
be automatically positioned, the property chart:auto-position is set to 
true. In this case the explicit positions, that may be given 
additionally in svg:x and svg:y attributes, are irrelevant for 
rendering, they only serve as cache to give an idea what the calculated 
position was when the file was stored.

Some chart elements also support an automatic size. If the size of an 
object should be calculated automatically, the property chart:auto-size 
is set to true. In this case the explicit size, that may be given in 
addition as svg:width and svg:height attributes, are irrelevant for 
rendering, they only serve as cache to state what the size was when the 
files was stored.

<define name="style-chart-properties-attlist" combine="interleave">
     <optional>
         <attribute name="chart:auto-position" a:defaultValue="false">
             <ref name="boolean"/>
         </attribute>
     </optional>
     <optional>
         <attribute name="chart:auto-size" a:defaultValue="false">
             <ref name="boolean"/>
          </attribute>
     </optional>
</define>

* Just noted: Change the subsection Position and Size to Positioning in 
section 10.3.1 Title

* Change the text in section 10.5 Plot Area subsection Plot Area 
Positioning to:

Plot Area Position and Size

The plot area's position and size are determined by the common 
positioning and sizing attributes for drawing objects. The position and 
size can be determined automatically by the rendering application. This 
is indicated by the properties chart:auto-size and chart:auto-position 
(see 15.32.4).

If the position and size attributes are not specified, the properties 
chart:auto-position and chart:auto-size are assumed to be true. However, 
if objects scaling with the plot-area have a property chart:scale-text 
(see 15.29.1) with value true, the size of the plot-area must be given 
explicitly.

* Change the text in section 15.29.1 Scale Text to:

The chart:scale-text property is used to specify that the text contained 
in an object should be scaled whenever the size of the chart or the 
plot-area changes. The property can appear at all chart objects that 
contain text. Objects that are inside the plot-area, which are axes, 
data series and data points scale on resizes of the plot-area. The 
legend and the titles resize with the whole chart object.

To enable scaling, set the value of this property to true. If the 
property is true, the corresponding size of the chart:chart element (see 
10.2.2) or the chart:plot-area (see 10.5.1) must be set explicitly, 
otherwise the scaling property will not work.

-- 
Lars Oppermann <lars.oppermann@sun.com>               Sun Microsystems
Software Engineer                                         Nagelsweg 55
Phone: +49 40 23646 959                         20097 Hamburg, Germany
Fax:   +49 40 23646 550                  http://www.sun.com/staroffice