| Summary: | chart multiplicator for selected sheets with actualization in the selected sheets | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | paulystefan |
| Component: | Chart | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WONTFIX | ||
| Severity: | enhancement | CC: | libreoffice-ux-advise |
| Priority: | medium | Keywords: | needsUXEval |
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 108538 | ||
| Attachments: | file with many sheets without possible same charts | ||
I think you use the wrong tool for automated chart generation. R is pretty nice, IMHO. If you really want to repeat the same operation on different sheets/documents it's better to create an extension. What comes in mind too is to strip off the absolute part from the chart range (and to copy/paste). But neither A1:A3 nor $A$1:$A$3 is not accepted for $Sheet1.$A$1:$A$3. Likely because Chart is a standalone module that cannot dynamically load data from Calc. So what you can do is to have one sheet with the chart and you paste the data from other sources into this sheet. My take: chart serialization is a WF. |
Created attachment 168577 [details] file with many sheets without possible same charts There should be a function or tool to duplicate charts into equal sheets with other data. I see here a chart manager with one or more source charts of a source sheet. The user chooses the sheets for copy and then the manager does it. So the charts have the same basic vision with the different data and curves on the sheets. At the moment a user must all do it by hand. The copy of sheets with charts is actually buggy. Copy the charts and change the sheet names in the sources of the chart is not a pleasure in year 2020 after 40 years of IT with tables and sheets.