| 1 |
On 10.04.22 12:33, Dr Rainer Woitok wrote: |
| 2 |
> Stefan, |
| 3 |
> |
| 4 |
> On Saturday, 2022-04-09 18:46:00 +0200, you wrote: |
| 5 |
> |
| 6 |
>> ... |
| 7 |
>> Excel automatically adjusts the formular to include the newly added line, |
| 8 |
>> while LibreCalc does not ... by default. However, there is |
| 9 |
>> a setting (Extras -> Optionen -> LibreOffice Calc -> Allgemein -> Eingabe-Einstellungen) |
| 10 |
>> called "Bezüge beim Einfügen von Zeilen/Spalten an deren Rändern ausdehnen", |
| 11 |
>> which does the trick. |
| 12 |
> |
| 13 |
> Thanks for the quick response. However, I can nowhere find anything re- |
| 14 |
> sembling this sequence of sub-menus (apart from the LibreOffice I'm us- |
| 15 |
> ing is talking English). When I just enter "libreoffice" on the command |
| 16 |
> line, the list of pull-down menus is "File Tools Help", and when I run |
| 17 |
> "libreoffice --calc" the list of pull-down menus is "File Edit View In- |
| 18 |
> sert Format Styles Sheet Data Tools Window Help". But up to now I did |
| 19 |
> not find anything in the various cascaded sub-menus which would trans- |
| 20 |
> late to "Eingabe-Einstellungen". |
| 21 |
> |
| 22 |
> In case it matters: "libreoffice --version" returns "LibreOffice 7.2.6.2 |
| 23 |
> 20(Build:2)" here, and this is the USE string returned by "eix": |
| 24 |
> |
| 25 |
> USE: bluetooth branding cups dbus gtk mariadb pdfimport postgres |
| 26 |
> -accessibility -base -clang -coinmp -custom-cflags -debug -eds |
| 27 |
> -firebird -googledrive -gstreamer -java -kde -ldap -odk -test |
| 28 |
> -vulkan |
| 29 |
> LIBREOFFICE_EXTENSIONS="-nlpsolver -scripting-beanshell |
| 30 |
> -scripting-javascript -wiki-publisher" |
| 31 |
> PYTHON_SINGLE_TARGET="python3_9 -python3_8 -python3_10" |
| 32 |
> |
| 33 |
> Am I missing some USE flag? |
| 34 |
> |
| 35 |
> Sincerely, |
| 36 |
> Rainer |
| 37 |
> |
| 38 |
In LO-Calc: |
| 39 |
|
| 40 |
Tools -> Options -> LibreOffice Calc -> General -> Input Settings -> "Expand references when new columns/rows are inserted" |
| 41 |
|
| 42 |
|
| 43 |
|
| 44 |
-- |
| 45 |
Dan Johansson, |
| 46 |
*************************************************** |
| 47 |
This message is printed on 100% recycled electrons! |
| 48 |
*************************************************** |
Archives