Issue 88072 - Data validity "list" will be changed to "cell range" if input a long string as a list item
Summary: Data validity "list" will be changed to "cell range" if input a long string a...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-04-09 04:40 UTC by jiamingf
Modified: 2013-01-29 21:47 UTC (History)
2 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description jiamingf 2008-04-09 04:40:16 UTC
The defect PD steps:

1. Open file menu: data->validity, and popup the validity dialog;
2. Select allow "List" in the combbox, and input several items in 
the "Entries", e.g. 
item1,item2,1234567812345678123456781234567812345678123456781234567812345678123
4567812345678123456781234567812345678123456781234567812345678123456781234567812
3456781234567812345678123456781234567812345678123456781234567812345678123456781
2345678123456781234567812345678. The third item length is more than 254.
3. Click "OK" button to close the dialog;
4. Cursor in the cell and reopen the validity dialog;
5. Now the dialog is changed to allow "cell range" in the combbox, and the 
source is changed to "item1","item2" 
and "34567812345678123456781234567812345678123456781234567812345678123456781234
5678123456781234567812345678123456781234567812345678123456781234567812345678123
4567812345678123456781234567812345678123456781234567812345678123456781234567812
3456781234567812345678". The beginning 2 characters "12" of the third item is 
cut, and the length is changed to 254.
Comment 1 amy2008 2008-08-26 08:04:28 UTC
Checked in OOo300_m3_EN on WinXP.
The reproducible steps is same, but the result differs.

Follow your steps, I find the third item is 
“123456781234567812345678123456781234567812345678123456781234567812345678123456
7812345678123456781234567812345678123456781234567812345678123456781234567812345
6781234567812345678123456781234567812345678123456781234567812345678123456781234
567812345678123456  (pay attention to the double quotation marks)
but not
1234567812345678123456781234567812345678123456781234567812345678123
4567812345678123456781234567812345678123456781234567812345678123456781234567812
3456781234567812345678123456781234567812345678123456781234567812345678123456781
2345678123456781234567812345678.