[Libreoffice-bugs] [Bug 138399] New: Calc missing the ability to use a formula to specify a data range for a chart

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Nov 21 23:06:04 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=138399

            Bug ID: 138399
           Summary: Calc missing the ability to use a formula to specify a
                    data range for a chart
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: b-jc at outlook.com

Description:
Excel allows a formula to be used in the specification of a range in a chart. I
would like to suggest that this capability be added to Calc.
For example a formula such as IF(ISLEAPYEAR(),C4:C32,C4:C31) in the range
specification of a chart would be very useful for creating a chart that would
work for both leap years and standard years by showing only the appropriate
number of days in a chart of data for each day of the month of February.

The version that I am currently running is Version: 6.4.7.2 (x64), but I first
noticed the lack of this capability in version 6.2.8.2 however I am certain
that it is a condition inherited from OOo.

Steps to Reproduce:
This is an enhancement request, there are no steps to reproduce it.

Actual Results:
This is an enhancement request, there are no actual results.

Expected Results:
This is an enhancement request, there are no expected results.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 4; OS: Windows 10.0 Build 19041.630; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201121/2b9a3e18/attachment.htm>


More information about the Libreoffice-bugs mailing list