[prev in list] [next in list] [prev in thread] [next in thread] 

List:       openoffice-users
Subject:    Re: Equals Sign In Tables
From:       "G. Roderick Singleton" <grsingleton () openoffice ! org>
Date:       2003-10-31 15:36:03
Message-ID: bntvgf$cc4$1 () sea ! gmane ! org
[Download RAW message or body]

Alf Haakon Lund wrote:
> Hello again,
> 
> I tried this input: '=6
> 
> The result is a cell with this content: '=6
> 
> I want the cell to contain: =6
> 
> So far, the nicest looking and least bothersome method to achieve this is 
> by inserting a blank space first:  =6
> 
> Since this is actually indenting the contents of the cell by one space, if
> you want the table to look consistent you need to input the extra blank in
> ALL cells, or type <space>, <equals sign>, <6>, <left arrow>, <left
> arrow>, <backspace>...
> 
> I still think this should be considered a bug.
> 
> Alf
> 

I agree. Please let me know the issue #

> 
> On Fri, 31 Oct 2003, G. Roderick Singleton wrote:
> 
> 
>>Alf Haakon Lund wrote:
>>
>>>I had a problem with this, too.
>>>
>>>I needed a table (in writer) where the cells would contain the signs + -
>>>=. Every time i enter the equals sign, writer enters calculation mode. Now
>>>if I put in an apostrophe first, like so: '= it will not enter calculation
>>>mode, but the apostrophe does not go away.
>>>
>>>That means, if I want a cell to contain =6 I either have to type this
>>>OUTSIDE the table and cut and paste the text into the cell or type 6=
>>>directly into the cell and afterwards cut and paste to have it 
>>>show correctly.
>>>
>>>If this is a problem not unique to me and my setup, I think it should be 
>>>considered a bug. Maybe for the IssueZilla, this one?
>>>
>>>Alf.
>>>
>>>On Fri, 31 Oct 2003, Bob Long wrote:
>>>
>>>
>>>
>>>>>At 04:16 PM 10/29/2003, you wrote:
>>>>>
>>>>>
>>>>>>I'm trying to use an equals sign on its own in a cell in a table but
>>>>>>Writer seems to think I'm trying to write a formula which I'm
>>>>>>really not. It wont let me just put the equals sign in no matter
>>>>>>how persistent I am. Can anyone help with this?
>>>>>>
>>>>>>Sean T.
>>>>
>>>>In news:6.0.0.22.0.20031029043648.028af6e0@pop.mts.net,
>>>>Bert Wold <bwold@mts.net> typed:
>>>>
>>>>
>>>>>If your trying to use = as text, simply place an apostrophe directly
>>>>>in front of it: '= in the cell by itself.
>>>>>hope this helps.
>>>>
>>>>I'm not sure that is correct. That works in Calc, but not in a table in
>>>>Writer, as far as I can tell. It seems that pressing the equals sign in a
>>>>cell in a table in Writer as the first character, if the cell is empty,
>>>>triggers the formula mode. But if you enter another character, then the
>>>>equals, you can go back and delete that first character, leaving only the
>>>>equals sign.
>>>>
>>>>Bob Long
>>
>>In Excel you enter an apostrophe followed by the operator character 
>>followed by whatever in the input field which then puts the text into 
>>the target cell. e.g. '=6
>>
>>Try it and let us know if this works for you.
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: users-unsubscribe@openoffice.org
>>For additional commands, e-mail: users-help@openoffice.org
>>
>>



[prev in list] [next in list] [prev in thread] [next in thread]