Bug 126120 - oRange.fillSeries() does not fill hidden cells
Summary: oRange.fillSeries() does not fill hidden cells
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-26 18:21 UTC by Oliver Brinzing
Modified: 2019-10-07 15:53 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
fillseries_demo.ods (10.75 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-06-26 18:21 UTC, Oliver Brinzing
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver Brinzing 2019-06-26 18:21:03 UTC
Created attachment 152430 [details]
fillseries_demo.ods

according to:
https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XCellSeries.html#af47df42b4c0b162cc4be76516a9a5345

oRange.fillSeries() provides methods to fill out a cell range automatically with values based on a start value, step count and fill mode. 

with AOO 4.1.5 all cells in the range are filled, but with LO 3.6.7.2 hidden cells are not filled. 

steps to reproduce:
- open attached spreadsheet
- press [fill series]
-> cell E4 is empty

- open attached spreadsheet
- show column E
- press [fill series]
-> cell E4 is filled

was this change intended?
Comment 1 dragontattoo987 2019-07-27 07:05:14 UTC Comment hidden (obsolete)
Comment 2 raal 2019-08-02 15:34:16 UTC
Confirm with Version: 6.4.0.0.alpha0+ (x64)
Build ID: bebc2280e43fc381e9085f2a397dad9dd7701fdd
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 

Not sure if it's a bug or not, leaving unconfirmed
Comment 3 Xisco Faulí 2019-09-03 08:17:57 UTC
(In reply to raal from comment #2)
> Confirm with Version: 6.4.0.0.alpha0+ (x64)
> Build ID: bebc2280e43fc381e9085f2a397dad9dd7701fdd
> CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
> 
> Not sure if it's a bug or not, leaving unconfirmed

I believe this is an issue.
@Eike, any opinion ?
Comment 4 Eike Rathke 2019-09-03 12:14:25 UTC
It's the same behaviour as when filling the series manually using menu Sheet -> Fill Cells -> Fill Series...; and that change was intended. IMHO the API should act the same and this is not a bug.
Comment 5 Xisco Faulí 2019-09-03 13:14:21 UTC
(In reply to Eike Rathke from comment #4)
> It's the same behaviour as when filling the series manually using menu Sheet
> -> Fill Cells -> Fill Series...; and that change was intended. IMHO the API
> should act the same and this is not a bug.

Hello Eike,
Thanks for your comment, it makes sense the API acts the same way...
Closing as RESOLVED NOTABUG
Comment 6 dragontattoo987 2019-10-07 15:53:31 UTC
Thanks for this information. It useful