|Summary:||Not all text displayed in the legend of a chart|
|Product:||[Applications] calligrasheets||Reporter:||swathi <swathi.vegesna999>|
|Component:||filter/xls||Assignee:||Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>|
|Latest Commit:||Version Fixed In:|
Screenshot in MS Office
Screenshot in Calligra Tables
Screenshot in Latest Calligra Tables
Description swathi 2011-11-24 10:06:54 UTC
Comment 1 swathi 2011-11-24 10:07:43 UTC
Created attachment 66032 [details] Screenshot in MS Office
Comment 2 swathi 2011-11-24 10:08:37 UTC
Created attachment 66033 [details] Screenshot in Calligra Tables
Comment 3 Sebastian Sauer 2011-11-25 14:34:56 UTC
Fixed with 12ba15d6746d.
Comment 4 swathi 2011-12-01 08:06:00 UTC
Tested with 5992551fa6b6bf4e2d716728e086fd48ff905e33, No extra space is introduced but The entire text in the legend is not displaying. Ex:If the original file has "Hospitals Endoscopy" in Calligra Tables only "Endoscopy" is displaying in the legend. So reopening the bug.
Comment 5 swathi 2011-12-01 08:06:45 UTC
Created attachment 66246 [details] Screenshot in Latest Calligra Tables
Comment 6 Sebastian Sauer 2011-12-01 11:22:39 UTC
Cannot reproduce. Even your screenshots shows that Calligra Tables displays "Hospitals Endoscopy" in the legend (two words!) and not only "Endoscopy".
Comment 7 Sebastian Sauer 2011-12-01 14:26:45 UTC
Ah, here is the case; Excel displays the legend items; * Hospitals Sigmoidoscopy * Hospitals Colonoscopy * Hospitals Endoscopy * Hospitals Carotid While OpenOffice.org/LibreOffice Calc and Calligra Tables display * Hospitals Sigmoidoscopy * Colonoscopy * Endoscopy * Carotid The defined series are; * C6:C7 * D6:D7 * E6:E7 * E6:E7 At C6 is the "Hospitals" string. So, somehow the logic excel applies here to put together the string that is displayed for a legend item is; 1. Loop at given cell range (e.g. D6:D7) from bottom-up 2. If at the given rows above is no content then go in the same row above us to the left till column A *xor* content is reached. If content is found add that to the resulting label. 3. Reset to our column and move one row up and continue at 2. There opens quit a lot questions. * We cannot do that in ODF to be compatible with OO.org/LO which does it like us atm. * We could introduce the boolean flag MsOfficeLikeLegendLabelRange into the settings.xml. If TRUE then we do what Excel does. If FALSE we do it in the Openoffice/LibreOffice way. * Best way would be to figure out a solution to handle all that direct in the Excel 2000/2003/2007 filters and only there. For example by allowing custom string labels per legend-item stored in the internal data cache (aka "local-table" in the Chart1/content.xml). Afaik that is not supported by ODF and in any case it's not by the plugin-shape either. All in all not an easy task.
Comment 8 Sebastian Sauer 2011-12-06 01:53:15 UTC
Changed summary from "Extra space is introduced between the symbols and words in the legend of the bar chart" (which was fixed) to "Not all text displayed in the legend of a chart" (what is the remaining issue described at comment #7 ).
Comment 9 Justin Zobel 2021-03-09 22:43:42 UTC
Thank you for the bug report. As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists. If this bug is no longer persisting or relevant please change the status to resolved.