Bug 95828 - Calculating
Summary: Calculating
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-11-15 08:13 UTC by Necip
Modified: 2015-11-16 19:17 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Calc error (38.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-11-15 08:58 UTC, Necip 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.