https://bugs.freedesktop.org/show_bug.cgi?id=80259

--- Comment #1 from [email protected] ---
Created attachment 101390
  --> https://bugs.freedesktop.org/attachment.cgi?id=101390&action=edit
test file: vlookup-blank-value.ods

P.S.:

When Unzip the ods file and observe content.xml:

In the sheet1 part, it shows the following for the blank cell:
  <table:table-cell /> 

But in the sheet2 part, it shows:
- <table:table-cell table:style-name="ce2"
table:formula="of:=VLOOKUP([.$A5];[$sheet1.$A$1:.$C$6];2;0)"
office:value-type="float" office:value="0" calcext:value-type="float">
  <text:p /> 
  </table:table-cell>

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to