Bug 111508 - Text to number conversion on concatenation with direct references ends with number as text
Summary: Text to number conversion on concatenation with direct references ends with n...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2017-08-08 15:17 UTC by m_a_riosv
Modified: 2023-05-19 18:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample TextToNumberConversion (8.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-08-08 15:17 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2017-08-08 15:17:10 UTC
Description:
In a formula with direct references to two cells, both referenced cells with numbers and one concatenated with "0" ends as joined text numbers.

Steps to Reproduce:
1.A1:=3
2.A2:=1
3.A3= A1+"0"&A2 gives 31 as text result

Actual Results:  
.

Expected Results:
A3: 4 as number result.


Reproducible: Always

User Profile Reset: No

Additional Info:
Reproducible with 3.3.0


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0
Comment 1 m_a_riosv 2017-08-08 15:17:51 UTC
Created attachment 135298 [details]
Sample TextToNumberConversion
Comment 2 GerardF 2017-08-09 13:41:17 UTC
Confirmed.
Seems caused by the "" following the + sign.
=A1+CONCATENATE("000";A2)
or
=A1+("000"&A2)
gives expected result.
Comment 3 QA Administrators 2018-08-10 02:38:34 UTC Comment hidden (obsolete)
Comment 4 m_a_riosv 2018-08-10 08:14:15 UTC
Still present
Version: 6.1.0.3 (x64)
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
TinderBox: Win-x86_64@62-TDF, Branch:libreoffice-6-1, Time: 2018-08-01_11:46:24
Locale: es-ES (es_ES); Calc: CL
Comment 5 QA Administrators 2019-08-19 06:55:42 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2021-08-19 03:43:58 UTC Comment hidden (obsolete)
Comment 7 BogdanB 2023-05-19 18:21:53 UTC
Still in
Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 8dfceb4e0b05b9d531e27e38b954f18e33091f8a
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded