https://bugs.documentfoundation.org/show_bug.cgi?id=64086
--- Comment #6 from russell <[email protected]> ---
This bug is still present in Libreoffice:
- 5.3.0.3 (linux mint 17.3)
- 5.2.3.3 (opensuse leap 42.2)
Libreoffice Calc does not support named ranges in Charts.
Usage example: Amortization table
Defined named range:
Principal = OFFSET($Table.$B$11,0,0,COUNT($Table.$B$11:$B$40,">0"),1)
Use defined name in Chart Data Ranges... -> Data Series -> Y-Values:
=amortization_test.ods!Principal
A dynamic amortization table, which is used as input to a chart, shows
principal paid, interest paid, and balance amounts. The size (number of nonzero
rows) of the table varies depending on input (amount, rate, term).
As mentioned in the title, excel does support this.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
