You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Lorna Richard <lo...@ymail.com> on 2014/01/22 20:57:25 UTC
clearing a cell
Why is the delete function not working from me?
There is a formula calculation that will not clear and not allowing me to continue
Fw: clearing a cell
Posted by Lorna Richard <lo...@ymail.com>.
It is in calc
When entering data
in colume A it will not hold the formatting of how I would like
the date to be displayed.
I keep clearing the cell yet the formula
in any given cell still has a link to a previous cell
Say A06 is 1 Aug
when I go to enter a date in cell A115 it puts in the
date that has been entered in cell A06 so the date is always displaying as 1 Aug regardless of what cell the data is being in putted into.
=SUM(A08:A115)
On Wednesday, January 22, 2014 12:35:52 PM, Maurice Howe <ma...@stny.rr.com> wrote:
That usually means that the formula is invalid and AOO is waiting for your
>to repair it.
>Could you show us the formula? Is this in CALC, WRITER or what?
>
>Maurice Howe
>
>
>
>-----Original Message-----
>From: Lorna Richard [mailto:lornarichard59@ymail.com]
>Sent: Wednesday, January 22, 2014 2:57 PM
>To: users@openoffice.apache.org
>Subject: clearing a cell
>
>Why is the delete function not working from me?
>
>There is a formula calculation that will not clear and not allowing me to
>continue
>
>
>
>
RE: clearing a cell
Posted by Maurice Howe <ma...@stny.rr.com>.
That usually means that the formula is invalid and AOO is waiting for your
to repair it.
Could you show us the formula? Is this in CALC, WRITER or what?
Maurice Howe
-----Original Message-----
From: Lorna Richard [mailto:lornarichard59@ymail.com]
Sent: Wednesday, January 22, 2014 2:57 PM
To: users@openoffice.apache.org
Subject: clearing a cell
Why is the delete function not working from me?
There is a formula calculation that will not clear and not allowing me to
continue
-------------------------------------------
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: clearing a cell
Posted by Alan B <ab...@gmail.com>.
On Wed, Jan 22, 2014 at 9:02 PM, Lorna Richard <lo...@ymail.com>wrote:
> Hi
> I tried the backspace and also tried clearing the cell of all content and
> it does not retain the function. Also control z and nothing will clear the
> cell memory.
>
>
Have you tried the "Delete" key? Backspace and Delete keys work
differently. Depending how it is set up Backspace just may not remove from
the cell what you wish it to.
Ctrl+Z is undo. Depending what editing has been done and when there will be
nothing for it to undo that is meaningful to correcting this problem.
>
> Also when setting the formate for how I want the date to apear the cell
> does not remember this either
> and goes back to auto correct.
>
I'm confused by this. "Auto correct" is not a format.
Please click ONCE on the cell, next right-click on the cell. On the menu
that appears after the right-click select "Clear Direct Formatting." That
should return the cell to the default formatting for any type of value
entered, date, number, text, etc. (If that's not the format you want let's
not worry about that right now. I think maybe one thing at a time. See if
we can get the information into the cell that you want then try to resolve
formatting.)
>
> ... download it onto my new computer.
>
Did you download from http://www.openoffice.org/
If not I suggest you try downloading from there.Another source may not have
the exact "official" version.
>
>
... just use the main computer to
> do data imput.
>
>
Laptop is very convenient. Hopefully we can figure this out with little
enough effort that its worthwhile for you to stick it out through the
troubleshooting.
Alan
Re: clearing a cell
Posted by Lorna Richard <lo...@ymail.com>.
Hi
I tried the backspace and also tried clearing the cell of all content and
it does not retain the function. Also control z and nothing will clear the cell memory.
Also when setting the formate for how I want the date to apear the cell does not remember this either
and goes back to auto correct.
I have been using open office for years on the main computer without any problem. I tried to find the original disc and could not find it. So I thought I would download it onto my new computer.
I wanted to use the laptop as it is portable and more comfortable space to work in.
I tried opening a new spread sheet and the same thing happens.
If I can not resolve the issue I will delete the downloaded version of open office off the laptop and just use the main computer to
do data imput.
Thanks,
Have a great day,
Lorna
Much Love and Blessings,
Lorna
Spiritual Alchemist, Cellular Activation Specialist, Vibrational Transformationalist.
Individual (skype) and Group Sessions
call for appointment @250 770 0540
>________________________________
>From: Alan B <ab...@gmail.com>
>To: users@openoffice.apache.org; Lorna Richard <lo...@ymail.com>
>Sent: Wednesday, January 22, 2014 5:49:38 PM
>Subject: Re: clearing a cell
>
>
>
>Is the problem
>
>1) only column A?
>
>2) only this spreadsheet?
>
>Regarding "the delete function" is that
>
>1) the delete key?
>
>2) the backspace key?
>
>...some other technique. If some other technique, please describe.
>
>
>
>Alan
>
>
>
>
Re: clearing a cell
Posted by Alan B <ab...@gmail.com>.
Is the problem
1) only column A?
2) only this spreadsheet?
Regarding "the delete function" is that
1) the delete key?
2) the backspace key?
...some other technique. If some other technique, please describe.
Alan