https://bz.apache.org/ooo/show_bug.cgi?id=125717
Sergiusz Golec changed:
What|Removed |Added
CC||gros...@gmail.com
--- Comment #8 from Sergiusz Golec ---
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
