Bug 139776 - FILEOPEN - item added when opening an Excel 2003 spreadsheet
Summary: FILEOPEN - item added when opening an Excel 2003 spreadsheet
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.5.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-20 03:55 UTC by Leo
Modified: 2021-08-23 03:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
it is an Excel invoice spreadsheet showing the bug (21.00 KB, application/x-ole-storage)
2021-01-23 06:28 UTC, Leo
Details
How is seen with Excel-365 (8.71 KB, image/png)
2021-01-23 23:14 UTC, m_a_riosv
Details
How is seen with Excel-365, when selecting the text box to the right. (17.16 KB, image/png)
2021-01-23 23:20 UTC, m_a_riosv
Details
Original file without the text box to the right. (36.00 KB, application/vnd.ms-excel)
2021-01-23 23:23 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Leo 2021-01-20 03:55:23 UTC
Description:
I just started using LibreOffice. I initially started with version 5.4 when I found this bug. I then updated to version 6.4, but the bug is still there. 

I opened a simple Excel 2003 spreadsheet into LibreCalc. I have a line of centered text that spans 3 combined cells. After opening, for some reason, that line of text is duplicated vertically on the spreadsheet. That vertical text is not in a cell so I don't know what it is. 

Steps to Reproduce:
1.I opened the spreadsheet and a duplicated piece of vertical text appears.
2.
3.

Actual Results:
The duplicated vertical text appears.

Expected Results:
Opening the file without that duplicated piece of vertical text appearing.


Reproducible: Always


User Profile Reset: No



Additional Info:
I can send the Excel spreadsheet if it helps. I stripped out all the personal information so it is not a problem.
Comment 1 m_a_riosv 2021-01-22 09:06:06 UTC
Please attach a sample file, it's the only way to test.
Comment 2 Leo 2021-01-23 06:28:43 UTC
Created attachment 169101 [details]
it is an Excel invoice spreadsheet showing the bug
Comment 3 m_a_riosv 2021-01-23 23:14:20 UTC
Created attachment 169116 [details]
How is seen with Excel-365

How the file is seen with excel-365
Comment 4 m_a_riosv 2021-01-23 23:20:29 UTC
Created attachment 169117 [details]
How is seen with Excel-365, when selecting the text box to the right.

How is seen with Excel-365, when selecting the text box to the right.

So it has nothing to do with merged cells. And not sure if it is LibreOffice or Excel open it fine.

BTW take care of such a corner case on a very old format, I'm not sure if it's cost-effective.
Comment 5 m_a_riosv 2021-01-23 23:23:01 UTC
Created attachment 169118 [details]
Original file without the text box to the right.

File edited with excel-365 to delete the text-box to the right.
Comment 6 QA Administrators 2021-07-23 03:37:41 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2021-08-23 03:52:19 UTC
Dear Leo,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp