https://bugs.freedesktop.org/show_bug.cgi?id=83779
Priority: medium
Bug ID: 83779
Assignee: [email protected]
Summary: FILESAVE: Error in saving as Excel files - ISNUMBER
function
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Steps to reproduce:
1. Create a file with a functioning algorithm that includes IF(ISNUMBER(XX)=0
( I note that LO calc will convert the word "FALSE" to 0 whether you type it in
or it comes from an Excel file)
2.Save the file as an Excel file (.xls, .xlsx etc)
3.Open the file in Excel (I tried it in Excel 2010, and 2007)
Current behavior:
LO calc doesn't convert the 0 in IF(ISNUMBER(XX)=0 to "FALSE", and then Excel
sees the 0 in IF(ISNUMBER(XX)=0 as the number 0. All subsequent dependent
algorithms are then in error (if cell (xx) isn't the number 0.
Expected behavior:
LO calc should convert the 0 to "FALSE". Similarly, if the algoritm were
IF(ISNUMBER(XX)=1, it should convert the 1 to "TRUE" (but, I am not sure why
one would ever need to do the latter)
Operating System: Windows 7
Version: 4.2.5.2 release
--
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
