Showkiller: Reference Management at Cut

[Christof97]

I'm a Data Analyst and Data Scientist since many years and thus spent thousands of hours with all kinds of data analysis in MS Excel (and many other tools). Privately annoyed by the Microsoft Licence politics I discovered already in 2012 Softmaker and bought their Office Suite. Too late I discovered a showkiller, which stopped my use of Planmaker just in a second. One of the absolutely vital requirements to build up a larger spreadsheet is the perfect management of the cell references at Copy & Paste. You use "Copy" to create new cells, columns, rows and thus references have to be modified by the software to point to the new corresponding sources (e.g. the new row, the new column etc.). You use "Cut" to move a already defined and tested sheet section to another place - all reference have to be kept stable by the software, otherwise your sheet is dysfunctional afterwards and you even might not discover it at first. If the references don't remain constant during "Cut" you are not anymore able to modify the design of your calculation or to prepare an extension "in between" without tremendous and error critical manual corrections of the references after each move of a cell section.
In 2012 Planmaker didn't follow this principle: It modified the cell references at "Copy" and "Cut". Now I tried it again with the newest version 2024 NX: Same problem. WHY? I honestly don't understand how thousands of users are engaged with Planmaker since at least 12 years without insisting heavily to fix this bug. It forces me still in 2024 to stick further on Excel though I'm really annoyed to be forced to use it privately.

[SuperTech]

Thank you for posting your query and for your interest in SoftMaker Office.

In PlanMaker, as you mentioned, when you cut and paste a range, the cell references update. This behavior occurs because, after a single cut command, you can paste the content into multiple cells if needed—a functionality not available in the other software you mentioned.

If you wish to move a range without updating the cell references, simply select the range, hold the left mouse button, and drag it to the desired location. This will move the range without altering the cell references.

[dhermosillo]

Thank you for posting your query and for your interest in SoftMaker Office.

In PlanMaker, as you mentioned, when you cut and paste a range, the cell references update. This behavior occurs because, after a single cut command, you can paste the content into multiple cells if needed—a functionality not available in the other software you mentioned.

If you wish to move a range without updating the cell references, simply select the range, hold the left mouse button, and drag it to the desired location. This will move the range without altering the cell references.

I think the OP was wanting to maintain the references.
I too am wondering how to do this.
In Excel a row or column can be cut and pasted in a new location and it automatically removes the old ranges and inserts a new range in the new location with updated references.
In Planmaker, Cut seems to remove the content but leave the row or column, then Insert just adds a blank row or column.
What is the process to move a row/column, remove the old row/column, add a new row/column and paste the content while updating all of the references so they still work?