You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/02/20 18:33:56 UTC
[Bug 124271] New: Bug or missing feature? Impossibility of linking
chart titles or axis names with cell contents.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Bug ID: 124271
Issue Type: DEFECT
Summary: Bug or missing feature? Impossibility of linking chart
titles or axis names with cell contents.
Product: Calc
Version: 4.1.0-dev
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: issues@openoffice.apache.org
Reporter: oleaga_jp@hotmail.com
CC: issues@openoffice.apache.org
Created attachment 82640
--> https://issues.apache.org/ooo/attachment.cgi?id=82640&action=edit
concept book to see how I used to do multilingual sheets in MS-EXCEL
Bug or missing feature?
I do not know if this is a bug or a missing feature; but when reading
spreadsheets written with MS-EXCEL if there are charts whose titles and axis
names depend on the contents of some cells AOO reads the present content of
the cells, but it does not actualize the title and the axis names when the
cells content changes.
I have found that feature extremely valuable when trying to write multilingual
spreadsheets (spreadsheets whose all contents appear on the language that you
choose among the ones available for that spreadsheet) but I have not found the
way to actualize the titles and axis names in AOO 4.0.1 or AOO 4.1.0
I attach a concept file to show how I used to work on MS-EXCEL.
If this feature is not available in AOO 4.1.0, is it going to be available in a
near future?
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Bug or missing feature? Impossibility of linking chart
titles or axis names with cell contents.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
CC| |elish@apache.org
--- Comment #1 from Edwin Sharp <el...@apache.org> ---
Please attach original working Excel file.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Bug or missing feature? Impossibility of linking chart
titles or axis names with cell contents.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
--- Comment #7 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Yes, the new sample shows the difference:
(a) modifying Number in C10
(a1) In AOO changes texts in column headings and so in Legend
Title stays as it was, is static text
(a2) In Excel also contents of Title changes language, because Title will be
created form contents of A13
(b) I don't know whether this one has ODF impact.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Bug or missing feature? Impossibility of linking chart
titles or axis names with cell contents.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords|needmoreinfo |
Status|UNCONFIRMED |CONFIRMED
Latest|--- |4.1-dev
Confirmation on| |
Ever confirmed|0 |1
--- Comment #6 from Edwin Sharp <el...@apache.org> ---
Confirmed with
AOO410m1(Build:9750) - Rev. 1569541
Rev.1569541
Win 7
Excel 2010
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Bug or missing feature? Impossibility of linking chart
titles or axis names with cell contents.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
Version|OOo 3.3 or older |4.1.0-dev
Summary|Need: Chart titles or axis |Bug or missing feature?
|names from cell content |Impossibility of linking
|source |chart titles or axis names
| |with cell contents.
OS|All |Windows 7
--- Comment #4 from Edwin Sharp <el...@apache.org> ---
Thank you.
Can you please email file?
For some reason download is broken.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Need: Chart titles or axis names from cell content
source
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|4.1.0-dev |OOo 3.3 or older
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Need: Chart titles or axis names from cell content
source
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|Windows 7 |All
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Need: Chart titles or axis names from cell content
source
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
--- Comment #11 from Jon Peli Oleaga <ol...@hotmail.com> ---
The charts in the Excel file I sent do not have axes; but, as I said in my
first comment, with the chart axis names in other kinds of charts there is the
same problem.
I do not know if you should take that into account to determine what to do.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Need: Chart titles or axis names from cell content
source
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords|needmoreinfo |
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Version|4.1.0-dev |OOo 3.3 or older
Summary|Bug or missing feature? |Need: Chart titles or axis
|Impossibility of linking |names from cell content
|chart titles or axis names |source
|with cell contents. |
OS|Windows 7 |All
--- Comment #3 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
A related report is "LibO#56303 - Allow Formula in Chart Title"
Some explications to the requirements:
<http://www.mrexcel.com/archive/Chart/8071.html>
<http://office.microsoft.com/en-001/excel-help/add-a-chart-title-HA102809718.aspx>
<http://www.accountingweb.com/article/automating-excel-chart-titles/219390>
I often wished OOo should have this feature, we never had it.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Need: Chart titles or axis names from cell content
source
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
j.nitschke@ok.de changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |j.nitschke@ok.de
--- Comment #9 from j.nitschke@ok.de ---
(In reply to Rainer Bielefeld from comment #7)
> (b) I don't know whether this one has ODF impact.
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#element-chart_title
> The <chart:title> element represents a title in a chart document.
>
> The text of a title is specified by a child <text:p> element or a
> table:cell-range attribute. If a child <text:p> element and a
> table:cell-range attribute are both present, the text specified
> by the table:cell-range attribute is used as the title.
A cell as source is valid, but not implemented. :(
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Issue 124271] Need: Chart titles or axis names from cell content
source
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Jon Peli Oleaga <ol...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oleaga_jp@hotmail.com
Version|OOo 3.3 or older |4.1.1
--- Comment #12 from Jon Peli Oleaga <ol...@hotmail.com> ---
Do we know if this issue is going to be solved for the 4.2.0 version of
OenOffice?
It depends on it the use of OpenOffice or MS-Office in my implementation of
multilingual spreadsheets.
--
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.
[Bug 124271] Need: Chart titles or axis names from cell content
source
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Bug or missing feature? |Need: Chart titles or axis
|Impossibility of linking |names from cell content
|chart titles or axis names |source
|with cell contents. |
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Need: Chart titles or axis names from cell content
source
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #82640|0 |1
is obsolete| |
--- Comment #8 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Comment on attachment 82640
--> https://issues.apache.org/ooo/attachment.cgi?id=82640
concept book to see how I used to do multilingual sheets in MS-EXCEL
Delete useless first attachment
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Need: Chart titles or axis names from cell content
source
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
--- Comment #10 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
So this is more or less request:
Due to
Open Document Format for Office Applications Version 1.2
Part 1: OpenDocument Schema
11.2 Title, Subtitle and Footer:
For <chart:title> element implement "table:cell-range" attribute
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Bug or missing feature? Impossibility of linking chart
titles or axis names with cell contents.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
--- Comment #5 from Edwin Sharp <el...@apache.org> ---
(In reply to Edwin Sharp from comment #4)
> Thank you.
> Can you please email file?
> For some reason download is broken.
No need, it's OK now.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124271] Bug or missing feature? Impossibility of linking chart
titles or axis names with cell contents.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124271
--- Comment #2 from Jon Peli Oleaga <ol...@hotmail.com> ---
Created attachment 82641
--> https://issues.apache.org/ooo/attachment.cgi?id=82641&action=edit
EXCEL file with chart titles linked to cells
I think this is an original EXCEL file (Not read with AOO and rewritten
afterwards) but I am not sure because nowadays I do not have EXCEL on my PC.
The language should be changed in the C10 cell of the RES1 spreadsheet.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.