Bug 137849 - [Calc][UI] remember (retain) chosen state/ the size (number of lines) of "input line"
Summary: [Calc][UI] remember (retain) chosen state/ the size (number of lines) of "inp...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 155248 (view as bug list)
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2020-10-29 09:19 UTC by Fedon Kadifeli
Modified: 2023-05-11 16:42 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
My doing (13.22 KB, image/jpeg)
2020-11-20 12:54 UTC, Martin Srdoš
Details
Calc input line (51.75 KB, image/png)
2020-11-21 10:13 UTC, Fedon Kadifeli
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Fedon Kadifeli 2020-10-29 09:19:24 UTC
Description:
I am using LibreOffice Calc 6.x and 7.x under Ubuntu. Every time I start Calc, the size of the input line (the area where we enter values or formulas) is set to a single line. I can click the down arrow at the far right or just drag the border below the input line further down to expand it to more than one line. I would like this to be permanent. However, each time I exit and restart Calc (even with the same spreadsheet) this area is returned back to a single line.

The size of the input line can be remembered across Calc invocations or a new setting can be put under Tools -> Options -> LibreOffice Calc -> General or Defaults, like "Size of input line" : "1..5 lines".


Steps to Reproduce:
1. Open a new sheet. The "Input Line" has size of *one* line.
2. Drag the border below the input line further down to expand it to two or three lines.
3. Enter something to the sheet.
4. Save and close Calc.
5. Reopen Calc and the shreadsheet document. The "Input Line" has again size of *one* line.


Actual Results:
The "Input Line" size is reset to *one* line each time Calc is closed and reopened.

Expected Results:
I want the size of the input line to be remembered or at least be set to some user defined size in Options.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.0.2.2
Build ID: 00(Build:2)
CPU threads: 12; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-GB (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.2-0ubuntu1
Calc: threaded
Comment 1 Fedon Kadifeli 2020-11-13 08:35:35 UTC
I think saving and restoring the size of the input line between Calc invocations, should be easy to implement and no important (adverse) change will be experienced as compared to the current state (resetting the input line size to 1).
Comment 2 Martin Srdoš 2020-11-20 12:54:43 UTC
Created attachment 167417 [details]
My doing
Comment 3 Martin Srdoš 2020-11-20 13:09:31 UTC
Hello Fedon,

Thank you for reporting the bug. Unfortunately i don't know, if I understand correctly. In attachment "My doing" is printscreen, where I finished after go through the steps.

Could you to check it and write, what exactly is your requirement? Because after clicking the situation is same like after reopen the file. So I expect that I understand badly.

Thanks a lot.
Comment 4 Fedon Kadifeli 2020-11-21 10:13:06 UTC
Created attachment 167450 [details]
Calc input line

Please note: This is not a bug report, but it is an enhancement request.

As shown in the screenshot attached, I am not talking about the size of the cell currently being edited (marked with "1" on the screenshot). I am talking about the input line marked with "2". The vertical size of this line can be changed by

* either dragging the border below it further down to expand it to more than one line
* or clicking the down arrow at the far right (marked with "3" on the screenshot).

I want this change in size to be permanent. In MS Excel (I have tested MS Office 2010 version) this change survives closing and re-opening Excel. However, in LO Calc it is reset to the default size of one line, when Calc is closed and re-opened.
Comment 5 Fedon Kadifeli 2020-11-21 10:16:18 UTC
Please see attached screenshot and comment.
Comment 6 Martin Srdoš 2020-11-21 17:45:40 UTC
Hi Fedon, thanks you for description.
Comment 7 Martin Srdoš 2020-11-21 17:47:25 UTC
UX Team -- please take a look at this enhancement. Thanks!
Comment 8 Heiko Tietze 2020-11-23 15:11:57 UTC
Normal workflow is to have numbers and formulas, which fit into the single line formula bar (fb). If we store the last used value (expanded or not), many users needs to close the fb manually. So I would prefer a macro solution executed on start; guess it's not too difficult. Question to the macro experts.
Comment 9 Fedon Kadifeli 2020-12-07 09:34:39 UTC
(In reply to Heiko Tietze from comment #8)
> Normal workflow is to have numbers and formulas, which fit into the single
> line formula bar (fb). If we store the last used value (expanded or not),
> many users needs to close the fb manually. So I would prefer a macro
> solution executed on start; guess it's not too difficult. Question to the
> macro experts.

I cannot understand your point. What I want from this enhancement is to keep the "formula bar" exactly on the same state after Calc restarts. That is; if it is on closed state, it should remain closed after a restart; if it is open, it should remain open WITH THE SAME NUMBER OF LINES after a restart. This is exactly how Microsoft Office Excel behaves.
Comment 10 Heiko Tietze 2020-12-07 10:00:30 UTC
(In reply to Fedon Kadifeli from comment #9)
> What I want from this enhancement is to keep the "formula bar" exactly...

While I'm always pro keeping user choices I guess your workflow is very special and most users likely do not need the formula bar to be expanded. In some rare cases they might expand but don't expect it to remain. So my suggestion was to go with an tailor-made extension that does exactly what you want. Unfortunately the macro experts didn't comment yet.
Comment 11 Alain Romedenne 2020-12-07 16:49:21 UTC
Hi

- Recording a macro does not exhibit any .UNO://command.
- I did not manage to identify a corresponding css.Sheet API service for the formula bar

According to Dev IRC, such an API may not exist.
Comment 12 Cor Nouws 2020-12-09 22:12:32 UTC
Why not ?
Comment 13 Heiko Tietze 2020-12-10 07:56:59 UTC
We discussed the topic in the design meeting. Since realizing per extension seems not to be possible, keeping user settings is desirable per se, and MSO works in the expected way, the enhancement should be done.

Code pointer: sc/source/ui/app/inputwin.cxx, ScInputBarGroup(), mxTextWndGroup->SetNumLines() (but not an easyhack)
Comment 14 Fedon Kadifeli 2022-08-17 15:17:35 UTC
Any news?
Comment 15 Michael Warner 2022-08-17 17:13:47 UTC
Just to provide a use case for why this is desirable, sometimes a spreadsheet will have a lot of text entered into one or more cells with some kind of formatting. In this case, it can be easiest to edit that text in a multi-line formula bar. Editing inside the cell on the sheet or in a single-line formula bar where I have to scroll far to the right or left to see all of the text becomes more difficult. I have faced this scenario in real life some times. 

However, I wonder if this preference should be stored per document, or application-wide.
Comment 16 Stéphane Guillou (stragu) 2023-05-11 16:41:44 UTC
*** Bug 155248 has been marked as a duplicate of this bug. ***