| Summary: | FILESAVE XLSX Paste special of #N/A formula result result gives in Err:520 in Calc after reload | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | NISZ LibreOffice Team <libreoffice> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | VERIFIED FIXED | ||
| Severity: | normal | CC: | erack, miguelangelrv, nemeth, xiscofauli |
| Priority: | medium | Keywords: | bibisected, bisected |
| Version: | 5.0 all versions | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=79249 | ||
| Whiteboard: | target:7.0.0 target:6.4.4 target:6.3.6 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Example file from Excel
The original file after using Paste Special and saved by Calc Screenshot of the exported document side by side in Excel and Calc |
||
|
Description
NISZ LibreOffice Team
2020-03-16 08:08:53 UTC
Created attachment 158715 [details]
Example file from Excel
Created attachment 158716 [details]
The original file after using Paste Special and saved by Calc
Created attachment 158717 [details]
Screenshot of the exported document side by side in Excel and Calc
Bibisected using bibisect-win32-5.0 to: URL: https://cgit.freedesktop.org/libreoffice/core/commit/?id=a1dc5e97da273bf35d58d54e625149022569a993 author Eike Rathke <erack@redhat.com> 2014-12-16 01:56:58 +0100 committer Eike Rathke <erack@redhat.com> 2014-12-16 02:02:14 +0100 summary: construct grouped ScFormulaCell with bDirty=true, fdo#79249 related Although this probably just made the problem visible: Before this the B2 cell appeared empty in the grid, yet contained a formula in the edit bar. In 4.1 the B2 cell was not empty this way, copying #N/A seemed to work like today, but saving to XLSX and reopening results in a simple = sign instead of the Err:520. Not adding regression tag. Works for me with Version: 7.0.0.0.alpha0+ (x64) Build ID: 6f82f5163fdd43ea22958dfb28926c88ed97fa7c CPU threads: 4; OS: Windows 10.0 Build 19582; UI render: Skia/Raster; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: threaded I can reproduce. * load the first attached document * copy formula cell B3 with #N/A error * paste special (without formulas) somewhere => #N/A special formula cell is created * save as .xlsx * reload => the pasted cell has an Err:520 instead In fact happens with any error result, =NA() #N/A or =1/0 #DIV/0! both become Err:520. Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/456f093975ce4e4266eb12b62590eaaba6f2de88 Resolves: tdf#131372 Write "error cell" formula to OOXML It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending review https://gerrit.libreoffice.org/c/core/+/91390 for 6-4 https://gerrit.libreoffice.org/c/core/+/91393 for 6-3 Verified in Version: 7.0.0.0.alpha0+ Build ID: 169a10f0e4680814145b668c6320be04038d7a89 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded @Eike, thanks for fixing this issue!! Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/02c0824899b2459bba98d4cfef933bfe7376f41f Resolves: tdf#131372 Write "error cell" formula to OOXML It will be available in 6.4.4. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/437d30fa8e7daaf12990cf9672614e630e915ba5 tdf#131372: Add unittest It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/bcbf27beddabf6e76331e93fd7bead9ec534605e Resolves: tdf#131372 Write "error cell" formula to OOXML It will be available in 6.3.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |