Bug 133572 - Sheet gets completely confused if I enter '+/-' as text.
Summary: Sheet gets completely confused if I enter '+/-' as text.
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.5.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-01 07:15 UTC by EasyGoingPat
Modified: 2020-10-16 14:34 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot before trying to change row-height (13.41 KB, image/jpeg)
2020-06-01 07:20 UTC, EasyGoingPat
Details
Screenshot after setting cell to text and setting row-height (11.34 KB, image/jpeg)
2020-06-01 07:22 UTC, EasyGoingPat
Details

Note You need to log in before you can comment on or make changes to this bug.
Description EasyGoingPat 2020-06-01 07:15:25 UTC
Description:
I tried to enter '+ / -' in a cell, intending this to display simply as-is (i.e. as text). This initially was fine but reloading the document caused the row-height to treble.

When I tried to set the row-height back to its previous value, the sheet seemed to get completely confused, moving the cell contents to the right.

I tried reloading the original and explicitly choosing the cell style as text but this did not fix the problem.

Steps to Reproduce:
1. Enter '+ / -' as the contents of a cell with an explicit row-height.
2. Save the sheet.
3. Re-open the sheet.

Actual Results:
The row-height had increased roughly by a factor of three.

Repeating the above but first setting the cell type to text did not fix the problem.

Expected Results:
I expected the original row-height and formatting to be respected and for '+ / -' to be displayed as verbatim text.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
OS: Windows 10
OS is 64bit: yes
Comment 1 EasyGoingPat 2020-06-01 07:20:09 UTC
Created attachment 161483 [details]
Screenshot before trying to change row-height

This shows the described bug after reloading the sheet and trying to set the row-height explicitly.
Comment 2 EasyGoingPat 2020-06-01 07:22:06 UTC
Created attachment 161484 [details]
Screenshot after setting cell to text and setting row-height

This screenshot is after I tried to set the cell style explicitly to text and then tried to set the row-height back to the value I originally set.
Comment 3 Buovjaga 2020-10-10 15:23:25 UTC
No problem here. Please attach an example document and indicate cell we have to insert in.

Arch Linux 64-bit
Version: 7.0.1.2
Build ID: 00(Build:2)
CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); Käyttöliittymä: fi-FI
=7.0.1-1
Calc: threaded
Comment 4 EasyGoingPat 2020-10-16 14:28:58 UTC
Guess this has to be closed because I can't duplicate it now. If it happens again, I'll try to create a version of the sheet that causes the problem.

Thanks for looking.

- Patrick
Comment 5 Buovjaga 2020-10-16 14:34:25 UTC
Cheers, let's close indeed for now.