Ask Your Question

calc find function won't look for number with dot separator [closed]

asked 2019-02-22 16:22:01 +0200

jackalek gravatar image

updated 2020-07-09 18:21:08 +0200

Alex Kemp gravatar image

I've a spreadsheet with home budget data, and I enter the values with two decimal places, separated by dot. In the past it was possible to do control-F and type lets say 12.96 into search box and Calc would find the data for me. The recent version won't do that anymore and would not find the cells if I ask it to look for number with dot separator. Is there any setting I missed ? No regular expressions ticked. It is quite annoying bug as I was using search this quite often.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-02-25 15:04:19.051149

2 Answers

Sort by » oldest newest most voted

answered 2019-02-22 16:47:08 +0200

erAck gravatar image

Make sure the cell value is actually 12.96 and not just displayed as such (i.e. could be 12.959 displayed with 0.00 format and thus rounded). If in doubt, to search for displayed values tick the Formatted Display checkbox in the Find bar.

edit flag offensive delete link more

answered 2019-02-23 10:12:41 +0200

jackalek gravatar image

Hi. Thank you for the answer. The value was hand typed so it was with only two decimal places. However, the checkbox Formatted Display did the trick and I'm able to find what I'm looking for. However, there must have been a change in default behaviour as it wasn't necessary to do in the past and the spreadsheet is over 10 years old, and I'm certain it worked two years ago (with whatever version was current at the time) Once again thank you for your input.

edit flag offensive delete link more


Might be related to that in older releases the Find bar inherited some settings and search behaviour from the Find&Replace dialog, which was rather obscure and not transparent to the user, so there may be some differences in the current behaviour depending on what settings were active in your old F&R dialog.

And please don't enter comments as answers, which they are not, use add comment instead. Thanks.

erAck gravatar imageerAck ( 2019-02-25 15:03:48 +0200 )edit

Question Tools

1 follower


Asked: 2019-02-22 16:22:01 +0200

Seen: 69 times

Last updated: Feb 23 '19