RE: Take a cell value from a spreadsheet into another
At 13:19 16/11/2022 +0200, Amin Jack Pedziwiater wrote: 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. Isn't this roughly the opposite of the real situation? Some office suites are indeed collections of separate programs. Microsoft may present its collection of Word, Excel, Powerpoint, and so on as "Microsoft Office", but they are still separate programs. (If you don't believe me, try opening a spreadsheet document from within Word. It won't open in Excel.) But OpenOffice is an integrated package, and when you have it open, you can open documents of various types - text, spreadsheet, presentation - within it. And, contrary to what you say, you can transfer or link results from one type of document to another. If there is any difference in this matter between commercial and open source software, it is surely the reverse of what you suggest? Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Take a cell value from a spreadsheet into another
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 > 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
Re: Take a cell value from a spreadsheet into another
Hi Richard, Richard Gill schrieb am 16.11.2022 um 10:23: 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? 1. Make sure source and target file are already saved. 2. Open source and target file. 3. Write = in the cell in the target file. 4. Click on the cell in the source file. 5. Go back to the target file. You should have got something like this in the formula bar: ='file:///D:/Desktop/KannwegSource.ods'#$Sheet1.A4 The cell itself will show the result. When the source changes, you can go to Edit > Links, select the corresponding entry and click on Update button. Of course you can write the formula manually too. Notice, that URL is absolute. So you need to change the formula when moving the source file. Or you can try function DDE. For syntax see help. But I cannot get it to update, at least not as array function for a range, so there might be something broken with DDE. Kind regards, Regina - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
RE: Take a cell value from a spreadsheet into another
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
Re: Take a cell value from a spreadsheet into another
For context see https://forum.openoffice.org/en/forum/viewtopic.php?t=108886 On 16/11/2022 19:53, Richard Gill wrote: 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