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