Bug 149777 - The contents of the cell appears in the second line of the formula bar
Summary: The contents of the cell appears in the second line of the formula bar
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 151786 (view as bug list)
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency tree / graph
 
Reported: 2022-06-29 19:34 UTC by haim.shaposhnik
Modified: 2022-12-27 22:18 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
enter a cell after selecting an empty one. the formula is not displayed (35.20 KB, image/png)
2022-06-29 19:34 UTC, haim.shaposhnik 		Details
A sample file (7.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-07-01 12:50 UTC, haim.shaposhnik 		Details
Screen Captures (137.28 KB, application/pdf)
2022-07-01 12:51 UTC, haim.shaposhnik 		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 haim.shaposhnik 2022-06-29 19:34:04 UTC 
Created attachment 181018 [details]
enter a cell after selecting an empty one. the formula is not displayed

Calc bug in the formula field - contents is sometimes hidden,
appears in the second line when exteded

Steps to Reproduce:
1. start calc
2. navigate to a cell with contens and look at the formula bar

Expected Results:
the formula or contents of the cell is placed in formula bar and editable

Actual Results:
Can not edit the cell from the formula bar. it appears blank.
when openning (extending it) the contents of the cell appears on the second line instead of the first line of the formula bar.

Reproducible: Always

1.	Visit an empty cell 
2.	Visit a cell with contents
3.	Now the contents is hidden in the formula bar
4.	Expand the formula bar
5.	Now the contents is visible in the formula bar in the second line
6.	Minimize the formula bar
7.	Now the contents is *visible*+*editable* in the formula bar
8.	Visit another cell with contents
9.	Now the contents of the new cell is still visible in minimized the formula bar
10.	Visit an empty cell
11.	Now the contents is again hidden in the formula bar

Maybe duplicate of Bug 148410 ?

Version: 7.3.4.2 (x64) / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 16; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: he-IL (he_IL); UI: he-IL
Calc: CL
Comment 1 m.a.riosv 2022-06-29 21:27:00 UTC 
Please attach a sample file.
I had never seeing such behavior. Maybe there is a new line before the formulas.
Comment 2 haim.shaposhnik 2022-07-01 12:50:36 UTC 
Created attachment 181068 [details]
A sample file
Comment 3 haim.shaposhnik 2022-07-01 12:51:30 UTC 
Created attachment 181069 [details]
Screen Captures
Comment 4 Scott Clewell 2022-07-05 15:00:10 UTC 
Thank you for reporting Haim, I can reproduce once I set the interface language to Arabic but not in English.

Version: 7.3.2.2 (x86) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: ar-SA
Calc: CL 

and with

Version: 7.1.8.1 (x86) / LibreOffice Community
Build ID: e1f30c802c3269a1d052614453f260e49458c82c
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: ar-SA
Calc: CL
Comment 5 m.a.riosv 2022-10-27 13:12:18 UTC 
*** Bug 151786 has been marked as a duplicate of this bug. ***
Comment 6 Telesto 2022-10-28 03:30:06 UTC 
Did this happen in older version too, or is this a recent problem?
Comment 7 Tatsuhiko Shoji 2022-10-28 11:16:26 UTC 
Since 7.4.0.