[gentoo-user] Footer line with LibreOffice's Calc?

[gentoo-user] Footer line with LibreOffice's Calc?

[Dr Rainer Woitok]

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

Re: [gentoo-user] Footer line with LibreOffice's Calc?

[Stefan Schmiedl]

[-- Attachment #1: Type: text/plain, Size: 1314 bytes --]


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


[-- Attachment #2: Type: text/html, Size: 6835 bytes --]

Re: [gentoo-user] Footer line with LibreOffice's Calc?

[Dr Rainer Woitok]

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?

[Dan Johansson]

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!
***************************************************

[gentoo-user] Re: [SOLVED] Footer line with LibreOffice's Calc?

[Dr Rainer Woitok]

Dan,

On Sunday, 2022-04-10 13:06:46 +0200, you wrote:

> ...
> In LO-Calc:
> 
> Tools -> Options -> LibreOffice Calc -> General -> Input Settings -> "Expand references when new columns/rows are inserted"

Oops ... let me politely put it this way: apparently it was too late and
I was too tired yesterday to see the obvious :-/

To summ it up: the option is not only there but also solves my problem.

Many thanks to the responders :-)

Sincerely,
  Rainer