Issue 102104

Summary: Several forms at same place
Product: Calc Reporter: mschoch <martin.schoch>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rainerbielefeld_ooo_qa
Version: OOo 3.1Keywords: needhelp
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Sample file for issue 102104 none

Description mschoch 2009-05-20 19:28:42 UTC 
In a spreadsheet imported from MS Excel format, certain check boxes will be
unchecked as a side effect when saving the document. The problem persists after
saving the document in .ods (Open Document) format, closing the document and
reloading from the .odf file.

Steps to reproduce:
1) Load document (will attach this ASAP to this report) with default security
settings.
2) In the rows that have the text "try to check box „3“ or „4“", check those boxes. 
3) Save the document.
4) Observe the state of the check boxes checked in 2). On my PC, those are
unchecked at this point.
5) Load the saved document. On my PC, the check boxes are unchecked after save
and reload.

Expected behavior:
Saving the document should NOT change the status of the check boxes. Instead,
the current state of the check boxes should be saved to disk and after reloading
the document, they should stll be checked.
Comment 1 mschoch 2009-05-20 19:29:28 UTC 
Created attachment 62397 [details]
Sample file for issue 102104
Comment 2 Rainer Bielefeld 2009-05-22 10:06:23 UTC 
You can see that there are 2 checkboxes at the same place: 
1. open "defective.ods"
2. use menu 'View -> Toolbars -> Form Design', 
3. switch 'Design Mode' on, 
4. click a checkbox (for example No. 3 in row 19) and drag it to an other place
   expected: check box at new place, old place empty
   actual:   check box at new place, old place still some check box No. 3

I am absolutely sure that I already left a comment in an issue just for this
EXCEL import problem, but currently I can not find that issue. Who can help?