Dear Richard,
I think you will find that if you copy the cell in the original spreadsheet normally, then in the spreadsheet you want to paste the information into use the Paste Special command in the Edit Menu instead of doing a standard paste, and in the window that opens select what you want to be pasted, e.g. in this case (if I have correctly understood) “Paste Value”, or maybe it’s “Paste Number”, I’m going from memory here, and I’m currently using LO, and OO and LO do it a little differently, so the details may not be exactly as I have outlined, but the fundamental is to use Paste Special instead of a normal paste. And it is not limited to copying single cells, you can copy a selected group of cells. This works not only between OpenOffice spreadsheets and between OpenOffice and LibreOffice, I also routinely paste data from Google Sheets to OO or LO using Paste Special to get it from another person’s Android phone to my records. If I’ve understood your problem correctly I think this should solve your problem. Peter. > On 16 Nov 2022, at 9:19 pm, Amin Jack P©dziwiater > <aminanima...@aol.com.INVALID> wrote: > > Dearer Sir > You struggling because you misunderstand the OO Suite's construction. There > are the different programs with different engines to do different functions > for create and manage different forms of documentation within one compatible > System itself. Results of formulas are counted and displayed only on > subprograms they created. That's idea of open source software. I seem, I > cannot help you with your problem anymore. > A.J.P. > > -----Original Message----- > From: Richard Gill [mailto:richard.gill1...@gmail.com] > Sent: Wednesday, November 16, 2022 11:23 AM > To: users@openoffice.apache.org > Subject: Take a cell value from a spreadsheet into another > > Dear Sir > > I am struggling to find a way to display the results of a formula when > editing into a different document. It picks up the formatting, but not the > results. > > Can you help please? > > Richard Gill > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
