https://bugs.documentfoundation.org/show_bug.cgi?id=154936
Bug ID: 154936
Summary: Why is it still not possible to set the title of a
diagram as formula?
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This - formally - is not an error, but a recommendation to increase user
comfort.
I very often paint diagrams, which are depending from certain cell contents.
The title, sub-title and of other text fields can only be inputted or changed
manually. So whenever I change the cell's content, that changes the data for
the diagram, I have to change the title, sub-title or other text fields in the
diagram manually.
Why isn't it possible to derive the title's text from a cell, that provides the
text for the title, e.g. to input "=$C$3" into the title and the title's
content then follows the text in cell C3. That would increase the usability by
far.
And why can't the width of title- and sub-title-text fields not really be
changed by the user?
brgs, gsc
Steps to Reproduce:
1.Input a factor into cell A1, e.g. 2.
2.In cells A2 to A7, input the formula's "=2*$A$1" to "=7*$A$1".
3.Now select cells A2 to A7 and insert a diagramm.
4.Give the diagram the title "Lines multiplied by 2".
5.If you change the cell A1's content, the data in the displayed diagram
changes, but not the title.
6. It is impossible to automatically change the "2" in the title by the content
of cell A1.
Actual Results:
If I input a formula into the title, it displays the formula as text.
Expected Results:
Formulas should be respected in the title and the title should accept "=$A$1"
as input.
Reproducible: Always
User Profile Reset: No
Additional Info:
None.
--
You are receiving this mail because:
You are the assignee for the bug.