Issue 82894 - Incorrect values displayed
Summary: Incorrect values displayed
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-10-23 16:58 UTC by drc
Modified: 2013-02-07 22:36 UTC (History)
3 users (show)

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

Attachments
Archive of data file and screen shots (520.42 KB, application/x-gzip)
2007-10-23 16:59 UTC, drc 		no flags Details
another example of the problem (54.31 KB, image/png)
2008-02-05 05:38 UTC, plouj 		no flags Details
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 drc 2007-10-23 16:58:04 UTC 
OOo 2.3.0 Calc on Ubuntu 0710 Gutsy Gibbon,  

Screenshot 1:
Column A shows some calculated coefficients.  A3:A5 are disp[ayed values from R3:R5
A6 is the 'Paste Special' value of A3 - the same value but not from a referenced
cell.

Screenshot 2:
The width of column A has been reduced.  Utterly wrong values are displayed in
A4:A5, admittedly with warning flags. This contrasts with the much safer policy
displayed in the R column.

Screenshot 3: 
On further narrowing the column, it is apparent that the source of the value is
not relevant.  In A3 the source is the content of R3.  In A6 the value is stored
directly.

Screenshot 4:
After saving the data file for this report, I reloaded it to confirm it shows
the problem.  After saving and reloading I get this different display, which
nicely shows where the erroneous values are coming from.

Recommendation:
Either 'Optimal Height' should be dynamically applied as values change, or the
value should be hashed out if the current cell size cannot accommodate it.  If
these are not viable short term solutions, showing just the first line rather
than the last line of the wrapped answer (with the warning flag) would be a big
improvement.
Comment 1 drc 2007-10-23 16:59:49 UTC 
Created attachment 49092 [details]
Archive of data file and screen shots
Comment 2 plouj 2008-02-05 05:35:01 UTC 
I can reproduce this in openoffice.org-2.3.0-6.11.fc8 Calc on Fedora 8.
Moreover, on further reduction of the A column I noticed that calc wasn't
showing the last digits of the number but instead it showed digits around the
decimal point (see A3 and A6 in the column-a-further-reduced.png screenshot).
Comment 3 plouj 2008-02-05 05:38:55 UTC 
Created attachment 51370 [details]
another example of the problem
Comment 4 Regina Henschel 2008-07-14 18:41:24 UTC 
I use German OOoDev300_m24 on WinXP.

The problems are as described. But issue type is not 'defect', but
'enhancement'. Handling of row height needs improvement.
Comment 5 drc 2008-07-14 20:44:49 UTC 
Technically it is an enhancement.  The spreadsheet does not give incorrect
answers, it just shows the wrong bit of the correct answer.

But the poor user could be forgiven for not really appreciating this subtle
difference if (s)he trusts and uses the answer seen ...
Comment 6 oc 2008-07-15 10:43:55 UTC 
reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)