You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Richard Gill <ri...@gmail.com> on 2022/11/16 09:23:09 UTC
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
Re: Take a cell value from a spreadsheet into another
Posted by PCS <pe...@bigpond.com>.
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 <am...@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.gill1954@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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
RE: Take a cell value from a spreadsheet into another
Posted by Brian Barker <b....@btinternet.com.INVALID>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
RE: Take a cell value from a spreadsheet into another
Posted by Amin Jack P©dziwiater <am...@aol.com.INVALID>.
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.gill1954@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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Take a cell value from a spreadsheet into another
Posted by David Robley <da...@robley.net.au>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Take a cell value from a spreadsheet into another
Posted by Regina Henschel <rb...@t-online.de>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org