In Ms Excel, LibreOffice Calc, OnlyOffice spreadsheet the CTRL + X / CTRL + V sequence will cut-and-paste without change the references in the source cell. Eg, if the cell to be moved contains '=A3' after pasting the destination cell will contain '=A3', regardless of its location in the sheet.
I couldn't find a way to do this in PlanMaker (short of explicitely writing '=$A$3' in the cell to be moved). Am I missing something?
How to cut/paste absolute references.
Re: How to cut/paste absolute references.
Hi, we already have an internal discussion going related to this issue. I added your message there and I'll let you know when we have news.
P.S. If you do the same operation with mouse drag and drop, the result is what you wish. To drag only a single cell without a selection color, click into the cell and hold the mouse button. After half a second the drag cursor is shown
P.S. If you do the same operation with mouse drag and drop, the result is what you wish. To drag only a single cell without a selection color, click into the cell and hold the mouse button. After half a second the drag cursor is shown
Re: How to cut/paste absolute references.
I have a similar question: how to copy entire sheet to other document, not changing the formulas (if it points to "=A5" or "=Sheet1!N16", let it stay that way). I other words: can copied sheet "not pointing to original document". (I have tried changing formula to "=$Sheet1!N16" but it dont work.)(I have solved this by replacing "references to other document" with only "reference to sheet" 
)
Thank You! Best Regards!
) Thank You! Best Regards!
Last edited by dpercic on Sat Mar 15, 2025 10:43 am, edited 1 time in total.