[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 --- Comment #9 from Kevin Suo --- I guess this bug, together with bug 79249, are caused by the "GPU Calc" implemention: http://cgit.freedesktop.org/libreoffice/core/log/?id=9589aa8393ffdb7483716cb98ef2e446a7083227&qt=range&q=4ac9fa7a887d09edf7f1f

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 Kevin Suo changed: What|Removed |Added Whiteboard|bibisectRequest |bibisected --- Comment #8 from Kevin Suo --

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 --- Comment #7 from Kevin Suo --- Created attachment 109010 --> https://bugs.freedesktop.org/attachment.cgi?id=109010&action=edit The saved xlsx file To reproduce, you just need to open this xlsx file to see whether B9 is showing blank or "#N/

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 Beluga changed: What|Removed |Added CC||todven...@suomi24.fi Whiteboard|

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 suokunl...@gmail.com changed: What|Removed |Added CC||suokunl...@gmail.com --- Comment #

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 suokunl...@gmail.com changed: What|Removed |Added See Also||https://bugs.freedesktop.or

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 --- Comment #5 from pierre-yves samyn --- (In reply to comment #4) > >Comment#3 > Are you sure? Yes The cell should display the same content *as when saving*. If the formula was the sum of a range (which is properly managed) I think it would be

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 m.a.riosv changed: What|Removed |Added Keywords||regression --- Comment #4 from m.a.riosv --

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 --- Comment #3 from pierre-yves samyn --- Hi (In reply to comment #2) > Hard recalc [shift+Ctrl+F9] does the calculation. > https://help.libreoffice.org/Calc/Recalculate > Set up the option in: > Menu/Tools/LibreOffice calc/Formula - Recalculat

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 m.a.riosv changed: What|Removed |Added CC||mari...@miguelangel.mobi --- Comment #2 from

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 pierre-yves samyn changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0

[Libreoffice-bugs] [Bug 79180] VLOOKUP with #N/A value is showing blank when save as xlsx

https://bugs.freedesktop.org/show_bug.cgi?id=79180 suokunl...@gmail.com changed: What|Removed |Added Attachment #99715|text/plain |application/vnd.oasis.opend