divendres, 21 d’abril de 2017

Eliminar Apostrof ' davant d'un text libreoffice al camp fórmula / reemplazar apostrofo delante de un texto en Calc Libreoffice en el campo formula


1) Especificar el formato a las celdas.
2) Buscar y reemplazar.
3) Buscar:    .*
4) Reemplazar por:  &
5) Seleccionar la opción "Expresiones regulares"
6) Reemplazar


The apostrophe isn't really part of the cell content, it just signifies that the cell is formatted as text. To reenter all the data as number:
1. Highlight all of the cells and use Format -> Cells to change the cell format to an appropriate number format.
2. With all of the cells still selected, go to the menu Edit -> Find & Replace
3. In the Search For box enter .* (period asterisk)
4. In the Replace with box enter &
5. Select More Options and check Current Selection Only and Regular Expressions
Step 5.5 Select More Options menu, set on "Search in" the option "Values" NOT "formulas" as it is the default
6. Click Replace All


The .* "means zero or more of any character" and & means "whatever was found".


Vist a: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=49046 gràcies a FJCC