Bug 122213 - MS Excel file with Formula not working in LibreOffice
Summary: MS Excel file with Formula not working in LibreOffice
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-12-20 03:50 UTC by Md. Touhiduzzaman
Modified: 2018-12-24 15:05 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
The sample file of bug report 122213 (341.01 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-12-20 10:21 UTC, Md. Touhiduzzaman
Details
Named range dialog (33.56 KB, image/png)
2018-12-20 14:02 UTC, GerardF
Details
Sample compared MSO LO 6.3+ (145.91 KB, image/jpeg)
2018-12-20 14:23 UTC, Timur
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Md. Touhiduzzaman 2018-12-20 03:50:55 UTC
Description:
I got a MS Excel file with lots of formula in multiple sheets. I can see all results in Summery sheet using MS Excel but it does not work in Libreoffice. It shows Err:508

Steps to Reproduce:
1. Tried with Resetting User Profile
2. Tried by enabling OpenGL

Actual Results:
1. No change found
2. No change found

Expected Results:
Expecting to work the formula's after enabling OpenGL but it does not.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Comment 1 Xavier Van Wijmeersch 2018-12-20 07:56:41 UTC Comment hidden (obsolete)
Comment 2 raal 2018-12-20 08:04:17 UTC Comment hidden (obsolete)
Comment 3 Md. Touhiduzzaman 2018-12-20 09:37:44 UTC
(In reply to Xavier Van Wijmeersch from comment #1)
> 508 ==> Error: Pair missing | Missing bracket, for example, closing
> brackets, but no opening brackets
> 
> Try to find the first sheet where these missing pairs are, then if your luck
> in the other sheets there will be no problem
> 
> Best regards


Checked, No missing sign of brackets.
Comment 4 Md. Touhiduzzaman 2018-12-20 10:21:02 UTC
Created attachment 147689 [details]
The sample file of bug report 122213

Please note that, this file looks OK in Google Spreadsheet and MS Excel
Comment 5 GerardF 2018-12-20 14:02:29 UTC
Created attachment 147710 [details]
Named range dialog

I have many #NAME? errors with Office 365.
Comment 6 Timur 2018-12-20 14:23:06 UTC
Created attachment 147713 [details]
Sample compared MSO LO 6.3+

Sample file is not valid. I didn't bother checking why.
Comment 7 Md. Touhiduzzaman 2018-12-23 04:40:47 UTC Comment hidden (obsolete)
Comment 8 raal 2018-12-23 07:03:45 UTC
(In reply to Md. Touhiduzzaman from comment #7)
> (In reply to Timur from comment #6)
> > Created attachment 147713 [details]
> > Sample compared MSO LO 6.3+
> > 
> > Sample file is not valid. I didn't bother checking why.
> 
> Not clear why you are saying file is  not valid. You cant open it or what?
> Please let me know I have to upload it again.

See the printscreen in comment 6 - on this printscreen you can see that excel can open file, but all results are errors #NAME?
Comment 9 Timur 2018-12-24 15:05:29 UTC
Please do not reopen. 
Bugzilla is not user support portal. 
Your file is not correct.