| Summary: | FILEOPEN XLSX Table reference broken if named table header contains comma | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | NISZ LibreOffice Team <libreoffice> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | aron.budea, erack, nemeth |
| Priority: | medium | Keywords: | filter:xlsx, implementationError |
| Version: | 5.0.0.5 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:7.1.0 target:7.0.0.1 target:6.4.6 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 108897, 137805 | ||
| Attachments: |
Example file from Excel
Screenshot of the original document side by side in Excel and Calc |
||
|
Description
NISZ LibreOffice Team
2020-03-19 13:21:35 UTC
Created attachment 158810 [details]
Screenshot of the original document side by side in Excel and Calc
Repro 70+. Only xlsx because named columns not MSO supported in xls. Basically from OO, but let's mark implementationError from when named columns supported in 5.0. @Eike, thought you might be interested in this one... Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/31951265f541c9f5acf424674e2d1d97c0f3b8c2 Resolves: tdf#131424 separator in TableRef column specifier is valid It will be available in 7.1.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 CI https://gerrit.libreoffice.org/c/core/+/97506 for 7-0 Pending review https://gerrit.libreoffice.org/c/core/+/97507 for 6-4 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/5637b974912b29805be8af85d39086bab5697aa1 Resolves: tdf#131424 separator in TableRef column specifier is valid It will be available in 7.0.0.1. 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/c131d6c6b935617fa84286a9e441c1c791520445 tdf#131424: sc: Add unittest It will be available in 7.1.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-4": https://git.libreoffice.org/core/commit/56641c9717f4fadcc81248c58c7762314270d721 Resolves: tdf#131424 separator in TableRef column specifier is valid It will be available in 6.4.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. |