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.
Showkiller: Reference Management at Cut
Re: Showkiller: Reference Management at Cut
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.
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.