Apache OpenOffice (AOO) Bugzilla – Issue 37917
Hebrew chart legend unreadble on import from excel
Last modified: 2013-02-24 21:20:21 UTC
in the attached excel file, in the 2nd sheet, there is a chart. The chart has a text legend in Hebrew. The text in the legend is too small, some of it cut off and it is missing spaces, making the it unreadble.
Created attachment 19705 [details] excel file
Created attachment 19706 [details] screenshot- notice that the text in the chart is unreadlbe
Another example can be seen in the next attachment- there isn't enough space between characters in each word in the chart legend, making the text unreadble (or very hard to read).
Created attachment 19708 [details] 2nd example
wrong component I've changed it Frank
Hi Daniel, pls have a look. Maybe Iha will take care of it, Issue 28670 matched partly.
Book1.xls contains a chart that declares 2 cells for each category name. This needs to be implemented in the new chart engine first. meri.xls (2nd example) imported correctly in OOo 1.9.91.
dr->bm: category range is correctly imported now, but chart legend only shows the texts from column A.
title
Multiple cells in labels are usually shown as "<Cellcontent1> <Cellcontent2> <...>" in the legend. Have to chek what the problem is here.
Ok, I was too fast. The labels of data series are merged if they consist of more than one cell. However, the categories are not. And this is a general problem, because the chart knows the categories just as one sequence of strings without any structural information. So, the Calc could prepare this sequence by merging cells together. However, this is not possible, because Calc gets a range e.g. "A1:B5" and has no further information how this should be split up into categories. Is one row one category or one column, or are these ten categories each one cell, leaving the question if the cells are interpreted column by column or row by row. So, I don't know how to fix this with the underlying structure. ->DR: How does excel know that two adjacent cells become one category? Is this only possible if you have a rectangular region (where you know that data comes from rows or columns)? setting target back, as this cannot be fixed for the initial version of the chart reimplementation.
adjusted type and target This issue is related to issue 82971.
change owner
reset to new
Rechecking issue... I have implemented Category names from multiple cells in CWS chartmultiline (see issue 97893 and 82971). Checking this issue now I find that it is not really about this feature, but about wrong font rendering instead. So I restore the original summary 'Hebrew chart legend unreadble on import from excel'. When opening the given examples in ooo320m12 I cannot see the problem with the font rendering anymore. It seems to be fixed in the meanwhile. -> set to works for me.
worksforme -> closed