https://bugs.documentfoundation.org/show_bug.cgi?id=143816
Bug ID: 143816 Summary: Dragging formulae across columns result in persistent wrong data Product: LibreOffice Version: 7.1.5.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: rob...@prino.org Description: When dragging a cell to other cells (empty or not makes no difference) to copy a formula, it seems that not just the formula is dragged, but also the value of the cell that is dragged, and no amount of recalculating will change this value. Only overtyping the actual formula, or one character of it will correct this situation! NOT THAT THIS IS A VERY SEVERE BUG! Steps to Reproduce: 1. Open the attached spreadsheet, and select the Naco-CoTy-Naty sheet 2. Note the values in these cells and their formulae: - G2: 48 / =MAX(G2:G301) - H2: 19 / =MAX(H2:H301) - I2: 24 / =MAX(I2:I301) - J2: 93 / =MAX(J2:J301) 2. Select cell cell G2, and drag it across to cells H2, I2, and J2 3. Note the new values / formulae in these four cells: - G2: 48 / =MAX(G2:G301) - H2: 48 / =MAX(H2:H301) - I2: 48 / =MAX(I2:I301) - J2: 93 / =MAX(J2:J301) 4: Press F9 until you're blue in the face, and nothing will change the values of cells H2 & I2 5: Edit cells H2 & I2, by just deleting the closing parentheses of the formulae, and hey, now the values are recalculated correctly! Similar thin happens fro draggingR2 across S2/T2/U2, here only S2 is screwed up! Actual Results: See above Expected Results: Se above Reproducible: Always User Profile Reset: No Additional Info: Version: 7.1.5.2 (x64) / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: threaded Note: I have not tried to reduce the sheet to something minimal, it happens in this one! -- You are receiving this mail because: You are the assignee for the bug.