Issue 82894

Summary: Incorrect values displayed
Product: Calc Reporter: drc <drc>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: cs233179, issues, rb.henschel
Version: OOo 2.3Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Archive of data file and screen shots
none
another example of the problem none

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)