issue, suggestions and appeals

[Eyderoe]

OpenXlSX version: Jul 3, 2022

issue

1. the value of formula won't automatical update in office2016[ just show 0 ], not test in 2019 and in 365 it's fine. maybe add a function to refresh the table could work, I don't know weather it is feasible.

suggestion

1. judge the file whether opened by Excel when save the file. when Excel open it, it will spawn ~$filename and can use filesystem.exists() to judge throw an error and wait for file close using cin may help
2. XLWorksheet.XLCellRange(ref, ref) add a judgment here if the ref are wrong, for example left:B2 right:A1 the program will drop into a loop

appeal

1. add columns, XLcolumns Im not sure why there're only about row without columns If it's not a technical problem, I sincerely hoping you can achieve this function
2. deleteRow(), deleteColum() although can accomplish by self, is there a more effective way to solve it ?

other

I write a Chinese Doc a little bit simple with some wrong maybe, but it still work. helpful to the people don't want to study further

文档.xlsx