https://bugs.documentfoundation.org/show_bug.cgi?id=156174
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Bug in formulas if delete a |Bug in VLOOKUP formula if |sheet |delete a sheet Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC| |stephane.guillou@libreoffic | |e.org --- Comment #2 from Stéphane Guillou (stragu) <[email protected]> --- I can't create a formula of the type =VLOOKUP(2,UPN,1) in the first place, I straight away get a #NAME? error (and the formula is changed to =VLOOKUP(2,upn,1) even though I do have a UPN sheet). Could you please attach an example document, in its state before the sheet is deleted, so we can test in the same conditions? Was the file created in LibreOffice or another tool? Thank you. Tested with: Version: 7.6.0.0.beta1 (X86_64) / LibreOffice Community Build ID: be55b15d98c5f059483845a183fcb5ea8023d27c CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
