[Libreoffice-bugs] [Bug 131462] New: MACRO WILL NOT COPY CELLS VALUES WHOSE CELLS HAVE VLOOKUP INDEX>2

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131462

            Bug ID: 131462
           Summary: MACRO WILL NOT COPY CELLS VALUES WHOSE CELLS HAVE
                    VLOOKUP INDEX>2
           Product: LibreOffice
           Version: 6.4.1.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: romrodz77 at outlook.com

Description:
I made a macro to copy table A and paste its values (paste special) into table
B.
Those cells having a vlookup function with index>2 will not be copied.

I have attached a spreadsheet with a macro that copies the values from the
table B (range AT18 BF247) into the table A on the left (range B18 N247).
The macro is activated by the button UPDATE. Look at the brown columns in table
A on the right, press the button at B210 and look at the brown columns in table
B. Those values whose origin have vlookup functions with indexes > 2 are
missing. To check this bug, modify the indexes to 1 or 2, press the button and
it will work.
(some cells in the brown columns are just values, =strings, etc, to check the
hypothesis).

Steps to Reproduce:
1. OPEN THE ATTACHED DOCUMENT (ALLOW MACROS)
2. PRESS THE "UPDATE" BUTTON.
3. BROWN COLUMNS HAVE NOT BEEN COPIED IF THEIR ORIGIN HAVE A VLOOKUP FUNCTION
WHOSE INDEX IS >2

Actual Results:
 BROWN CELLS IN ROWS 218 AND 227 ARE BLANK.

Expected Results:
 BROWN CELLS IN ROWS 218 AND 227 SHOULD HAVE THEIR VALUE COPIED.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Versión: 6.4.1.2 (x64)
Id. de compilación: 4d224e95b98b138af42a64d84056446d09082932
Subprocs. CPU: 8; SO: Windows 10.0 Build 18363; Repres. IU: GL; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200321/e5b4f3f5/attachment.htm>