Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index


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


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.