[Libreoffice-bugs] [Bug 136004] New: Fill series of type date has incorrect series increment calculation/format

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 136004
           Summary: Fill series of type date has incorrect series
                    increment calculation/format
           Product: LibreOffice
           Version: 7.0.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: yetoohappy at gmail.com

Created attachment 164546
  --> https://bugs.documentfoundation.org/attachment.cgi?id=164546&action=edit
Shows the incorrectly calculated series output for the date input start
(8/17/2020) and end (8/23/2020) values

Description: title

Steps to reproduce:
1. Select 7 rows (can be any amount of rows but 7 for the purposes of this
reproduction) in a column
2. Open the fill series dialog via Sheet->Fill Cells->Fill Series...
3. Set the Series Type to Date and set the Time Unit to Day 
4. Set the start value as 8/17/2020 and the end value as 8/23/2020 and keep the
increment as 1
5. Press ok

Expected behavior:
A series of values will be incremented starting from 8/17/2020 and ending at
8/23/2020.

Actual behavior:
A series of values will be incremented starting from 44060 and ending at 44066.

This is annoying as I specified dates to be incremented instead of some number.

Reproducible: Always

User Profile Reset: No*

*I tested this with 6.4.6 on Linux and 7.0.0.3 Windows 10, and the same
behavior persists on both.

Notes:
If the first cell selected before getting into the fill series dialog has a
date (such as 8/17/2020) and then set the time unit to day (as it automatically
gets set to month) and dialog is filled out the same as the reproduction steps,
then the date series will be properly formatted and incremented.

The attached file attempts to increment the date series with each of the series
types with similar results. I'm not necessarily concerned with the columns
other than Date, but I thought it would be useful to show what other types may
increment similar output in the event that they aren't supposed to increment
that output.

Version information (for the Windows 10 install):
Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 2; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: 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/20200822/bdf4ccf7/attachment.htm>