Issue 123533 - Particular .XLS: Status-Bar-SUM shows double value
Summary: Particular .XLS: Status-Bar-SUM shows double value
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.1.0-dev
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-10-23 11:37 UTC by briangraaf
Modified: 2013-10-23 13:24 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
example file with buggy cells (137.50 KB, application/vnd.ms-excel)
2013-10-23 11:37 UTC, briangraaf
no flags Details
Screenshot (56.54 KB, image/png)
2013-10-23 13:00 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description briangraaf 2013-10-23 11:37:45 UTC
Created attachment 81801 [details]
example file with buggy cells

This is a bug which appears every now en than in random cells, which makes it hard to reproduce from scratch. I have included a xls file which has the bug inside it. I have opened this file in windows XP (x86) and Windows 7 (x64) and a mac OSX 10.8 system. 

When I enter a number in a cell, for example number 7,6 in the included file in cell C4 the value of the number automatically doubles in the sum displayed. You can put any number you want in that cell, it will automatically double in value in the displayed sum. Same happens with the cells that has numbers on sheet 1.

The only way to fix this, is by switching to sheet 3 , click on the mouse button on a random empty cell in this third sheet and than switch back to the sheet with the buggy cells (sheet 1 and sheet 2). Then it suddenly displays the right number in the sum.

Please take a look at the included file in cell c4 on sheet 2 to reproduce this bug.
Comment 1 Rainer Bielefeld 2013-10-23 13:00:01 UTC
Created attachment 81802 [details]
Screenshot

Reproducible with reporter's sample and  "AOO 4.1.0-Dev – English  UI / German locale - [AOO410m1(Build:9750)  -  Rev. 1534248 - 2013-10-22]" on German WIN7 Home
Premium (64bit)", own separate user profile:

Open Document and click C4
Expected: Status Bar Sum field shows cell value  7,6
Actual:   Status Bar Sum field shows cell value 15,2

some more research required
Comment 2 Rainer Bielefeld 2013-10-23 13:24:10 UTC
Some Additional info:
---------------------
(a) already reproducible with OO 2.0.3 and OOo 1.1.5
(b) not a problem with SoftMaker FreeOffice
(c) all the same with LibO 4.2