Apache OpenOffice (AOO) Bugzilla – Issue 60309
Search for strings in date formats fails
Last modified: 2013-08-07 15:12:27 UTC
Replacement for StarOffice internal issue #112709# because FT left OOo. (reported by KR) new calc type a date e.g. 10/17/2003 format the cell to e.g. 'Friday, October 17, 2003' open Find & Replace dialog search for Friday or October -> no success whatever options you choose expand more... -> still no success whatever options you choose Excel would find the string if 'Search in (x)Values' is checked ATTENTION: Possible traps for implementatation. In comparison to excel we do not distinguish between a SEARCH and a REPLACE dialog. With our dialog a user could search for OCTOBER and replace it with FOOTEMBER. What should happen then? Should the date value be converted to a string (Friday, Footember 17, 2003)? Should an error message appear? Or do we offer a smart listbox that offers possible replacements? This has to be specified.
JA: duplicate *** This issue has been marked as a duplicate of 60307 ***
.