https://bz.apache.org/ooo/show_bug.cgi?id=60307
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Resolution|--- |FIXED Target Milestone|--- |4.2.0 Latest|--- |4.2.0-dev Confirmation on| | Status|CONFIRMED |RESOLVED --- Comment #3 from [email protected] --- I committed a patch for this in revision 1712367: #i60307# search for strings in date formats fails. When "Search in" is set to "Values", search the formatted values instead of just the raw input. This fixes a 9 year old bug that's been duplicated at least 6 times, and matches what Excel does. Tests show even "Replace" works, and works well: if "October" is replaced by "November", it converts the original month from 10 to 11; it only converts the cell type to text if the resulting text is no longer a valid date. Also added BVT tests for the expected behaviour. Resolving fixed. -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue.
