Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

(There is no .XLXS extension for Excels afaik. Do you mean .XLSX ?)

(I suppose the following will hold for Excel, but don't actually know.)

LibreOffice Calc will find a sequence of digits searched for using the Find (Ctrl+F) utility or the 'Search & Replace' tool also inside numerical values which are auto-converted for the purpose into strings basing on the decimal system. This is also the behaviour of some functions, FIND() and SEARCH() among them.

If any cell is containing a numerical value this value may be displayed in very different ways (even explicitly lying) depending on the cell format set. 'Find' and 'Search & Replace' will rely on the actual value, not on what is displayed.

An example: The formula contained in a cell, say B3, has calculated the value 3.141592653... (the dots standing for some additional digits). You have set a currency format for B3 and the cell may display "3.14 $" according to it. Now you are looking out for "9265" using one of the above mentioned tools. B3 will be found. The same if the cell was formatted as a 'Date-Time' with many digits and showing "1900-01-02 03:23:53.61".

(Depending on the setting of an option additional functions may find B3 looking for "92652 in that case.)

(There is no .XLXS extension for Excels Excel afaik. Do you mean .XLSX ?)

(I suppose the following will hold for Excel, but don't actually know.)

LibreOffice Calc will find a sequence of digits searched for using the Find (Ctrl+F) utility or the 'Search & Replace' tool also inside numerical values which are auto-converted for the purpose into strings basing on the decimal system. This is also the behaviour of some functions, FIND() and SEARCH() among them.

If any cell is containing a numerical value this value may be displayed in very different ways (even explicitly lying) depending on the cell format set. 'Find' and 'Search & Replace' will rely on the actual value, not on what is displayed.

An example: The formula contained in a cell, say B3, has calculated the value 3.141592653... (the dots standing for some additional digits). You have set a currency format for B3 and the cell may display "3.14 $" according to it. Now you are looking out for "9265" using one of the above mentioned tools. B3 will be found. The same if the cell was formatted as a 'Date-Time' with many digits and showing "1900-01-02 03:23:53.61".

(Depending on the setting of an option additional functions may find B3 looking for "92652 in that case.)