https://bugs.documentfoundation.org/show_bug.cgi?id=90308
Bug ID: 90308
Summary: FORMATTING: dragging corner of cell with "TRUE"
results in wrong integer values in Excel
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: x86-64 (AMD64)
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: js54...@gmail.com
Created attachment 114428
--> https://bugs.documentfoundation.org/attachment.cgi?id=114428&action=edit
simple example of bug
If I type "TRUE" into a blank cell, press return, then drag the bottom right
corner of the cell down to copy the value to lower cells, there is no apparent
problem in Calc, but if you save the workbook as .xlsx and open it in Excel (or
read it via the xlrd package in python), then the lower cell is displayed as
"TRUE" but the value is "2". If you drag further down, you get 3, 4, 5, etc.
Obviously, the resulting cells should be boolean rather than integers.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
