asked 2012-05-11 22:33:13 +0200
Anonymous
I need to transpose lots of data into a new sheet on CALC. So I generate the relations using the "concatenate" command, e g:
´=IF($dados.$C$4="","",$dados.$C4)
So I copy and paste (special text numbers) to the cells where I need to put my data. All I have now is a lot of cells with text similar to the text above.
The next step will be to use the command "find and replace" to replace '= by =. When I perform this command the result is an Error501 and the text was altered as:
=IF($dados.$C$4=)
No matter what I do, I can not perform this task.
I hope someone had faced this same issue and can help me.
Thanks in advance.
Maybe prior to introduce the first formula, the cell is formatted as text, this is why the formula is putting in the cell as a text not as a formula.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-11 22:33:13 +0200
Seen: 105 times
Last updated: May 11 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Anonymous -- did you find an answer to your question? Did mariosv's answer work for you?
qubit ( 2013-03-10 10:10:12 +0200 )edit