24499 – TRANSPOSE, FREQUENCY and saving/loading results to broken formulas

Issue 24499 - TRANSPOSE, FREQUENCY and saving/loading results to broken formulas

Summary: TRANSPOSE, FREQUENCY and saving/loading results to broken formulas

Status:	CLOSED DUPLICATE of issue 21716

Alias:	None

Product:	Calc
Classification:	Application
Component:	ui (show other issues)
Version:	OOo 1.1
Hardware:	PC Linux, all

Importance:	P3 Trivial (vote)
Target Milestone:	---
Assignee:	spreadsheet
QA Contact:	issues@sc

URL:
Keywords:

Depends on:
Blocks:

Reported:	2004-01-17 16:43 UTC by corev
Modified:	2004-01-19 09:47 UTC (History)
CC List:	1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.

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