Excel connection endpoint automatic alignment method and device

Abstract

The invention provides an Excel connecting line endpoint automatic alignment method and device, and the method comprises the following steps: finding all connecting lines in a page in an embedded VBAof Excel through employing the attributes of a graphic object, and obtaining a connecting line set; judging a starting point and an ending point of a certain connecting line through a graph overturning function and obtaining coordinates; traversing all cells in a preset range, calculating the distance between the current connection endpoint and the specified position of the boundary of the cells,and finding the cell with the minimum distance; updating the starting point and the ending point of the connecting line to be coordinates of the boundary point of the nearest cell, deleting the old connecting line and redrawing the connecting line by using the updated coordinates; traversing the connection line set, and aligning all the connection lines until the connection line set is empty; by traversing the connecting lines and the cells and judging the starting point and the terminal point, redrawing of the existing connecting lines is achieved, and automatic alignment of the connecting lines is achieved.

Description

technical field [0001] The present disclosure relates to the field of computer technology, in particular to a method and device for automatic alignment of Excel connection endpoints. Background technique [0002] The statements in this section merely provide background information related to the present disclosure and may not necessarily constitute prior art. [0003] As a commonly used spreadsheet software, Excel not only has powerful cell-based data calculation capabilities, but also its convenient graphics insertion and editing functions are often applied to various data visualization fields, such as using basic graphics to represent different elements Or use arrows and lines to indicate the direct relationship between cells, etc. [0004] The inventors of the present disclosure have found that although the connection function of Excel itself (the connection with arrows is only set differently at the endpoints) is relatively convenient, the alignment methods in the curre...

AI Technical Summary

Problems solved by technology

[0004] The inventors of the present disclosure have found that although the connection function of Excel itself (the connection with arrows is only set differently at the endpoints) is relatively convenient, the alignment methods in the current version only have alignment to the grid and alignment to graphics; and alignment to the network The function can only be automatically aligned to the four corners of a certain cell, and it cannot be automatically aligned for other positions; if you do not use the built-in alignment of Excel, when using a line to connect cells, you need to fine-tune the position of the endpoint Align it with the boundaries of the cells that need to be connected. When there are many connections, this operation step will become very time-consuming and reduce work efficiency

Images