Problem SUM-function

General
1

Hello everyone,

i have the following problem:

In Excel, I use a template with n columns. Subtotals are displayed in various rows, which I generate using the sum formula. Finally, columns that are no longer needed are deleted.

This results in the formula not automatically adjusting when columns are deleted that are located BEFORE the column with the sum formula.

Example: =SUM(F12:F18), column B is deleted. It should then be SUM(E12:E18).

I also tried the notation =SUM($F12:$F18) and switched to R1C1 with the formula =SUM(R-6]C:R[-1]C) . No adjustment takes place.

Is there a solution to this problem?

2

Sorry, but LibXL doesn’t update formulas when deleting rows or columns.

You can do it manually if you like.

3

Was this not supported in the previous version?
We would appreciate it if you could let us know when this issue is expected to be resolved.