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.
The "Input Line" size is reset to *one* line each time Calc is closed and reopened.
I want the size of the input line to be remembered or at least be set to some user defined size in Options.
User Profile Reset: Yes
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
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).
Created attachment 167417 [details]
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.
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.
Please see attached screenshot and comment.
Hi Fedon, thanks you for description.
UX Team -- please take a look at this enhancement. Thanks!
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.
(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.
(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.
- 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.
Why not ?
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)
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.
*** Bug 155248 has been marked as a duplicate of this bug. ***