https://bz.apache.org/ooo/show_bug.cgi?id=125717
Sergiusz Golec <gros...@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gros...@gmail.com --- Comment #8 from Sergiusz Golec <gros...@gmail.com> --- Created attachment 86003 --> https://bz.apache.org/ooo/attachment.cgi?id=86003&action=edit Screenshots Extra (End Of Line / newline / paragraph) character is added in OO Writer, when user inserts a cell from the OO Calc. I was able to reproduce the issue, both with copied Cell and the Table. And I discovered something new, including: * Selected cell is not replaced when we paste (via Ctrl+v) the new cell. We have to delete the selected cell 1st, or paste a new cell in a different place (and delete original cell). Which is a potential for the effort optimisation. * ODS ('OO Calc') cells are pasted in an ODT (OO Writer), via Ctrl+c/v, as an embedded Calc software. Not as a plain text. Or a table. (Alike from Google Docs Spreadsheet.) * Copied "Calc cell" from Writer, into a Calc (into a different cell) - are pasted in an ODS (OO Calc) as an embedded Calc software. It's like Calc within a Calc. Which makes little to no sense for 1 cell. * Copy paste a cell (text) or a table from Writer into Calc, results in an extra issue with a typeface identification - Calc is not showing the font name. Even if it displays the content, formatted as per the original source in a Writer. Tests:: Test 1 - reproduction of steps mentioned by Bugzill Apatcheer (in a post from 2014-10-08 00:36:20 UTC). I confirm - I have the same outcome. The same problem is observed: Extra (End Of Line / paragraph) character is added in OO Writer, when user inserts a cell from OO Calc. (Plsease reffer to Bugzill Apatcheer steps from the mentioned post, when needed.) Test 2 - In ODT (Writer) try to replace 1 ODS (Calc) cell with another ODS (Calc) cell. 1. Copy cell A1 (with 'aa' text) from Figs.ODS (Calc) into Figs.ODT (Writer) \ 'Figa' frame. Via Ctrl+c/v. 2. Select new cell 'aa' in ODT (Writer). 3. Copy cell B1 ('bb') from Figs.ODS (Calc) into Figs.ODT (Writer) \ 'Figa' frame \ cell 'aa'. Via Ctrl+c/v. Result - the cell is not replaced. 4. I set a new place in the ODT (Writer) document - so the 'aa' cell was not selected. And with ctrl+v, I was able to paste the B1 'bb' cell. (From the same memory buffer.) Test 3 - ODS ('OO Calc') cells as an embedded software in a Writer. 5. Double click the newly inserted cell 'aa' in ODT (Writer). Result: ODS (Calc) document loads within the ODT (Writer) as an embedded 'OO Calc' software. Note: a) Copied table (2 columns x 3 rows) from ODS (Calc) into ODT - results in one extra paragraph in a Writer. b) Copied cell from ODS into Notepad++ - results in one extra paragraph in Notepad++. c) Copied table (2 columns x 3 rows) from ODS into Notepad++ - results in one extra paragraph in a Notepad++. Test 4 - compare Calc with Google Docs Spreadsheet (GDS) 6. Open online GDS. Copy cell with 'Q' text. And paste it into ODT document. Result: 'Q ' is shown in ODT document. 7. Copy (GDS) cell with "A" text. Paste in ODT - it results in "A ". Same text with extra space sign ' ' at the end. 8. Copy (GDS) cell with "Blah-blah" text. And in ODT it becomes "Blah-blah ". Same text with extra space sign ' ' at the end. Result: Single cells copied from Google GDS and pasted in ODT - results in an extra space ' ' at the end of the cell text. Single cells copied from OO ODS and pasted in ODT - results in an extra paragraph (end of line / newline sign) Test 5 - Repeat test 4 for "3 columns x 2 rows" table (with every cell filled with 1 text letter "A, B, C, D, E, F") Result: In ODT a new table is pasted. The only change observed is that transparent table border in GDS becomes not transparent in ODT. Yet it's shown as a table. And not as an embedded application (with table). Test 6 - Embed Calc within Calc by copying "Calc cell" from the Writer. 1. Make sure that in the ODT document there is A1 ('aa') cell pasted from ODS document. ODT with embedded Calc is available. 2. Select 'aa' cell in ODT document and press Ctrl+C (copy). 3. In the OO Calc, paste the memory buffer via Ctrl+V. (In a free space / empty cell). Result: The copied cell, in Calc has an extra green border. 4. Double click the new cell. Result: In Calc, the embedded Calc is loaded. Expected result: Cell (from Calc) is copied as a Cell. And not as an embedded Calc. Note: There might be a potential for a bigger issue here. If we embed one Calc into another. And repeat the same several times. Alike Folder 10 in Folder 9, which is in Folder 8, which is in Folder 7, etc. Test 7 - Table from Writer (originally GDS) copy into Calc. And check the fonts. 1. Copy table (3columns x 2 rows) from ODT (originally copied from GDS) into the ODS (Calc). Result: The table is copied (with not transparent borders). ODS (Calc) - shows empty Font and Size of the copied text in the table. When ODT shows "Times New Roman;12". When in Calc, in a new cell, I've entered the same text and formatted it as "Times New Roman;12" - I could not see the difference between the cells (except the empty font from a copied table from ODT). OO 4.2.0. AOO420m1(Build:9800) - Rev. 1785175 Windows 7 Professional Edition (64-bit) Service Pack 1 (Build 7601) 2017-04-13 10:41 CET -- You are receiving this mail because: You are the assignee for the issue.