Re: [gentoo-user] Footer line with LibreOffice's Calc?
On 10.04.22 12:33, Dr Rainer Woitok wrote: Stefan, On Saturday, 2022-04-09 18:46:00 +0200, you wrote: ... 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. Thanks for the quick response. However, I can nowhere find anything re- sembling this sequence of sub-menus (apart from the LibreOffice I'm us- ing is talking English). When I just enter "libreoffice" on the command line, the list of pull-down menus is "File Tools Help", and when I run "libreoffice --calc" the list of pull-down menus is "File Edit View In- sert Format Styles Sheet Data Tools Window Help". But up to now I did not find anything in the various cascaded sub-menus which would trans- late to "Eingabe-Einstellungen". In case it matters: "libreoffice --version" returns "LibreOffice 7.2.6.2 20(Build:2)" here, and this is the USE string returned by "eix": USE: bluetooth branding cups dbus gtk mariadb pdfimport postgres -accessibility -base -clang -coinmp -custom-cflags -debug -eds -firebird -googledrive -gstreamer -java -kde -ldap -odk -test -vulkan LIBREOFFICE_EXTENSIONS="-nlpsolver -scripting-beanshell -scripting-javascript -wiki-publisher" PYTHON_SINGLE_TARGET="python3_9 -python3_8 -python3_10" Am I missing some USE flag? Sincerely, Rainer In LO-Calc: Tools -> Options -> LibreOffice Calc -> General -> Input Settings -> "Expand references when new columns/rows are inserted" -- Dan Johansson, *** This message is printed on 100% recycled electrons! ***
Re: [gentoo-user] Footer line with LibreOffice's Calc?
Stefan, On Saturday, 2022-04-09 18:46:00 +0200, you wrote: > ... > 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. Thanks for the quick response. However, I can nowhere find anything re- sembling this sequence of sub-menus (apart from the LibreOffice I'm us- ing is talking English). When I just enter "libreoffice" on the command line, the list of pull-down menus is "File Tools Help", and when I run "libreoffice --calc" the list of pull-down menus is "File Edit View In- sert Format Styles Sheet Data Tools Window Help". But up to now I did not find anything in the various cascaded sub-menus which would trans- late to "Eingabe-Einstellungen". In case it matters: "libreoffice --version" returns "LibreOffice 7.2.6.2 20(Build:2)" here, and this is the USE string returned by "eix": USE: bluetooth branding cups dbus gtk mariadb pdfimport postgres -accessibility -base -clang -coinmp -custom-cflags -debug -eds -firebird -googledrive -gstreamer -java -kde -ldap -odk -test -vulkan LIBREOFFICE_EXTENSIONS="-nlpsolver -scripting-beanshell -scripting-javascript -wiki-publisher" PYTHON_SINGLE_TARGET="python3_9 -python3_8 -python3_10" Am I missing some USE flag? Sincerely, Rainer
Re: [gentoo-user] Footer line with LibreOffice's Calc?
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
[gentoo-user] Footer line with LibreOffice's Calc?
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