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