Created attachment 111038 [details]
Not sure if this is something related to interoperability of MS office/Libre office. In our organization as a leading manufacturing unit we deal with lot of supplier details and invoices. Started migrating to Libre office we do have lot of old data to be looked up for reference, however when we try to do a vlookup either using function wizard or manual formula it throws an error 504(to note )) getting added at the end).
Upon multiple trys when we save that as a new file and do a vlookup it works for one time again it reacts the same. Going crazy to find out what could be the reason. I am attaching the files and the screen shot. Any help is appreciated.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 111352 [details]
Test 1 file
Attached test file
Created attachment 111353 [details]
test 2 file
Attached file refer U column
I think the issue is with the single quote in the file name, because it is closing the first single quote getting a wrong formula.
escaping the single quote in the file name, and deleting unnecessary brackets at the end of the formula.
When possible the best is avoid special characters in file names, specially those that have special meaning in other areas.
Thanks for the information, we will try and get back to you with updates...
Please @SriJanani, is the issue solved?
Resolved, not new input from reporter in three months.