https://bugs.documentfoundation.org/show_bug.cgi?id=148383
Bug ID: 148383
Summary: UI: Fill Series dialog does not respect the number
format of the source cell
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When launching the "Fill Series" dialog, the "Start value" text box is
pre-filled with the appropriate start value for the given selected range.
However, using this value is not possible at least when using a
non-locale-default date format, and results in an error.
Steps to Reproduce:
1. Create a cell with a date and change its formatting to something that's not
your locale-default and uses, for example, dots instead of slashes.
2. Make a range with this cell and launch the "Fill Series" dialog via Sheet ->
Fill Cells -> Fill Series...
3. Click "OK".
Actual Results:
An error message with the string "Invalid value".
Expected Results:
What happens when using the locale-default or ISO 8601 date format, i.e. the
window disappears and the selected range is filled according to the selected
settings.
Reproducible: Always
User Profile Reset: No
Additional Info:
The workaround I've been using is replacing the start value with its ISO 8601
equivalent. However, this should not be needed and the user is not hinted that
doing this will work, as the error message is not detailed enough.
Version: 7.3.2.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
7.3.2-1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
