Description: I have a spreadsheet containing my annual household budget. The sheet has a multiple of cells that contain @SUM() statements. If I double click on the cell (e.g. N35), I see the cell formula (as expected). If I double click on another cell (e.g. N34), cell N35 is replaced with garbage that is a combination of N45 and N45. If I repeat this sequence but hit the ESC key to clear the contents of N34, cell N34 will display as expected (i.e. in N34 and with the correct formula). Steps to Reproduce: 1.Create a budget style spreadsheet. Mine has a description column, 12 monthly expense columns and a final Total column. Populate some data in the 12 monthly columns for several budget items. In the Total column, use the @SUM() formula to calculate the sum of the 12 monthly values. Finally, create a new row which is uses the @SUM() formula to summarize each column. 2. Double Click on the final cell in the Total column. 3. Double Click on the cell above the final cell in the Total column Actual Results: At Step (2), the selected Cell contains the correct formula. At Step (3), the selected Cell contains garbage. Expected Results: At step (3), I expect the cell contents to be displayed correctly. Reproducible: Always User Profile Reset: No Additional Info: I can create screen shots of this sequence if that facilitates recreating the issue. Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Created attachment 183665 [details] Screenshots showing the issue in action
If I understand well, what you see is expected. When editing a formula, clicking on another cell will insert the coordinate in the formula you are currently editing. Before clicking on another cell, you will have to get out of edit mode by e.g. pressing Enter. If you only want to see the formula and not edit it, click once on the cell and look at the formula bar (aka "input line").
Thanks for the update. Did you run the recreation on your system? Does each cell show the correct data? I am not trying to edit the cell - I just wanted to see it's formula (to verify that it was correct). I did this same experiment on MS Excel and SoftMaker Office2001 PlanMaker. Both behave as I expect. I could double click on a cell and it would appear where I expected and with the data I expected. I believe your behavior is incorrect. I installed LibreOffice to try it out. If this is appropriate behavior, I will be deinstalling the product.
Created attachment 183669 [details] Example Spreadsheet to recreate the problem Use this spreadsheet to recreate the problem. Steps: 1) Double left-click on cell N33. You should see the cell replaced with the formula =SUM(B33:M33). 2) Move the cursor cell N32 and double left-click. Cell N33 is overwritten with the value =SUM(N32B33:M33). I expected N32 to display =SUM(B32:M32). MS Excel and Softwork Office 2001 display this value. There are two issues: Cell N33 is not restored to it's value (15705) and the formula for cell N32 is partially written into Cell N33. If you repeat the process but hit the ESC key between steps 1 and 2, the program behaves as expected.
Related question in the ask site: https://ask.libreoffice.org/t/disable-calc-automatically-selecting-a-cell-when-clicking-out-of-another-cell/83939
Thank you for sharing the example document, Martin! Apologies, but once again: it behaves as planned. Double-clicking on a cell will start edit mode, and the cursor will be placed where the pointer was. In edit mode _for a formula_, clicking another cell will insert a reference in the formula. This is why double-clicking (or single click, the number of clicks does not change the behaviour) will insert the cell reference in the formula currently being edited. This is useful to insert cell or range references quickly with the mouse. (In reply to LeroyG from comment #5) > Related question in the ask site: > > https://ask.libreoffice.org/t/disable-calc-automatically-selecting-a-cell- > when-clicking-out-of-another-cell/83939 As Leroy is showing, some users would like to be able to turn this off. If you'd like that option as well, please feel free to open a new bug report for that (and mark it as an "enhancement"). (I couldn't see an existing one.) Cheers!