Pasting calc info into writer

Discuss the word processor
Post Reply
jobsagooden
Posts: 9
Joined: Sat Jul 05, 2008 6:53 pm

Pasting calc info into writer

Post by jobsagooden »

I use calc for doing my invoices. When I want to print the envelop send the invoice of I select the cells containing the address copy and then paste into writer and print. Until recently, this has been fine, but now it doesn't work. The cells paste but there is no info in them!

Can anyone help?
OOo 2.4.X on Ms Windows XP
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: pasting calc info into writer

Post by Hagar Delest »

How do you paste? as DDE link? Calc8? Unformatted text? ...
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
jobsagooden
Posts: 9
Joined: Sat Jul 05, 2008 6:53 pm

Re: pasting calc info into writer

Post by jobsagooden »

I highlight cells, then copy switch to writer and paste, cells appear but no text. The text is formatted. Running OOo 2.4.1
OOo 2.4.X on Ms Windows XP
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: pasting calc info into writer

Post by Hagar Delest »

Can you upload your spreadsheet here?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
jobsagooden
Posts: 9
Joined: Sat Jul 05, 2008 6:53 pm

Re: pasting calc info into writer

Post by jobsagooden »

I can't put all my business financial details, my accountant doesn't even see the whole sheet!

I started a new document and did the same thing, and it worked perfectly. Also it seems to be a bit temperamental as it has work for one invoice not that long ago, but I try it now and it won't work.

I have just tried copying a whole invoice into new document and then trying and it works fine.

So can reset anything in old document or shall I just copy the sheets over?

Thank you very much for the help so far.

jobsa
OOo 2.4.X on Ms Windows XP
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: pasting calc info into writer

Post by Hagar Delest »

Difficult to say without seeing the file. Can't you save a copy of your file and remove all the data except few cells (replace information by dummy values)? Check that you can reproduce the issue with the remaining cells and upload it here.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
jobsagooden
Posts: 9
Joined: Sat Jul 05, 2008 6:53 pm

Re: pasting calc info into writer

Post by jobsagooden »

Here it is the heavily edited version. When I started to prepare it the first time I deleted the rows, but this then meant that it started to work!!! So the Invoice is down on row 154.

Thank you so much for your time.

James
Attachments
Master 2008 - 2009 b.ods
(11.3 KiB) Downloaded 196 times
OOo 2.4.X on Ms Windows XP
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: pasting calc info into writer

Post by Hagar Delest »

Strange indeed. I see that also with your file, the pasted cells are aligned on row 129 so you need to scroll down to make the data appear. Basically, you should paste as unformatted text, to avoid embedding a spreadsheet in the document if only the address is needed.

But the bug remains. I've not been able to reproduce that with a new spreadsheet. If nobody has any idea, you can try to file a bug report and upload your file, perhaps there is a deeper bug hidden behind: [Tutorial] Reporting bugs.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
jobsagooden
Posts: 9
Joined: Sat Jul 05, 2008 6:53 pm

Re: pasting calc info into writer

Post by jobsagooden »

Thank you for your help. I will wait and then report.

James
OOo 2.4.X on Ms Windows XP
jrkrideau
Volunteer
Posts: 3816
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: pasting calc info into writer

Post by jrkrideau »

jobsagooden wrote:Thank you for your help. I will wait and then report.

James
I appear to be duplicating Hagar's results. I cannot copy the data and paste it into a Writer document however a Paste Special > Unformatted text works. Also if I copy the data, paste it into a new spreadsheet and then copy that , it works fine when I paste into Writer.
LibreOffice 7.3.7. 2; Ubuntu 22.04
jobsagooden
Posts: 9
Joined: Sat Jul 05, 2008 6:53 pm

Re: pasting calc info into writer

Post by jobsagooden »

I have now reported this as an bug. (Issue number 91593)

James
OOo 2.4.X on Ms Windows XP
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: pasting calc info into writer

Post by Hagar Delest »

Don't forget to post the url so that users can jump to it directly: Issue 91593.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Post Reply