Re: How to copy formulas from a text or remove (') from ('=) in many cells WITHOUT using CSV files ?



This works for me. Do you have what would be a valid _expression_ in A1?
=1*1
is clearly valid but I am wondering about your choice of words "an error message like this".

Andreas

On 15-02-16 09:19 PM, Yury Dubinsky wrote:
This question was asked on 21 May 2011 . (https://mail.gnome.org/archives/gnumeric-list/2011-May/msg00009.html)
One  advice was to use CSV files. The second advice was  to apply search-replace:
' Search for "=", replace by "=".
  On the Advanced tab, uncheck "Keep strings as strings"'

          
However, the second, more interactive, option doesn't work for me. 
I am getting an error message like this:
"In cell A1, the current contents 
        '=1*1 
would have been replaced by 
        =1*1 
which is invalid. 
The replace has been aborted and nothing has been changed "

Am I doing something wrong? 
Or did Gnumeric stopped supporting this behavior since 2011?

          


          

        



_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]