Issue 24499

Summary:	TRANSPOSE, FREQUENCY and saving/loading results to broken formulas
Product:	Calc	Reporter:	corev <sebastian.hesselbarth>
Component:	ui	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description corev 2004-01-17 16:43:16 UTC

Hi,

I guess I discovered a bug in OOo 1.1 Calc:

I want to count occurencies of certain numbers in an array of cells and 
used FREQUENCY for that. Because the resulting Array is spread over rows 
but I need them displayed over columns I choose TRANSPOSE for this.
The functions really work fine and everything is displayed and 
calculated as it should but after save and reload the formula is broken:
- working formula is only in cell0 of the array and the other cells are 
filled with the constants of the calculation before saving
- editing the formula is impossible because the formula is only in one 
cell but OOo wants me to select _all_ cells of the array function but 
they are not accessible anymore
- deleting the other cells of the former array function is possible
- deleting the whole column is possible

I guess the bug occurs when the sxc document is loaded and so the 
formula is not associated to the right cells or it occurs already while 
saving.
I can send you the sxc if you want and please cc me when answering on 
this mail because I am not on any list.

Comment 1 corev 2004-01-17 16:55:45 UTC

Status changed to NEW since I can confirm and reproduce it.

Comment 2 corev 2004-01-17 17:31:38 UTC

Possible Workaround:
Calculate the FREQUENCY values by substracting all former values :

Assuming you want to get frequency counts for values 0-3 (integer) in an area
from A1 to A9 and want to avoid an array function for the results (in B1:E1) use
this:

formula for cell containing count of 0's (B1) : =FREQUENCY(A1:A9;0)
formula for cell containing count of 1's (C1) : =FREQUENCY(A1:A9;1)-B1
formula for cell containing count of 2's (D1) : =FREQUENCY(A1:A9;2)-B1-B2
formula for cell containing count of 3's (E1) : =FREQUENCY(A1:A9;3)-B1-B2-B3

and so on.

Status: Works for me!

Comment 3 frank 2004-01-19 09:47:02 UTC

Hi,

this is a double to Issue 21716 and therefore fixed in OOo1.1.1

Frank

*** This issue has been marked as a duplicate of 21716 ***

Comment 4 frank 2004-01-19 09:47:27 UTC

closed double