Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-31 Thread Stefan Weigel 
Am 31.10.2011 10:08, schrieb Stephan Zietsman:

> I just wanted to mention an alternative.

which I find generally interesting, because I didn´t think of the
way you mentioned, at all. And for a single cell your alternative is
faster, I think.

Stefan
:-)


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-31 Thread Stephan Zietsman 
Stefan Weigel wrote:
> Am 31.10.2011 08:26, schrieb Stephan Zietsman:
>> Select the relevant cell and click in the formula bar.  Press F9 (the
>> default short-cut for recalculate) followed by ENTER.  This should
>> replace the formula with the result.
>
> This will work for a single cell, but will take you very long for a
> whole column. ;-)

Good point.  Using Paste Special method would work better in that
case.  As a side note, I think the Paste Special method is more
intuitive (in general); I just wanted to mention an alternative.

Regards
Stephan

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-31 Thread Stefan Weigel 
Hi,

Am 31.10.2011 08:26, schrieb Stephan Zietsman:

> Rich Shepard wrote:

>>  I have a column where the cells display the sum of two other columns. I
>> want to change the contents from formula to value but cannot find the
>> relevant information in the help pages. Please point me to instructions on
>> how to do this.

> Select the relevant cell and click in the formula bar.  Press F9 (the
> default short-cut for recalculate) followed by ENTER.  This should
> replace the formula with the result.

This will work for a single cell, but will take you very long for a
whole column. ;-)

Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-31 Thread Stephan Zietsman 
Rich Shepard wrote:
>  I have a column where the cells display the sum of two other columns. I
> want to change the contents from formula to value but cannot find the
> relevant information in the help pages. Please point me to instructions on
> how to do this.

Select the relevant cell and click in the formula bar.  Press F9 (the
default short-cut for recalculate) followed by ENTER.  This should
replace the formula with the result.

Regards
Stephan

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-29 Thread The Wolfkin 
That was actually more of a restatement of your problem then an attempt at a
solution. But the previous supplied answer of "Paste Special" with only
"Numbers" checked did work. If you do that you can delete B5 and C5 and keep
the 80.

if you're still having trouble perhaps a screenshot would help assuming this
isn't confidential work?

-- 
I love gmail. Do you?
The Wolfkin


On Sat, Oct 29, 2011 at 9:20 AM, Rich Shepard wrote:

> On Fri, 28 Oct 2011, The Wolfkin wrote:
>
>  So if I'm understanding you're trying to say start out with cells..
>> input a formula like this
>> http://minus.com/lgIwyrkPUPHj7
>> which gives a solution like this
>> http://minus.com/l50sfqIxwhBlz
>>
>> and then now change the contents of cell D5 from {=B5+C5} to {80}
>> so that you can delete the contents of B5 an C5 yet keep the 80
>>
>
>  I tried this but found that the cells (in your case with '80') were filled
> with error messages when the source cells were removed. Changing the
> display
> of the cell contents is easy.
>
> Thanks,
>
>
> Rich
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

RE: [libreoffice-users] Calc: Converting Formula to Value

2011-10-29 Thread Dennis E. Hamilton 
Or, you can open it (an .ods) in Microsoft Office 2007/2010, and save it back. 
That will leave the values and strip the formulas from the cells [;<).  It 
might work to save as .xslx and then reopen it in LO too, but I haven't tried 
that case.

-Original Message-
From: Stefan Weigel [mailto:stefan.wei...@bildungskreis.org]
Sent: Friday, October 28, 2011 16:26
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Calc: Converting Formula to Value

Hi,

Am 29.10.2011 01:14, schrieb Rich Shepard:
>   I have a column where the cells display the sum of two other
> columns. I
> want to change the contents from formula to value but cannot find the
> relevant information in the help pages. Please point me to
> instructions on
> how to do this.

The trick is to copy and then paste special (Edit menu). In the
dialog check only numbers.

Stefan




-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-29 Thread Rich Shepard 

On Fri, 28 Oct 2011, The Wolfkin wrote:


So if I'm understanding you're trying to say start out with cells..
input a formula like this
http://minus.com/lgIwyrkPUPHj7
which gives a solution like this
http://minus.com/l50sfqIxwhBlz

and then now change the contents of cell D5 from {=B5+C5} to {80}
so that you can delete the contents of B5 an C5 yet keep the 80


  I tried this but found that the cells (in your case with '80') were filled
with error messages when the source cells were removed. Changing the display
of the cell contents is easy.

Thanks,

Rich

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-29 Thread Rich Shepard 

On Sat, 29 Oct 2011, Stefan Weigel wrote:


The trick is to copy and then paste special (Edit menu). In the dialog
check only numbers.


Stefan,

  Thank you very much.

Rich

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-29 Thread Stefan Weigel 
Hi Rich,

Am 29.10.2011 01:50, schrieb Rich Shepard:

>   I'm not following you. Are you writing that I can highlight two
> adjacent
> cells and have their sum pasted in the same row in a third column?

No. Follow this:

(1) Select the cell that contains the formula

(2) Choose Edit | Copy

(3) Choose Edit | Paste Special

(4) Unselect "Paste all" and unselect "Formulas" and select "Numbers"

(5) Hit "OK"

Done.

Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-29 Thread Stefan Weigel 
Hi,

Am 29.10.2011 02:05, schrieb Uwe Koch Kronberg:

> Stefan means to select the area, copy it, go to another cell, choose
> edit from the menu, click on paste special and inside the menu box it
> opens unclick paste all, then unclick all the options below (text, date
> and hour, formulae, comments, formats, objects) except for numbers,
> which is the only option that should stay checked.

Hm. Not exactly. In order to "convert" a formula into its result
value, I wouldn´t go to *another* cell but paste special right in
the *same* cell --> that means overwriting the formula by its result
value. ;-)

Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-29 Thread Hladůvka Jiří 

Copy the cells and paste as "unformatted text"
(use the icon for pasting and select "unformatted text")

:)



Dne 29.10.2011 1:28, Stefan Weigel napsal(a):

Hi Tom,

Am 29.10.2011 01:21, schrieb Tom Davies:


Tools - Options - "LibreOffice Calc" - View

and then UNtick the "Formulas" tick box in the "Display" section at the top of 
the 2nd column.


This does not *convert* formula to value. It only changes the
display. ;-)

Stefan




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread The Wolfkin 
So if I'm understanding you're trying to say start out with cells..
input a formula like this
http://minus.com/lgIwyrkPUPHj7
which gives a solution like this
http://minus.com/l50sfqIxwhBlz

and then now change the contents of cell D5 from {=B5+C5} to {80}

so that you can delete the contents of B5 an C5 yet keep the 80

-- 
I love gmail. Do you?
The Wolfkin


On Fri, Oct 28, 2011 at 7:50 PM, Rich Shepard wrote:

> On Sat, 29 Oct 2011, Stefan Weigel wrote:
>
>  The trick is to copy and then paste special (Edit menu). In the dialog
>> check only numbers.
>>
>
> Stefan,
>
>  I'm not following you. Are you writing that I can highlight two adjacent
> cells and have their sum pasted in the same row in a third column?
>
> Rich
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread Uwe Koch Kronberg 
Hi Rich,

Stefan means to select the area, copy it, go to another cell, choose
edit from the menu, click on paste special and inside the menu box it
opens unclick paste all, then unclick all the options below (text, date
and hour, formulae, comments, formats, objects) except for numbers,
which is the only option that should stay checked.

Good luck,
El 28/10/11 20:50, Rich Shepard escribió:
> On Sat, 29 Oct 2011, Stefan Weigel wrote:
>
>> The trick is to copy and then paste special (Edit menu). In the dialog
>> check only numbers.
>
> Stefan,
>
>   I'm not following you. Are you writing that I can highlight two
> adjacent
> cells and have their sum pasted in the same row in a third column?
>
> Rich
>

-- 

Uwe Koch Kronberg
Enrique Koch y Cía. Ltda.
Fono: + 56 32 2543464
Fax: + 56 32 2543465
Cel: + 56 9 87177837
E-mail:uwe.k...@opticakoch.cl 

La información contenida en este mensaje puede ser privada, confidencial
y estar protegida contra la divulgación. Si el lector de este mensaje no
es el receptor que se intentó contactar o un trabajador o interlocutor
responsable de entregar este mensaje al receptor que se intentó
contactar, usted está siendo notificado que cualquier propagación,
distribución o copia de esta comunicación está estrictamente prohibida.
Si ha recibido esta comunicación por error, por favor, notifíquenos de
inmediato respondiendo este mensaje y eliminándolo de su computador.


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread Rich Shepard 

On Sat, 29 Oct 2011, Stefan Weigel wrote:


The trick is to copy and then paste special (Edit menu). In the dialog
check only numbers.


Stefan,

  I'm not following you. Are you writing that I can highlight two adjacent
cells and have their sum pasted in the same row in a third column?

Rich

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread Rich Shepard 

On Sat, 29 Oct 2011, Stefan Weigel wrote:


This does not *convert* formula to value. It only changes the display. ;-)


Stefan,

  That's correct. How can I convert the formula value in each cell to the
value itself?

Thanks,

Rich

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread Rich Shepard 

On Sat, 29 Oct 2011, Tom Davies wrote:


and then UNtick the "Formulas" tick box in the "Display" section at the
top of the 2nd column. Regards from Tom :)


Tom,

  Yes, that changes the display, but not the cell contents. I need to change
the contents to the displayed value so I can delete the columns whose sum
(row-by-row) comprise the formula.

Thanks,

Rich

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread Rich Shepard 

On Sat, 29 Oct 2011, Cor Nouws wrote:


It is in
Tools > Options > Calc > View .. section display.


Cor,

  In the display section is a checkbox that allows the formula or value to
be displayed in each cell. What I want is to have the displayed value
_replace_ the formula in each cell. Can this be done?

Thanks,

Rich

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread Stefan Weigel 
Hi Tom,

Am 29.10.2011 01:21, schrieb Tom Davies:

> Tools - Options - "LibreOffice Calc" - View 
> 
> and then UNtick the "Formulas" tick box in the "Display" section at the top 
> of the 2nd column.  

This does not *convert* formula to value. It only changes the
display. ;-)

Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread Stefan Weigel 
Hi,

Am 29.10.2011 01:14, schrieb Rich Shepard:
>   I have a column where the cells display the sum of two other
> columns. I
> want to change the contents from formula to value but cannot find the
> relevant information in the help pages. Please point me to
> instructions on
> how to do this.

The trick is to copy and then paste special (Edit menu). In the
dialog check only numbers.

Stefan




-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread Tom Davies 
Hi :)
There is documentation on
http://wiki.documentfoundation.org/Documentation/Publications

I think you just need to go to

Tools - Options - "LibreOffice Calc" - View 

and then UNtick the "Formulas" tick box in the "Display" section at the top of 
the 2nd column.  
Regards from
Tom :)


--- On Sat, 29/10/11, Rich Shepard  wrote:

> From: Rich Shepard 
> Subject: [libreoffice-users] Calc: Converting Formula to Value
> To: users@global.libreoffice.org
> Date: Saturday, 29 October, 2011, 0:14
>   I have a column where the
> cells display the sum of two other columns. I
> want to change the contents from formula to value but
> cannot find the
> relevant information in the help pages. Please point me to
> instructions on
> how to do this.
> 
> Thanks,
> 
> Rich
> 
> -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived
> and cannot be deleted
> 
> 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-28 Thread Cor Nouws 

Hi Rich,

Rich Shepard wrote (29-10-11 01:14)

I have a column where the cells display the sum of two other columns. I
want to change the contents from formula to value ...


It is in
Tools > Options > Calc > View .. section display.

Cheers,

--
 - Cor
 - http://nl.libreoffice.org


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted