https://bugs.documentfoundation.org/show_bug.cgi?id=105158
Bug ID: 105158
Summary: Copying a cell which uses TODAY() in formula
inappropriately creates Direct number format in copy
Product: LibreOffice
Version: 5.3.0.0.beta2
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If the TODAY() function is used in a cell formula, then if that cell is copied
the copy wrongly has its Number Format forced (with a Direct Format) to a Date
format. This is wrong because the formula may not yield a date, e.g. if it is
the difference between some date value and today, which yields as (possibly
negative) integer, not a date.
The bug seems to occur when the cell is copied into another sheet, but not if
it is copied into another cell of the same sheet.
STEPS TO REPRODUCE:
1. Open the attached demo spreadsheet (t.ods)
2. Select sheet "Sheet1". Cell A1 displays a negative number (the difference
in days between 2016-06-01 and today's date)
3. Right-click the sheet tab, Move or Copy sheet..., OK
RESULTS: The new sheet displays some date in 1999. Cell A1 has a Direct Format
forcing the Number format to a date format.
EXPECTED RESULTS: The new sheet should show the same negative value as the
original sheet. The format should be the same as in the original sheet, which
had a numeric Number format.
Steps to Reproduce:
see above
Actual Results:
see above
Expected Results:
see above
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101
Firefox/50.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
