You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Bill T <ca...@gmail.com> on 2021/10/24 02:45:55 UTC

Apache Spreadsheet Issue

On the Apache Spreadsheet (OpenOffice Calc), an equal sign cannot be
entered into a cell.  Apparently the program will expect an equation to be
built in the cell when it sees an equal sign.  A solution seen on the
internet was to go to File>Autocorrect to fix this but there is no
Autocorrect as an option.  My version is 4.1.11.  I need the ability to
enter any typewriter character into a cell as text.

Let me know, if you can, what I can do to correct this problem.  I thought
that perhaps there is a pay-for version for Apache that has the Autocorrect
function but I saw nothing about that on the internet.

Thank you, Bill

Re: Apache Spreadsheet Issue

Posted by Rory O'Farrell <of...@iol.ie>.
On Sat, 23 Oct 2021 19:45:55 -0700
Bill T <ca...@gmail.com> wrote:

> On the Apache Spreadsheet (OpenOffice Calc), an equal sign cannot be
> entered into a cell.  Apparently the program will expect an equation to be
> built in the cell when it sees an equal sign.  A solution seen on the
> internet was to go to File>Autocorrect to fix this but there is no
> Autocorrect as an option.  My version is 4.1.11.  I need the ability to
> enter any typewriter character into a cell as text.
> 
> Let me know, if you can, what I can do to correct this problem.  I thought
> that perhaps there is a pay-for version for Apache that has the Autocorrect
> function but I saw nothing about that on the internet.
> 
> Thank you, Bill

Format your cell as "Text".

-- 
Rory O'Farrell <of...@iol.ie>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Re: Apache Spreadsheet Issue

Posted by Dick Groskamp <di...@apache.org>.

On 2021/10/24 02:45:55, Bill T <ca...@gmail.com> wrote: 
> On the Apache Spreadsheet (OpenOffice Calc), an equal sign cannot be
> entered into a cell.  Apparently the program will expect an equation to be
> built in the cell when it sees an equal sign.  A solution seen on the
> internet was to go to File>Autocorrect to fix this but there is no
> Autocorrect as an option.  My version is 4.1.11.  I need the ability to
> enter any typewriter character into a cell as text.
> 
> Let me know, if you can, what I can do to correct this problem.  I thought
> that perhaps there is a pay-for version for Apache that has the Autocorrect
> function but I saw nothing about that on the internet.
> 
> Thank you, Bill
> 
Autocorrect  =  Tools  ⇾ Autocorrect Options

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org