Issue 101968 - text values in data range cause incorrect x values
Summary: text values in data range cause incorrect x values
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: sgautier.ooo
QA Contact: issues@graphics
URL:
Keywords: oooqa, regression
: 103949 (view as issue list)
Depends on:
Blocks:
 
Reported: 2009-05-15 17:02 UTC by Joe Smith
Modified: 2013-02-24 21:19 UTC (History)
3 users (show)

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

Attachments
sample document showing problem (57.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-15 17:03 UTC, Joe Smith 		no flags Details
screenshots illustrating wrong and correct display (29.48 KB, image/jpeg)
2009-07-01 12:40 UTC, IngridvdM 		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 Joe Smith 2009-05-15 17:02:57 UTC 
Text values in a data range can be misinterpreted, causing the automatic axis
range to be determined incorrectly, and the axis mislabeled.

See the attached spreadsheet and chart for an example.
Comment 1 Joe Smith 2009-05-15 17:03:45 UTC 
Created attachment 62296 [details]
sample document showing problem
Comment 2 Regina Henschel 2009-05-15 22:14:57 UTC 
If there is a text row between, then the whole x-value column is ignored and the
ersatz values 1,2,3,4... are used. That is wrong. Cells with text should be
treated as if they are empty as it has been till OOo3.0.1.
Comment 3 IngridvdM 2009-05-19 14:06:20 UTC 
I fear this was broken by fix for issue 71686.
@weiz, please have a look.
Comment 4 IngridvdM 2009-06-25 09:41:57 UTC 
weiz, as discussed in our weekly IRC chat I take back this issue for fixing.
Comment 5 IngridvdM 2009-06-25 09:47:03 UTC 
Fixed in CWS chart39. Now ersatz values 1,2,3,4... are only used for x-values in
case that no numeric value but at least one text is contained within the x-value
range.
Comment 6 IngridvdM 2009-07-01 12:40:49 UTC 
Created attachment 63303 [details]
screenshots illustrating wrong and correct display
Comment 7 IngridvdM 2009-07-01 12:44:28 UTC 
@Sophie, please verify in CWS chart39. Thanks, Ingrid!
Load the attached document Chart_text_values.ods and double click the chart. It
should look like illustrated within attached Screenshots.jpg.
Comment 8 sgautier.ooo 2009-07-02 11:41:27 UTC 
Verified in CWS chart39 - data are displayed correctly after editing. Sophie
Comment 9 IngridvdM 2009-08-04 14:13:29 UTC 
*** Issue 103949 has been marked as a duplicate of this issue. ***
Comment 10 sgautier.ooo 2009-08-05 13:43:27 UTC 
Verified in DEV300m54 under .deb version - Closing - Sophie
Comment 11 Joe Smith 2009-08-05 22:24:12 UTC 
Testing DEV300_m54 on Fedora Linux 11:

Sample document works correctly: graph has correct X scale when x-value cells
A21:A22 are empty, contain text, or contain =NA() ("#NA") as in dup Issue
103949. Other errors (including #DIV/0) are ignored also.

Looks great--thanks!