Bug 612265

Summary: OOo Calc does not keep the styles inside a text of a pasted cell after a "Paste Special"'s link operation.
Product: [openSUSE] openSUSE 11.2 Reporter: Rainer Hurtado Navarro <publio.escipion.el.africano>
Component: OpenOffice.orgAssignee: Kohei Yoshida <kyoshida>
Status: RESOLVED WONTFIX QA Contact: Chao Wei <cwei>
Severity: Normal    
Priority: P3 - Medium CC: nopower, pmladek
Version: Final   
Target Milestone: ---   
Hardware: x86-64   
OS: openSUSE 11.2   
Whiteboard:
Found By: --- Services Priority:
Business Priority: Blocker: ---
Marketing QA Status: --- IT Deployment: ---
Attachments: Sample OOo Calc file illustrating this issue

Description Rainer Hurtado Navarro 2010-06-07 18:33:58 UTC
User-Agent:       Mozilla/5.0 (X11; U; Linux x86_64; es-ES; rv:1.9.1.9) Gecko/20100317 SUSE/3.5.9-0.1.1 Firefox/3.5.9

openSuSE 11.2 x86_64 Final DVD plus Updates.
OOo Calc does not keep the styles inside a text of a pasted cell after a "Paste Special"'s link operation.
For instance, a cell (or many) has a text which is in italics, partially o completely.
Copy the cell (or the many of them).
Paste it special with option link chosen.
The pasted cell will reflect the first one, in its contents and in its changes (good!), but not in styles.
That is all.

Reproducible: Always

Steps to Reproduce:
1.copy a cell
2.paste it special with option link
3.
Actual Results:  
The pasted cell will reflect the first one, in its contents and in its changes (good!), but not in styles.

Expected Results:  
The pasted cell would reflect the first one, in its contents and in its changes (good!), and in its styles.
Comment 1 Rainer Hurtado Navarro 2010-06-07 21:54:31 UTC
Sorry, however, because I assumed that you knew it is about the recent release of OOo from OBS.
For the record, it is:
OpenOffice.org 3.2.1 
OOO320m19 (Build:9505)
ooo-build 3.2.1.3
Comment 2 Petr Mladek 2010-06-11 15:56:52 UTC
Hmm, I am not able to reproduce it here (the formating is copied).

Rainer, could you please provide more information?


1. How do you exactly copy the cell? Using [Ctrl-C] or menu "Edit/Copy" or ?

2. Do you use KDE3 or KDE4?

3. Do you do any operations with the KDE klipper between the copy and paste 
   operations?

4. Does it help you to modify the KDE clipper setting? Especially, the settings:
   "Text selection only", "Synchronize contents of the clipboard and the 
   selection?

5. Does it happen when you run OOo in another Window manager?
Comment 3 Rainer Hurtado Navarro 2010-06-12 01:06:52 UTC
Well, perhaps you are copying and pasting with format [RTF] using the standard toolbar. I, indeed, want that the pasting be formated, but also linked, so the changes of the original sample be mirrored in any place I have pasted it.
I uses both Ctrl-C and icons everywhere (Edit menu, standard toolbar, contextual menu) but I need to paste through menus, because I need special pasting functions nor available through Crtl-V.
This issue takes place under KDE 4 (updated) and under Gnome (updated). Although I dislike many aspects of KDE 4, I have not installed KDE 3.
I will attach an OOo Calc document that details everything: several Klipper configurations bound to Paste Special > Link and Paste > DDE Link (although I am not interested on this second one, because I need to link inside the same document not between documents, I let this here for example). Different Klipper settings do not affect the result.
Please, If asked to update it, do not. If you did it, the DDE Links will fail (there is no "Sin nombre1", because I was working with OOo + java-1_6_0-openjdk-1.6.0.0_b17-2.1.1 and I had the issue Bug 601243, and, as I did not want to loose my work, including this sample spreadsheet, I downgraded java without closing OOo, and so I could save my work (texts and spreadsheets), but there was no way to save that "Sin nombre1").
Also, I have noticed something else: the new OpenOffice.org 3.2.1 / OOO320m19 (Build:9505) / ooo-build 3.2.1.3 from OBS saves the files without extension (there is no .odt, .ods, & c).
Comment 4 Rainer Hurtado Navarro 2010-06-12 01:08:09 UTC
Created attachment 368824 [details]
Sample OOo Calc file illustrating this issue
Comment 5 Radek Doulik 2010-06-15 09:53:45 UTC
I think this one is for Kohei then.
Comment 6 Kohei Yoshida 2010-11-10 14:00:29 UTC
This is a known limitation.  When pasting a link, it pastes a reference to the original cell.  And a reference can only carry over raw value, not its format.

When the whole cell is italic, we can apply that to the cell attribute to replicate the italic format. But when only a part of the content is italic, we can't apply that to the cell attribute, hence we can't replicate it in the pasted cell.

BTW Excel appears to have the same limitation there.
Comment 7 Kohei Yoshida 2013-01-25 22:52:29 UTC
I'm afraid we can't fix this.  Linked cells are formula expressions, and formula expressions cannot carry over formatting properties.