Apache OpenOffice (AOO) Bugzilla – Issue 58790
Excel spreadsheet data sets not working
Last modified: 2013-02-24 21:21:11 UTC
I was recently sent the spreadsheet that I'll attach. My default spreadsheet is Calc and when it loaded I initially didn't see anything wrong. I thought it a bit strange but just considered it "work in progress". When my boss asked waht I thought of the idea of plotting skills visually by altering the table in the second sheet I had to ask to see his version. What I saw was a yellow rectangle with a bunch of coloured triangles. These triangles could be moved by changing the numerical data in the table on the "Data" sheet / tab. In OOo the triangles were all black and all lined up along the left axis. Changing the table data would not move the triangles. Anyway, probably best to look at the attachment in both Excel and Calc and see for yourselves.
Created attachment 31986 [details] Data set problem
seems to be something for the Chart component
duplicate *** This issue has been marked as a duplicate of 3997 ***
closed as duplicate
Oh dear ! I shan't hold my breath then !! :-)