Bug 139762 - Sum symbol on the spreadsheets damage the cells
Summary: Sum symbol on the spreadsheets damage the cells
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-19 12:43 UTC by Marco A.G.Pinto
Modified: 2021-12-29 11:56 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Cell damaged (105.58 KB, image/png)
2021-01-19 12:43 UTC, Marco A.G.Pinto 		Details
The ODS file (22.07 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-01-19 12:46 UTC, Marco A.G.Pinto 		Details
Video of bug happening (2.48 MB, video/x-ms-wmv)
2021-01-27 16:01 UTC, Marco A.G.Pinto 		Details
Screenshot of About window (80.00 KB, image/png)
2021-03-19 07:07 UTC, Marco A.G.Pinto 		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 Marco A.G.Pinto 2021-01-19 12:43:24 UTC 
Created attachment 169010 [details]
Cell damaged

<marcoagpinto> also, the sum symbol on the spreadsheets damage the cells
<marcoagpinto> "20 SUMSYMBOL 2K25-10"
<marcoagpinto> ";∑ 2K25=20"

(while editing a cell)
Comment 1 Marco A.G.Pinto 2021-01-19 12:46:04 UTC 
Created attachment 169012 [details]
The ODS file

Here is the file where it happens
Comment 2 mulla.tasanim 2021-01-27 15:31:12 UTC 
Thank you for reporting the bug. 
Unfortunately without clear steps to reproduce it, we cannot track down the origin of the problem. 
Please provide a clearer set of step-by-step instructions on how to reproduce the problem.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested information is provided.
Comment 3 Marco A.G.Pinto 2021-01-27 16:01:19 UTC 
Created attachment 169189 [details]
Video of bug happening

Hello!

I have found out how it happens.

It happens if it is the first file opened with LibreOffice.

Because on the next opened files, it doesn't happen any more.

But, if we reboot the computer and open it again as the first file, it happens.

Very strange, isn't it?

See attached video of it happening.

PS-> I uploaded the video in the wrong bug report moments ago because I didn't notice I had two e-mails from Bugzilla and just clicked in the link without rereading what was there. Sorry about that.
Comment 4 Marco A.G.Pinto 2021-02-02 12:37:21 UTC 
[12:31] <marcoagpinto> it still happens on 7.1.0.3
[12:31] <marcoagpinto> but I have narrowed it down to having the quickstarter enabled
[12:31] <marcoagpinto> :)
[12:32] <marcoagpinto> in Calc
Comment 5 Aron Budea 2021-03-18 23:13:42 UTC 
Marco, can you post the version information from the About box, and the screen resolution (is it Full HD, or 4K with scaling)?
Comment 6 Marco A.G.Pinto 2021-03-19 07:07:43 UTC 
Created attachment 170564 [details]
Screenshot of About window

Version: 7.1.1.2 (x64) / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL


The screen is 1920x1080.

I haven't changed any Windows settings regarding the display (that I can remember).

Except on LibreOffice itself where I changed all icons to the largest possible.
Comment 7 Roman Kuznetsov 2021-08-28 11:34:42 UTC 
Marco, you can use Sum symbol from drop-down widget Insert Special Characters and you'll can have the problem. Can you try?
Comment 8 Marco A.G.Pinto 2021-08-28 22:07:21 UTC 
Sorry… I will only have time on Monday.
Comment 9 QA Administrators 2021-08-29 04:09:34 UTC Comment hidden (obsolete)
Comment 10 Marco A.G.Pinto 2021-09-01 06:44:10 UTC 
(In reply to Roman Kuznetsov from comment #7)
> Marco, you can use Sum symbol from drop-down widget Insert Special
> Characters and you'll can have the problem. Can you try?

Hello!

That is how I inserted the symbol, I believe.

The bug only happens when you open a Calc spreadsheet for the first time with quickstarter enabled.

If you open the spreadsheet a second or third time, the bug vanishes.
Comment 11 Marco A.G.Pinto 2021-12-29 11:56:21 UTC 
It seems to be fixed two or three releases ago of 7.2.

Closing it.