https://bugs.documentfoundation.org/show_bug.cgi?id=161512
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #1 from ady <[email protected]> --- 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.
