VLOOKUP with reference to different workbook file breaks

[budiljak]

Hello!

If there's any VLOOKUP formulas they are broken after parsing / saving the xlsx file.

If it was something like

=VLOOKUP(A2, [Price_List.xlsx]Prices!$A$2:$C$9, 3, FALSE)

it changes to

=VLOOKUP(A2, [1]Prices!$A$2:$C$9, 3, FALSE)

Anyway the data doesn't get refreshed when I reopen the file in Excel.

As it's many of those formulas in the workbook I want to edit, this results in a major problem for me.

It would be great if that could be fixed in near future! :-D

Kind regards,
Ben

[weshatheleopard]

Can you provide a sample file that experiences this problem?

[budiljak]

Sure:
When I just parse and save a file (test.xlsx -> parsed_test.xlsx) with a VLOOKUP, the formula is broken afterwards. When I open it with Libreoffice the file reference is removed. When I open it with Excel (16) the whole formula is removed.

Find the test files attached.

Here's the ruby script:

require 'rubyXL'

book = RubyXL::Parser.parse("<FULL_PATH>/test.xlsx")
book.write("<FULL_PATH>/parsed_test.xlsx")

Regards,
Ben

data.xlsx
parsed_test.xlsx
test.xlsx