https://bugs.documentfoundation.org/show_bug.cgi?id=161512
ady changed:
What|Removed |Added
Status|NEEDINFO|NEW
--- Comment #1 from ady ---
This is strange, and not so easy to reproduce – it requires special attention
to the details of the STR. I can reproduce on MS Windows, but (the order of)
the steps seems key.
Basically:
[ENTER] != "accept" icon
Always start the following steps with a new empty Calc spreadsheet.
1. Cell A5: =A1 (accept the formula by clicking on the "accept" icon that
occupies the same location as the equal sign on the formula bar, not by
pressing a key on the keyboard).
1.1. You should still have the focus on cell A5. This is key.
2. Add the icon with the "Formula to Value" command to the standard toolbar.
> The button is shown as expected.
But:
1. Cell A5: =A1 [ENTER]
1.1. You should have the focus on cell A6 (i.e. on a cell that has no
formula).
2. Add the icon with the "Formula to Value" command to the standard toolbar.
> The button is grayed out.
Another method:
1. Add the icon with the "Formula to Value" command to the standard toolbar.
2. Cell A5: =A1 [ENTER]
2.1. You should have the focus on cell A6 (i.e. on a cell that has no formula).
> The button in the toolbar is grayed out.
3. Focus on cell A5.
4. Menu Data > Calculate > Formula to Value.
5. Undo once ([CTRL]+[Z] on Windows). > The button in the toolbar is shown as
expected.
Reproduced with LO 6.0 and up to 24.8 alpha. I have not tested with older
versions than LO 6.0. The problem is that the behavior is inconsistent, because
it depends on the exact steps (instead of working for any cell with a formula),
and whether the formula was introduced with the “accept” icon (so we end still
on a cell with formula), or instead we end the formula with [ENTER] (so we end
on a cell without formula).
I can even have one spreadsheet with the button grayed out, while on another
window with a second spreadsheet (with the same exact content and the focus is
located on the equivalent cell, just introduced with different steps) the
button will be shown correctly.
In some versions, when performing
menu Data > Calculate > Formula to Value
the content of the cell is not updated immediately (i.e. still shows a formula,
not the value only). Changing the focus to another cell and back to the
original cell will refresh the view of the content of the cell, displaying the
expected value (no longer the formula). Whether related to the problem on the
button or not, this shows that there is some refresh problem with this feature.
--
You are receiving this mail because:
You are the assignee for the bug.
