Bug 95828

Summary:	Calculating
Product:	LibreOffice	Reporter:	Necip <necips>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	normal	CC:	ilmari.lauhakangas, miguelangelrv, raal
Priority:	medium
Version:	unspecified
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Calc error

Description Necip 2015-11-15 08:13:13 UTC

A B C D E
1 1 1 1 =A1&B1&C1&D1 

E should be 1111
but is showing still the formula A1&B1&C1&D1 



A B C D E
1 1 1   =A1&B1&C1 

E is in this case correctyl 111

Comment 1 raal 2015-11-15 08:33:56 UTC

I can not confirm with version 5.0.3.2 (x64), win7. Please test with version http://www.libreoffice.org/download/libreoffice-fresh/

Comment 2 Necip 2015-11-15 08:58:23 UTC

Created attachment 120548 [details]
Calc error

Comment 3 Necip 2015-11-15 08:58:42 UTC

(In reply to raal from comment #1)
> I can not confirm with version 5.0.3.2 (x64), win7. Please test with version
> http://www.libreoffice.org/download/libreoffice-fresh/


Error occures with the version 5.0.3

Comment 4 m_a_riosv 2015-11-15 15:43:42 UTC

Hi @Necip,

cells in column K are formatted as Text @, anything you enter in them is entered as text.
No problem with the existent cells because sure the format was applied after the formulas were entered.

For me not a bug.

Comment 5 Buovjaga 2015-11-15 18:25:14 UTC

Closing per comment 4.

Comment 6 Buovjaga 2015-11-16 15:19:00 UTC

Even after changing K4 away from text, the formula was still showing. I had to cut it away, accept, paste it in and then ctrl-m remove the weird formatting.

Comment 7 m_a_riosv 2015-11-16 19:17:02 UTC

You never can change cell's content, changing the format. (I hope)

After reset the format, you can use the Menu/Data/Text to column to get the formula working properly.