Bug 69726 - FILEOPEN: Errors when opening Excel File with Text Formatting
Summary: FILEOPEN: Errors when opening Excel File with Text Formatting
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.1.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: regression
Depends on:
Blocks:
 
Reported: 2013-09-23 17:45 UTC by Peter Jones
Modified: 2014-04-26 00:06 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Attachments
Excel file for testing from Excel 2007 (9.00 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-09-23 17:45 UTC, Peter Jones 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Jones 2013-09-23 17:45:23 UTC 
Created attachment 86401 [details]
Excel file for testing from Excel 2007

Problem description: 

If I format a cell in Excel (Windows any version) as text, then enter in the cell any number of equal signs for example

=====

Then save an Excel file 2003/2007/2010 formats then open in it up Calc the cell just says Err:510. I thought Libre Office was supposed to open Excel files?

If I try and save the file I get 'This document my contain formatting which cannot be saved in Excel Format.

Steps to reproduce:

Open Excel File attached in LibreOffice
Error Appears

Current behavior: Cell contents are Err:510

Expected behavior: Cell should display contents correctly

              
Operating System: Windows 7
Version: 4.1.1.2 release
Comment 1 Peter Jones 2013-09-23 17:48:57 UTC 
Just to note this seems to work fine on the latest Apache OpenOffice.  Thanks
Comment 2 Julien Nabet 2013-09-23 19:18:36 UTC 
On pc Debian x86-64 with master sources updated today (+ brand new LO profile), I reproduced the problem.

During opening, i noticed these logs:
warn:legacy.osl:14995:1:sc/source/core/data/document.cxx:4797: SelectionPattern Null
warn:i18nlangtag:14995:1:i18nlangtag/source/languagetag/languagetag.cxx:1302: LanguageTagImpl::convertLocaleToLang: with bAllowOnTheFlyID invalid 'hu-HU-u8'
warn:legacy.tools:14995:1:editeng/source/editeng/editdoc.cxx:1758: WrongList already exist!

However, if I edit the cell, add, then remove an equal, it's ok.
Moreover, no problem to save the initial file to xls format.

Kohei/Markus/Eike: one for you?

(Kohei: the address which is https://wiki.documentfoundation.org/FindTheExpert is KO. Since Bugzilla proposed 2 addresses, I used both but don't hesitate to put the one you prefer in FindTheExpert page.)
Comment 3 Kohei Yoshida 2014-04-26 00:06:32 UTC 
Tested using both the latest from 4.1 and 4.2 branches and the text cell imports correctly.