| Summary: | CDbl(" 28 ") errors out | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Mike Kaganski <mikekaganski> |
| Component: | BASIC | Assignee: | Andreas Heinisch <andreas.heinisch> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | andreas.heinisch, himajin100000, xiscofauli |
| Priority: | medium | ||
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:7.4.0 target:7.3.1 | ||
| Crash report or crash signature: | Regression By: | ||
@Andreas, I thought you might be interested in this issue https://opengrok.libreoffice.org/xref/core/basic/source/sbx/sbxscan.cxx?r=47aabde0#270 https://opengrok.libreoffice.org/xref/core/basic/source/runtime/methods1.cxx?r=840b4eb2#323 Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a79e7dc9e8097c199e91288027861e3883e14d1b tdf#146672 - CDbl: skip spaces and tabs at the end of the scanned string It will be available in 7.4.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. Andreas Heinisch committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/c3d14dcbd83c96610f1c9acd1bfb95c8dbd05be1 tdf#146672 - CDbl: skip spaces and tabs at the end of the scanned string It will be available in 7.3.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. |
CDbl("28 ") gives "Inadmissible value or data type. Data type mismatch." Cf. to CInt("28 ") which succeeds. Note also that VBA handles such a string correctly. Tested with Version: 7.3.0.1 (x64) / LibreOffice Community Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL