https://bugs.freedesktop.org/show_bug.cgi?id=83243
Priority: medium
Bug ID: 83243
Assignee: [email protected]
Summary: FORMATTING: can not recognize cell format
automatically. Worse and worse. : ( I´m thinking back
to MS office.
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.3.1.1 rc
Component: Spreadsheet
Product: LibreOffice
Problem description: cells with functions can not be calculated correctly.
Cell A1:=LEFT(Z12;2)................................value is 03
Cell B1:=VLOOKUP(RIGHT(Z12;3);$AG$12:$AH$23;2;).....value is 01
so,in Cell C1:=IF(B1<A1;"yes";"no")
Then, in cell C1 shows "no". it shoud be "yes".
I´m crying now, my god. We are forced to use MS office????
Operating System: Windows 8
Version: 4.3.1.1 rc
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
