Bug 67252 - msoxl as text instead of calculated formular
Summary: msoxl as text instead of calculated formular
Status: RESOLVED DUPLICATE of bug 56209
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
(See in Summary)
Hardware: Other All
: highest critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-24 12:46 UTC by p_kongstad
Modified: 2013-08-20 07:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Test file created in Excel Starter 2010 (2.73 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-07-27 12:30 UTC, p_kongstad 		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 p_kongstad 2013-07-24 12:46:14 UTC 
A file generated in Excel 2010 is showing formular with 'msoxl:=C80*F80'.

Seems to be name space related.

Expected behavior:

Convert to formula and show the calculated value

Behavior:

Showing 'msoxl:=C80*F80'

Seems to be a regression.
Comment 1 Cor Nouws 2013-07-26 22:52:56 UTC 
Hi,

can you pls test this in 4.1.0 release?
Thanks,
Cor
Comment 2 p_kongstad 2013-07-27 12:30:15 UTC 
Created attachment 83087 [details]
Test file created in Excel Starter 2010

Hi, I have attached a file created in Excel Starter 2010 and saved as Open Document format. 

This has been tested against LibreOffice 64 bit version Linux and Windows 4.1.0.4 which is identical to the released version.

Also version 4.2.0.0.alpha0+
Build ID: 7857d772f7f82a33de506cd10e4298aa092bfe8f 
has been tested with the same result.

I find this as a highly critical bug.
Comment 3 p_kongstad 2013-07-27 12:36:45 UTC 
I haved raised this to highest level as any editing of the file using LibreOffice destroys the file when saved.
Comment 4 p_kongstad 2013-07-29 15:00:50 UTC 
Can also add that version 4.0.4.2 also have this bug.

Tested on Windows.
Comment 5 Cor Nouws 2013-07-30 21:28:09 UTC 
Hi,

Can others pls confirm this behaviour?
thanks!
Cor
Comment 6 Maxim Monastirsky 2013-07-31 06:54:08 UTC 

*** This bug has been marked as a duplicate of bug 56209 ***
Comment 7 ecoromka 2013-08-20 07:27:29 UTC 
Have this bug on 4.1.0.4 Windows, on test file.

Also it comes along with wrong interpretation of decimal separator in formula: dot  is read, and produces an error as locale specific is comma.