Bug 138399 - Calc missing the ability to use a formula to specify a data range for a chart
Summary: Calc missing the ability to use a formula to specify a data range for a chart
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-21 23:06 UTC by Jay
Modified: 2021-07-29 12:18 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jay 2020-11-21 23:06:04 UTC 
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
Comment 1 Buovjaga 2021-07-29 12:18:23 UTC 
Seems useful -> NEW