Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | [From Symphony]Text outside quotation cannot be paste in cell | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | Yan Ji <yanji.yj> | ||||||||
Component: | editing | Assignee: | Andre <awf.aoo> | ||||||||
Status: | CLOSED FIXED | QA Contact: | |||||||||
Severity: | Major | ||||||||||
Priority: | P3 | CC: | aoo.zhaoshzh, awf.aoo, binbjguo, jingbaibetsy, liushenf | ||||||||
Version: | 3.4.0 | ||||||||||
Target Milestone: | 4.0.0 | ||||||||||
Hardware: | PC | ||||||||||
OS: | All | ||||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||
Developer Difficulty: | --- | ||||||||||
Issue Depends on: | |||||||||||
Issue Blocks: | 120823 | ||||||||||
Attachments: |
|
I am investigating this issue. Code patch will be uploaded immediately. Created attachment 78266 [details]
patch for paste issue
when paste the pure text content to a spreadsheet cell, it only inserts the string in the "",but other string is removed. for example, if the content is like "Shape Properties of Dimension Line" context menu is missing in SW. paste it to a cell, only "Shape Properties of Dimension Line" was pasted. in the file of \main\sc\source\ui\docshell\impex.cxx in the function of sal_Bool ScImportExport::Text2Doc( SvStream& rStrm ) only the string between "" is inserted in a cell, so just append the left string in the cell. I can not reproduce this bug with a current developer version: I load the bug doc. From the resulting text document I select the while fourth line (the first that starts with "Shape Properties), press Ctrl-C, open a new Calc document and press Ctrl-V. The whole line is pasted into the first cell. Created attachment 78281 [details]
record of my operation
It can be reproduced at the revision of 1303653. I recorded my operation in a file named "",you can find it in the attachment. @zhaoshzh: Sorry for the delay. Your video did help. I learned from it that the text file has to be loaded into a text editor, not OpenOffice Writer. When I copy one line of text from my Emacs and paste it into a new Calc document then the text outside the quotes is not copied. I have on question regarding your patch (please take into account that I do not know much about the implementation of Calc). The original code looks like doing a special handling of quotes so that fields separators (, or ;) are correctly located and that this seems to fail. Can you verify this hypothesis? Assigning this issue to me, so that it does not get lost. Looked some more into this. First, the default field separator is TAB. I still think that the code should handle quoted separators (ie separators inside a quoted text range) by ignoring them. Unquoted separators start a new cell. It just does not work. Without the patch, text inside quotes is ignored completely. With the patch the separators always start a new cell, even when quoted. But maybe I am wrong. @zhaoshzh: Do you know what the intended behavior is? I do other tests for this issue. If the separator char of TAB in the string, copy the string,and paste it in a cell,AOO will start new cells by the TAB char. This is correct behavior. If only quotes chars exists, copy the string and paste it in a cell, the quotes char should be removed,the the all string should be pasted in the cell. Comment on attachment 78266 [details] patch for paste issue Reviewed and commited in SVN revision 1352479. I took the liberty to remove the commented out code. For reference it is still available in SVN. Setting status to fixed. Verified on latest AOO Trunk 0817 build on Window OS/Linux OS/Linux 64bit OS, this bug is fixed.Text outside quotation can be pasted in cell in AOO. set Target Milestone to AOO 3.5.0 for PM purpose. |
Created attachment 78254 [details] sample Build: AOO3.4 Steps: 1. Open attached sampl file 2. Select one line to copy 3. New Spreadsheet document 4. Pate text into cell Defect: Text outside of quotation cannot be pasted