1. Forum
  2. Usenet
  3. LINUX.GENTOO.USER

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

    From Dr Rainer Woitok@21:1/5 to All on Sat Apr 9 17:40:02 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Stefan Schmiedl@21:1/5 to All on Sat Apr 9 18:50:01 2022

    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


    <html><head> <style type="text/css" title="rt_noDelete">
    blockquote.rt {
    margin: 0 0 15px;
    border-left: 4px solid #81c784;
    padding: 0 0 0 12px;
    display: block;
    }
    p { margin: 0 0 0 0 }
    .email-signature {font-family:"Arial Narrow"; font-size: 10pt; font-style: italic; font-weight: normal; text-decoration: none; }
    </style><STYLE type="text/css" title="rt">BODY {margin: 10; font-family:"Consolas"; font-size: 11pt; color: #000000}
    P {margin: 0; font-family:"Consolas"; font-size: 11pt; color: #000000} PRE.RFCheader {font-family:"Consolas"; font-size: 10pt; color: #B73A67} .email-signature { color: #969696; font-style: italic;font-weight: normal;text-decoration: none }
    A {color: #0066CC; link: #0066CC; font-style: normal;font-weight: normal;text-decoration: underline }
    BLOCKQUOTE.Odd {font-family:"Consolas"; font-size: 10pt; color: #9AA626; font-style: italic;font-weight: bold;text-decoration: none }
    BLOCKQUOTE.Even {font-family:"Consolas"; font-size: 10pt; color: #50AF4C; font-style: italic;font-weight: bold;text-decoration: none }
    .QOdd {font-family:"Consolas"; font-size: 10pt; color: #9AA626; font-style: normal;font-weight: normal;text-decoration: none }
    .QEven {font-family:"Consolas"; font-size: 10pt; color: #50AF4C; font-style: normal;font-weight: normal;text-decoration: none }
    PRE {font-family:"Consolas"; font-size: 11pt; font-style: normal;font-weight: normal;text-decoration: none }
    BODY {background-color: #FFFFFF}
    </STYLE></head><body><xhtml><head> <style title="rt_noDelete" type="text/css">
    blockquote.rt {
    margin: 0 0 15px;
    border-left: 4px solid #81c784;
    padding: 0 0 0 12px;
    display: block;
    }
    p { margin: 0 0 0 0 }
    .email-signature {font-family:"Arial Narrow"; font-size: 10pt; font-style: italic; font-weight: normal; text-decoration: none; }
    </style><style title="rt" type="text/css">BODY {margin: 10; font-family:"Consolas"; font-size: 11pt; color: #000000}
    P {margin: 0; font-family:"Consolas"; font-size: 11pt; color: #000000} PRE.RFCheader {font-family:"Consolas"; font-size: 10pt; color: #B73A67} .email-signature { color: #969696; font-style: italic;font-weight: normal;text-decoration: none }
    A {color: #0066CC; link: #0066CC; font-style: normal;font-weight: normal;text-decoration: underline }
    BLOCKQUOTE.Odd {font-family:"Consolas"; font-size: 10pt; color: #9AA626; font-style: italic;font-weight: bold;text-decoration: none }
    BLOCKQUOTE.Even {font-family:"Consolas"; font-size: 10pt; color: #50AF4C; font-style: italic;font-weight: bold;text-decoration: none }
    .QOdd {font-family:"Consolas"; font-size: 10pt; color: #9AA626; font-style: normal;font-weight: normal;text-decoration: none }
    .QEven {font-family:"Consolas"; font-size: 10pt; color: #50AF4C; font-style: normal;font-weight: normal;text-decoration: none }
    PRE {font-family:"Consolas"; font-size: 11pt; font-style: normal;font-weight: normal;text-decoration: none }
    BODY {background-color: #FFFFFF}
    </style></head><body>
    <p>Hello Rainer,<br/><br/></p><p>Excel automatically adjusts the formular to include the newly added line,</p><p>while LibreCalc does not ... by default. However, there is</p><p>a setting (Extras -&gt; Optionen -&gt; LibreOffice Calc -&gt; Allgemein -
    &gt; Eingabe-Einstellungen)</p><p>called "Bezüge beim Einfügen von Zeilen/Spalten an deren Rändern ausdehnen",</p><p>which does the trick.</p><p>&nbsp;</p><p>HTH,</p><p>s.</p><p>&nbsp;</p><p>Samstag, 9. April 2022 17:36:<br/></p><p>&nbsp;</p><p><xhtml>
    <head> <style title="rt_noDelete" type="text/css">
    blockquote.rt {
    margin: 0 0 15px;
    border-left: 4px solid #81c784;
    padding: 0 0 0 12px;
    display: block;
    }
    p { margin: 0 0 0 0 }
    .email-signature {font-family:"Arial Narrow"; font-size: 10pt; font-style: italic; font-weight: normal; text-decoration: none; }
    </style><style title="rt" type="text/css">BODY {margin: 10; font-family:"Consolas"; font-size: 11pt; color: #000000}
    P {margin: 0; font-family:"Consolas"; font-size: 11pt; color: #000000} PRE.RFCheader {font-family:"Consolas"; font-size: 10pt; color: #B73A67} .email-signature { color: #969696; font-style: italic;font-weight: normal;text-decoration: none }
    A {color: #0066CC; link: #0066CC; font-style: normal;font-weight: normal;text-decoration: underline }
    BLOCKQUOTE.Odd {font-family:"Consolas"; font-size: 10pt; color: #9AA626; font-style: italic;font-weight: bold;text-decoration: none }
    BLOCKQUOTE.Even {font-family:"Consolas"; font-size: 10pt; color: #50AF4C; font-style: italic;font-weight: bold;text-decoration: none }
    .QOdd {font-family:"Consolas"; font-size: 10pt; color: #9AA626; font-style: normal;font-weight: normal;text-decoration: none }
    .QEven {font-family:"Consolas"; font-size: 10pt; color: #50AF4C; font-style: normal;font-weight: normal;text-decoration: none }
    PRE {font-family:"Consolas"; font-size: 11pt; font-style: normal;font-weight: normal;text-decoration: none }
    BODY {background-color: #FFFFFF} </style></head><xbody></xbody></xhtml></p><blockquote class="Odd QOdd rt" prefix="&gt;&nbsp;">Greetings,</blockquote><p class="norm"><br/></p><blockquote class="Odd QOdd rt" prefix="&gt;&nbsp;">are there any LibreOffice Calc experts on this list?</
    blockquote><p class="norm"><br/></p><blockquote class="Odd QOdd rt" prefix="&gt;&nbsp;">I have some "*.xlsx" files &nbsp;which were created with Excel under Windows.<br/>
    These feature a "footer" line, &nbsp;which for instance &nbsp;compute the sums for<br/>
    various columns. &nbsp; If you use Excel under Windows &nbsp;and insert &nbsp;a new row<br/>
    before this footer line, the sum in the footer line will be updated acc-<br/> ordingly. &nbsp;Using "Calc" this line is a normal line, and inserting anoth-<br/>
    er line before it does NOT adjust the row numbers in its formulas.</blockquote><p class="norm"><br/></p><blockquote class="Odd QOdd rt" prefix="&gt;&nbsp;">Googling for "libreoffice calc footer" &nbsp;pointed me to clicking on "Head-<br/>
    ers and Footers" in the "Insert" pulldown menu. &nbsp;However, this is greyed<br/>
    out. &nbsp; Do I need special USE flags to activate that? &nbsp; Or are ther other<br/>
    methods to update the formulas in a row when another row is inserted be-<br/> fore it?</blockquote><p class="norm"><br/></p><blockquote class="Odd QOdd rt" prefix="&gt;&nbsp;">Any help appreciated :-)</blockquote><p class="norm"><br/></p><blockquote class="Odd QOdd rt" prefix="&gt;&nbsp;">Sincerely,<br/>
    &nbsp; Rainer</blockquote><p class="norm"><br/></p></body></xhtml><br/><br/> </body>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dr Rainer Woitok@21:1/5 to you on Sun Apr 10 12:40:01 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dan Johansson@21:1/5 to Dr Rainer Woitok on Sun Apr 10 13:10:01 2022
    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! ***************************************************

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dr Rainer Woitok@21:1/5 to you on Sun Apr 10 14:40:01 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)