Am 14.08.12 11:59, schrieb Clarence GUO: > Hi~ > I'm doing bug 120511. I'm going to change the default behavior of the > legend display when creating a chart, which needs your comments. > When MS Excel creates a chart, if the chart data range doesn't contain > strings which can be regarded as data series name, Excel will use > Series<Num> as the default series names. e.g., Series1, Series2... While in > AOO, the default names will be the column or row names. e.g., Column A, > Column B... > So some Excel users will complain their XLS files will show different > legend labels of chart on AOO. > In order to satisfy these MS users and in order to not impact the > compatibilty of ODS files as well, I'm going to change the default data > series naming algorithm. the solution will be: > > - If the opened file is ODS format, the default data series names will be > Column<XXX> or Row<XXX> as before, no matter what format it is resaved > before close; > - If the opened file is XLS format, the default data series names will be > Series<Num>, no matter what format it is resaved before close; > > User Scenario 1: > Create a Spreadsheet file, create a chart, the default data series names on > legend will show Column A, Column B... > Resave the file to XLS, don't close it, create a chart again, the default > data series names on legend will also show Column A, Column B... (No matter > change the data series names of only chart 2 to Series 1, Series 2.. or > change both charts, will confuse users at this time) > Save again and reload the XLS, the default data series names of the two > charts are Series 1, Series 2... > > User Scenario 2: > Open a XLS file which has chart with default data series names on legend, > the default data series names of the charts will show Series 1, Series 2... > Create a new chart, the default data series names of the charts will also > show Series 1, Series 2... > Resave the file to ODS, don't close it, create a chart again, the default > data series names of the charts will still show Series 1, Series 2... > Save again and reload the ODS, the default data series names of the all > charts are Column A, Column B... > > Do you agree my proposal? Any comments and concerns please let me know. The problem you try to solve is the following scenario:
Sameone recive a XLS Document from a other person who has Excel. The Person who has Excel has allready a printout. The person with Apache OpenOffice recive the document, make also a printout, and this two documents shows different. I fear a bit, you don't solve problems at all: Think about the following User Scenario: - User make a new Table and create a Chart - User save it to ods - User make a Copy to OOXML or XLS too - User has, for whatever reason, only the XLS document, and open it on Apache OpenOffice - The Document looks different. I beleve, to make User realy happy this need a Checkbox But I'm not a Calc specialist at all, so wait for other comments please. Greetings Raphael
