Description: The "Formula for Value" button appears disabled when I place it on the toolbar Steps to Reproduce: 1.Write a formula 2.Turn the button visible in the toolbar 3.try to press the button (I'll try to update to the latest version) Actual Results: The button appears grayed out and not clickable Expected Results: The button should be always available for using in any formula content. Reproducible: Always User Profile Reset: No Additional Info: There is not such an option in this menu. In MacOs is different. Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 8; OS: Mac OS X 14.5; UI render: default; VCL: osx Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: threaded
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.