Hello Rainer, Excel automatically adjusts the formular to include the newly added line, while LibreCalc does not ... by default. However, there is a setting (Extras -> Optionen -> LibreOffice Calc -> Allgemein -> Eingabe-Einstellungen) called "Bezüge beim Einfügen von Zeilen/Spalten an deren Rändern ausdehnen", which does the trick. HTH, s. Samstag, 9. April 2022 17:36: > Greetings,
> are there any LibreOffice Calc experts on this list? > I have some "*.xlsx" files which were created with Excel under Windows. > These feature a "footer" line, which for instance compute the sums for > various columns. If you use Excel under Windows and insert a new row > before this footer line, the sum in the footer line will be updated acc- > ordingly. Using "Calc" this line is a normal line, and inserting anoth- > er line before it does NOT adjust the row numbers in its formulas. > Googling for "libreoffice calc footer" pointed me to clicking on "Head- > ers and Footers" in the "Insert" pulldown menu. However, this is greyed > out. Do I need special USE flags to activate that? Or are ther other > methods to update the formulas in a row when another row is inserted be- > fore it? > Any help appreciated :-) > Sincerely, > Rainer