https://bugs.documentfoundation.org/show_bug.cgi?id=104400
Bug ID: 104400
Summary: File has a Day() function that works incorrectly in
Calc yet correctly in Excel
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jptem...@yahoo.com
Description:
I created a spreadsheet to use as a calendar. On row 67 I changed from typing
in every date to using =DAY($A67), where the first day of the week was in
column A, the rest of the week was thus done by addition, DAY($A67+1) and so
on.
That first day is wrong in my file. If I create a new file it works correctly,
so there must be a file error that is not detected. This is an issue because
it works in excel yet gives the wrong information in Calc.
Steps to Reproduce:
1. Load file
2. Go cell where error day is wrong
3. clear cell. Type in =day(<cell>) and see error reproduced.
4. If you go to a new cell then day appears to work, but copying a nonworking
cell and pasting somehow corrupts that newly pasted cell so that Day()
subtracts 1.
Actual Results:
reported Day is off by 1. This happens on different computers running
Libreoffice.
Expected Results:
reported day should match the date.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/54.0.2840.99 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
