| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0030607 | Lazarus | LCL | public | 2016-09-16 22:20 | 2016-12-18 20:19 |
| Reporter | K155LA3 | Assigned To | Jesus Reyes | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | OS | Windows | OS Version | 7 | |
| Product Version | 1.7 (SVN) | Product Build | rev. 52982 | ||
| Target Version | 1.8 | Fixed in Version | 1.7 (SVN) | ||
| Summary | 0030607: TStringGrid empty cells does not replace cells with data when copy and paste one empty cell | ||||
| Description | If you copy one empty cell and paste it in cell with data, than empty cells does not replace cells with data. | ||||
| Steps To Reproduce | 1 Place StringGrid to form. 2 Set in Options goEditing. 3 Run programm. 4 Fill some cell with any data. 5 Select one empty cell and press Ctrl+C. 6 Place cursor on cell with data and press Ctrl+V 7 Nothing happens. | ||||
| Tags | No tags attached. | ||||
| Fixed in Revision | 52995 | ||||
| LazTarget | 1.8 | ||||
| Widgetset | |||||
| Attached Files |
| ||||
|
|
TSGBug3.gif (34,238 bytes) |
|
|
This is a regression introduced in r52352 |
|
|
I'm try to copy one empty cell from OpenOffice Calc and paste it in StringGrid. And it replace data in one cell. Clipboard is contained two bytes: 0000013#10 (Linebreak). Copied cells from OpenOffice Calc in clipboard always contain at the end the linebreak. If in procedure TCustomStringGrid.CopyCellRectToClipboard(const R: TRect), remove one condition: - if (R.Top <> R.Bottom) or (R.Left <> R.Right) then Then, when will copied some cells (or only one cell) to clipboard, "SelStr := SelStr + sLineBreak;" always will added line break at end, and all work fine. |
|
|
Yes, that is the regression. I already asked the author of the change about it, let see what he thinks about it. |
|
|
I see r52352 was a mistake from myself. You are right that both Calc and Excel add a line break even for one cell. (I personally hate this feature but this is not important :) ) r52352 should be reverted. Jesus, what about the line break? What is correct: # 13#10 or sLineBreak? Can you test Calc under Linux (I can't now). |
|
|
Fixed. @Ondrej: No problem with sLineBreak. |
|
|
I'm made some research with clipboad content from StringGrid and OO Calc. Found some problem with quote symbol: ". 1 Place StringGrid to form. 2 Set in Options goEditing. 3 Run programm. 4 Place symbol " in one cell When copy this cell procedure TCustomStringGrid.CopyCellRectToClipboard get string as " but after function QuoteText it will converted to """". When paste from clipboard to StringGrid it set cell data to ". When paste from clipboard to OO Calc it set cell data to "". When copy cell with " from OO Calc clipboard contained this data: "# 13#10 When paste from clipboard to StringGrid it clear cell data (make empty cell). When paste from clipboard to OO Calc it set cell data to ". If placed symbol "1" in cell, then: StringGrid -> clipboard = """1""" OO Calc -> clipboard = "1"# 13# 10 StringGrid -> OO Calc = ""1"" OO Calc -> StringGrid = 1 It is the known problem, or I can open new issue? |
|
|
Please submit a new report, if you can, please test also with excel if they doesn't behave the same I'm afraid we will have to choose one or the other. |
|
|
Open new issue 0030623: TStringGrid copy/paste to/from MS Excel and OO Calc bug: http://bugs.freepascal.org/view.php?id=30623 |
