[Libreoffice-bugs] [Bug 131372] New: FILESAVE XLSX Paste special of #N/A formula result result gives in Err:520 in Calc after reload

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131372

            Bug ID: 131372
           Summary: FILESAVE XLSX Paste special of #N/A formula result
                    result gives in Err:520 in Calc after reload
           Product: LibreOffice
           Version: 5.0 all versions
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

Description:
If a formula gives #N/A result – because of missing data – and this result is
copied and pasted using Paste Special, then saved as XLSX the reloaded file
gives Err:520, while Excel gives #N/A.

Steps to Reproduce:
1. Open attached file. It contains a simple MATCH formula in B2:B3 that refers
to the second sheet. The function in B3 gives #N/A since it does not find a
match on the second sheet.
2. The contents of B2:B3 were copied and pasted as text in Excel to B5:B6. The
result in B6 is imported fine as in Calc. User intent was to get the formula
results as plain text.
3. Copy the B2:B3 cells contents (in the example B8:B9) and insert it using
Paste Special, with default settings (Selection: Text, Numbers, Date&Time).
4. Save the file as XLSX and reload.

Actual Results:
In Calc the B9 cells content appears as Err:520, while in Excel it appears as
#N/A

Expected Results:
B9 cell should show #N/A too


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: cf96cb11e2a46c452a273ded1c66c556118983cf
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

Started to happen in:
Version: 4.4.0.3
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Locale: hu_HU

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200316/cc5ad86e/attachment.htm>