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
@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.