First time here? Check out the FAQ!
asked 2012-05-11 22:33:13 +0200
I need to transpose lots of data into a new sheet on CALC. So I generate the relations using the "concatenate" command, e g:
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:
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.
answered 2012-05-11 23:31:40 +0200mariosv
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