Description:
In attached CALC file I made some classical copy+paste and then replicated a format from existing cells to the newly created cells (including merged cells E30:E32 and G30:G32). After these operations, CALC displays a correct value in the merged cells (in E32 and G32), but also displays an incorrect value resulting from another calculus in the same place, making the result un-readable (and of course incorrect). In "Steps to reproduce" I only write about E30:E32 since the problem is the same for G30:G32.

Steps to Reproduce:
1.Look at E30:E32 and see that the result displayed is un-readable
2.Click on single cell E30 or E31: the formula is the good one (=average of D30:D32)and 3 merged cells selected at the same time
3.Click on E32: the formula is shifted to other cells, and only E32 is selected

Actual Results:
explained yet

Expected Results:
When clicking E30,E31 or E32 equally, all 3 merged cells E30:E32 should be selected, and only 1 correct formula sould be shown.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version : 6.4.6.2 (x64)
Build ID : 0ce51a4fd21bff07a5c061082cc82c5ed232f115
Threads CPU : 2; OS : Windows 6.1 Service Pack 1 Build 7601; UI Render : par défaut; VCL: win; 
Locale : fr-FR (fr_FR); Langue IHM : fr-FR
Calc: threaded