[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-12 Thread dr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971





--- Additional comments from [EMAIL PROTECTED] Wed Mar 12 10:18:46 + 
2008 ---
Created an attachment (id=52051)
test document


-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-12 Thread dr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971





--- Additional comments from [EMAIL PROTECTED] Wed Mar 12 10:16:33 + 
2008 ---
Excel's behaviour is as follows (as far as I can see the system here...):

** Definitions:
- Category = one label on the X axis, refering to a data point in a series.
- Level = single row of category labels. May be stacked downwards. Level 1 is
nearest to X axis, level N is outermost.
- Category source = cell range(s) in spreadsheet used for category labels.
- Series source = cell range(s) in spreadsheet used for data point values of a
series.

If the category source is 1-dimensional (means: contains one single row or one
single column of cells), the cell values are applied category by category to the
X axis, regardless of the orientation of the series source.

If the category source is complex (means: 2-dimensional, or a list of cell
ranges, even if this list forms a single row or column!), it is used depending
on the orientation of the series source of the first series shown on the first
axes set (or second axes set in case of the secondary X axis).
- If the series source is horizontal (means: it contains at least one cell range
with more than 1 column), the category source is divided into single columns.
Each column represents one category on the X axis.
- If the series source is vertical (means: it contains only single-column cell
ranges and/or single cells), the category source is divided into single rows.
Each row represents one category on the X axis.

In case the category source is a range list, it is processed range by range from
the beginning, and row by row or column by column for each range. The number of
levels N on the X axis is the count of the largest row/column of the category
source.

For each category: Use the cells of the single rows/columns of the category
source from last cell (right/bottom) to first cell (left/top), and set the
category labels starting from level 1 (nearest X axis) toward level N, as long
as there are cells left. If there are less than N cells, the outer levels remain
empty.

Inside of one cell range of the category source, empty cells are used to merge
several categories in a level together. The merged range starts with a non-empty
label in the current level, and ends before the next non-empty label in the
current level or an higher level. The label is centered in the category range.
- Categories are NOT merged in level 1.
- Categories are NOT merged over different cell ranges in the category source,
even if the cells of the first row/column of the next range are empty.

Excel test document will be attached...


-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-12 Thread dr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971





--- Additional comments from [EMAIL PROTECTED] Wed Mar 12 10:34:21 + 
2008 ---
Note that Excel 2007 has changed its behaviour in this area. The description
above is for Excel 2003. If the attached document is loaded in Excel 2007, the
charts in the second and third sheet will not show all X axis labels, or will
show completely different labels...

-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-12 Thread dr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971





--- Additional comments from [EMAIL PROTECTED] Wed Mar 12 11:01:02 + 
2008 ---
More updates about Excel 2007:

- Font spacing for axis labels has been changed, there is more space between the
levels now. That is the reason that the last level is missing in some charts on
the second sheet of the test document.

- Excel does NOT consider the orientation of the series source anymore. If the
category source is complex, it is ALWAYS processed horizontally, means column by
column. Therefore, in the text document, second and third sheet, the charts in
the right column are equal to the charts in the left column.

-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-12 Thread dr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971





--- Additional comments from [EMAIL PROTECTED] Wed Mar 12 11:07:23 + 
2008 ---
- Excel 2007 merges the category labels over different source ranges, if they
contain empty cells or if some columns are shorter than others.

-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-12 Thread dr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971





--- Additional comments from [EMAIL PROTECTED] Wed Mar 12 12:02:53 + 
2008 ---
Ok, again, complete specification for Excel 2007. Different behaviour to Excel
2003 is marked with (**).

If the category source is 1-dimensional (means: contains one single row or one
single column cells), the cell values are applied category by category to the X
axis, regardless of the orientation of the series source.

If the category source is complex (means: 2-dimensional, or a list of cell
ranges, even if this list forms a single row or column!), the category source is
divided into single columns (**). Each column represents one category on the X 
axis.

In case the category source is a range list, it is processed range by range from
the beginning, and column by column for each range. The number of levels N on
the X axis is the height of the largest column of the category source.

For each category: Use the cells of the single columns of the category source
from bottom cell to top cell, and set the category labels starting from level 1
(nearest X axis) toward level N, as long as there are cells left. If there are
less than N cells, the outer levels remain empty.

Empty cells are used to merge several categories in a level together. The merged
range starts with a non-empty label in the current level, and ends before the
next non-empty label in the current level or an higher level. The label is
centered in the category range.
- Categories are NOT merged in level 1.
- Categories ARE merged over different cell ranges in the category source (**).
even if the cells of the first row/column of the next range are empty.
- Categories are NOT merged in the free area, if there is not enough data to
fill all categories on the X axis (**).

If a level is completely empty, it will be skipped. The X axis will not show an
empty line beteeen other levels.

New test document will be attached...

I prefer the new behaviour, as it is not that complicated.

-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-12 Thread dr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971





--- Additional comments from [EMAIL PROTECTED] Wed Mar 12 12:04:19 + 
2008 ---
Created an attachment (id=52052)
New test document showing differences between Excel 2003 and 2007


-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-12 Thread dr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971


User dr changed the following:

What|Old value |New value

 Assigned to|dr|iha

  Issue type|DEFECT|ENHANCEMENT





--- Additional comments from [EMAIL PROTECTED] Wed Mar 12 12:41:31 + 
2008 ---
DR-IHA: Filter does work correctly, chart implementation needs to be fixed.

-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-12 Thread kohei
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971





--- Additional comments from [EMAIL PROTECTED] Wed Mar 12 13:43:19 + 
2008 ---
@dr: wow.  You're very thorough, as always. :-)

-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-11 Thread iha
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971


User iha changed the following:

What|Old value |New value

  CC|'kpalagin'|'iha,kpalagin'





-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-11 Thread kohei
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971


User kohei changed the following:

What|Old value |New value

  CC|'iha,kpalagin'|'iha,kohei,kpalagin'





-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-03-11 Thread kohei
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971





--- Additional comments from [EMAIL PROTECTED] Tue Mar 11 16:33:35 + 
2008 ---
I've been looking into this.  The reason for this bug is because Calc provides a
structured (i.e. 2-dimensional) category label data to chart2 but chart2 renders
the label serially.  So, we would need to add a way to pass a structured label
data from sc to chart2, and add support for rendering multi-layer category
labels in chart2's view code.

-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2008-01-18 Thread kpalagin
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971


User kpalagin changed the following:

What|Old value |New value

  CC|''|'kpalagin'

  Ever confirmed|  |1

  Status|UNCONFIRMED   |NEW





--- Additional comments from [EMAIL PROTECTED] Fri Jan 18 14:48:31 + 
2008 ---
Confirming using m241 on WinXP - as described.

-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2007-11-26 Thread kla
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971


User kla changed the following:

What|Old value |New value

 Assigned to|kla   |dr

Priority|P2|P3

Target milestone|---   |OOo 3.0





--- Additional comments from [EMAIL PROTECTED] Mon Nov 26 09:14:10 + 
2007 ---
@DR: Pls have a look.

-
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]



[graphics-issues] [Issue 82971] Charts in .doc imports mis sing x-axis legends

2007-10-26 Thread fst
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82971


User fst changed the following:

What|Old value |New value

 Assigned to|spreadsheet   |kla

   Component|Spreadsheet   |Chart

  QA contact|[EMAIL PROTECTED] |[EMAIL PROTECTED]





--- Additional comments from [EMAIL PROTECTED] Fri Oct 26 08:11:13 + 
2007 ---
wrong component, changed to chart and re-assigned

-
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]