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
