In libre calc there is no option to make default search to serach in all sheets, although there is an option to check after that calc can search in all sheets but in case a new file is opened or file reopened after close then i have to again re tick the same option, i also try templates but also that thing does not work please add a preference for this.
*** This bug has been marked as a duplicate of bug 58676 ***