Summary: | CALC: Support custom data series in chart with labels and their values placed on two or more lines or columns | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | rainer <carnendil> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED NOTABUG | ||
Severity: | normal | CC: | carnendil, libreoffice-ux-advise, raal |
Priority: | medium | Keywords: | needsUXEval |
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108539, 108542 | ||
Attachments: |
Example screenshot
example file |
Description
rainer
2018-01-07 21:30:28 UTC
Created attachment 138946 [details]
example file
Repro 6.2+ as reported. Can you please explain how you created it to get data range: $Hoja1.$A$2:$C$3;$Hoja1.$A$4:$C$5;$Hoja1.$A$1 I'd says IMHO this is not "normal" bug in terms of wrong behavior because Calc doesn't support table prepared like that. Basic options for "Data series" are "in rows" and "in columns". What you ask for is an enhancement to get custom data series. I change the title. Should it be accepted is a question. My personal stance is no. I don't know whether UX or Dev should review this one. The example originally attached was created only to show the noted behaviour. As you say, LO seems to be restricted to "basic" (single) rows and columns. Having to plot data sets that "wrap" over more than one row or column is maybe not as exotic, though. I remember having done so on MS Excel over 20 years ago (for my grad thesis). I have seen many other instances (e.g., accounting or budgeting) in which a data set may be separated in several tables (different sheets or not, depending on the user/company presentation/printing needs), but plots needed both for individual table data and for the whole lot. It wouldn't make sense to duplicate and re-arrange the data only for one plot. I do not have one of those with me now but I'll try to get my hands on a real-life example to see if I can share it. Please describe shortly how you create the chart; I guess per manipulation of the data range (y-values = $Hoja2.$B$2:$B$4,$Hoja2.$D$2:$D$4). No feedback, so let's take Timur's opinion and resolve as NAB. Workaround for this particular case is to add a dummy cell. For example $Hoja1.$A$2;$Hoja1.$B$2;$Hoja1.$C$2;$Hoja1.$A$4;$Hoja1.$B$4;$Hoja1.$C$4;$Hoja1.$C$5 |