https://bugs.documentfoundation.org/show_bug.cgi?id=166771
Bug ID: 166771
Summary: Call not working correctly following crash between
midnight and 2 a.m.
Product: LibreOffice
Version: 7.2.4.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
e.g.: =if($G150=H$3,$F150,0) doesn’t work now.
Also:
=IF(ISBLANK(C151),””,IF(AND(MONTH(C151)>0,MONTH(C151)<4),1,IF(AND(MONTH(C151)>3,MONTH(C151)<7),2,IF(AND(MONTH(C151)>6,MONTH((C(151)<10),3,IF(AND(MONTH(C151)>9,MONTH(C151)<13),4)))))
fails too give correct results.
Actual Results:
Enter word in cell H$3. Enter same word in cell G$150. If the words match, cell
H150 should equal the value of cell F150.
Expected Results:
Prior to crash, worked as expected.
After the crash, yields unexpected results.
In second example, enter date in cell c151 and should see either 1,2 3or 4
corresponding to quarter of year in cell d151.
Reproducible: Always
User Profile Reset: No
Additional Info:
As explained above.
--
You are receiving this mail because:
You are the assignee for the bug.
