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