GNOME Bugzilla – Bug 142412
XL concats vector of strings used as singleton strings
Last modified: 2010-05-05 18:35:45 UTC
Steps to reproduce the problem: - open the .gnumeric file I will attach => The label of the serie in the graph does not appear (only #value) - go to the chart properties - go to the serie properties - change the cell range for the serie label from B1:C1 to B1:B2 => now the label of the serie appear in the chart !
Created attachment 27640 [details] The .gnumeric file that shows the problem.
At issue is not horiz vs vertical Gnumeric is just reusing the evaluation semantics from the sheet and doing implicit intersection with cell A1. When you specify B1:B2 which is vertical it has a clean intersection with row 1 and uses B1. For B1:C1 there is no simple intersection and it returns #VALUE exactly as it would in the sheet. I'm not clear why you would want to do this, or what the expected behavior should be. Would you expect to just get the first item ?
I don't understand why we need to do the intersection with cell A1. In XL, when you specify a range of cells for a label, it concatenates the content of the cells. See for example the attached .xls file: try to open it in both XL and gnumeric.
Created attachment 28934 [details] The .xls file showing the problem.
Still there in 1.6.3.
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.