Issue 54850 - Dragging alphanumeric data clips if numeric part >~ 2^31
Summary: Dragging alphanumeric data clips if numeric part >~ 2^31
Status: CLOSED DUPLICATE of issue 3488
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO 2.0 Beta2
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-09-20 12:01 UTC by midg3t
Modified: 2005-09-20 20:08 UTC (History)
1 user (show)

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


Attachments
Demonstration (17.03 KB, application/vnd.oasis.opendocument.spreadsheet)
2005-09-20 12:03 UTC, midg3t
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description midg3t 2005-09-20 12:01:43 UTC
Discovered this with OpenOffice.org 2 beta 2 on Windows XP and Debian GNU/Linux.
Enter a value with an alphabetic part and a numeric part such as
"AC711111111111" into a cell, then copy it to the one below. Select both cells
and drag the handle to the cells below. This should copy the same value to the
cells below, but if the numeric part of the value is greater than about 2^31,
data is clipped.

I found that the problem occurs with numeric parts with values 2^31 and over.
Interestingly 2^31 - 1 behaves specially, such that dragging to duplicate the
columns' values causes all but the first cell to be cleared!

The columns do not have a particular format set, however when the format is set
to "Text" (format string of "@"), the problem does not manifest.

I will attach a file demonstrating the problem.
Comment 1 midg3t 2005-09-20 12:03:05 UTC
Created attachment 29706 [details]
Demonstration
Comment 2 ooo 2005-09-20 20:07:50 UTC
Duplicate.

*** This issue has been marked as a duplicate of 3488 ***
Comment 3 ooo 2005-09-20 20:08:13 UTC
Closing dup.