Bug 145150

Description:
When dealing with large amounts of table data, often adjust the order of the row or column data, in the present calc, operation is such, if you want to insert the c column content between A column and column B, need to be in the top insert null columns, column B in the column c content to A new shear column B, and then to delete the original column c, which is now the D column, in the operation of the row data, too, Very troublesome.

Steps to Reproduce:
When dealing with large amounts of table data, often adjust the order of the row or column data, in the present calc, operation is such, if you want to insert the c column content between A column and column B, need to be in the top insert null columns, column B in the column c content to A new shear column B, and then to delete the original column c, which is now the D column, in the operation of the row data, too, Very troublesome.

Actual Results:
When dealing with large amounts of table data, often adjust the order of the row or column data, in the present calc, operation is such, if you want to insert the c column content between A column and column B, need to be in the top insert null columns, column B in the column c content to A new shear column B, and then to delete the original column c, which is now the D column, in the operation of the row data, too, Very troublesome.

Expected Results:
Can we learn from the functions in MS OFFICE to add the functions of inserting copied cells and inserting and cutting cells, which can save a lot of operation and time for users and improve efficiency?

MS OFFICE function logic: Both row and column data, copy or cut, after the mouse selected to insert position of a column or row after the right mouse button to select "insert replication cell" or "insert shear cell", automatically insert rows or columns and the copied data at the same time, if the execution is shearing operation, so the original data will be automatically deleted row or column.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.2.2 (x64) / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: CL