Summary: | Use a Named range as data source for Chart | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Pedro <pedlino> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | enhancement | ||
Priority: | medium | CC: | suokunlong |
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://issues.apache.org/ooo/show_bug.cgi?id=64604 | ||
Whiteboard: | |||
i915 platform: | i915 features: |
Description
Pedro
2013-06-27 10:28:47 UTC
Added related Apache OO issue to See Also list. Version set to Inherited from OOo. A workaround is to select an additional empty row (above and below) for the Data Range and ensure this option is selected: Tools > Options > LibreOffice Calc > General > Input Setting > Expand references when new columns/rows are inserted Inserting a new row beneath the last row will then automatically update the chart as expected. Same effect if inserting a new row prior to first row of data. (In reply to comment #2) > Inserting a new row beneath the last row will then automatically update the > chart as expected. Same effect if inserting a new row prior to first row of > data. Thanks. I already do that. But I hope that someone actually adds this feature. It doesn't make sense that you can use Named ranges for some features but not for others. It's inconsistent and unintuitive ;) |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.