Bug-Report:
(1) Komponente:
Calc,
function VLOOKUP (SVERWEIS),
function "Insert Columns before",
function "Insert Columns after"
(2) Betriebssystem:
Windows 7, 32 Bit
(3) Meine LibreOffice-Version:
Version: 6.4.7.2 (x86)
Build-ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU-Threads: 8; BS: Windows 6.1 Service Pack 1 Build 7601; UI-Render:
Standard; VCL: win;
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded
(4) Letzte Version ohne Fehler (optional):
unbekannt
Fehler trat schon in 5.?.? auf.
(5) Sprache der Benutzeroberfläche:
deutsch
(6) Fehler-Kurzbeschreibung:
Inserting a new column can erroneously change the result
of a VLOOKUP.
(7) Schritte, wie das Problem reproduziert werden kann:
sehr leicht
Fehler trat bei all meinen Experimenten auf.
(8) Beobachtetes Verhalten:
If a new column is added and it hits the column range a VLOOKUP
refers to, then the column VLOOKUP takes its final result from
(which is determined by the parameter return_column_index) can
be shifted one column to the right. Since VLOOKUP's parameter
return_column_index is not updated, the result of VLOOKUP changes.
(9) Erwartetes Verhalten:
The function inserting the column should update VLOOKUP's parameter
return_column_index (+1), so that the result of VLOOKUP does not change
by adding the column.
(12) Ergänzungen (optional):
Ich wollte Euch nur helfen.
Danke für Eure Arbeit!
(13) E-Mail-Adresse für Rückfragen:
voyager002@googlemail.com
--
Liste abmelden mit E-Mail an: users+unsubscribe@de.libreoffice.org
Probleme? https://de.libreoffice.org/hilfe-kontakt/mailing-listen/abmeldung-liste/
Tipps zu Listenmails: https://wiki.documentfoundation.org/Netiquette/de
Listenarchiv: https://listarchives.libreoffice.org/de/users/
Datenschutzerklärung: https://www.documentfoundation.org/privacy
Context
- [de-users] [bug-per-mail] Adding a column does not update VLOOKUP's parameter "index" · Voyager 2
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.