[Issue 60307] Search for strings in date formats fails

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=60307

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |damjan@apache.org
         Resolution|---                         |FIXED
   Target Milestone|---                         |4.2.0
             Latest|---                         |4.2.0-dev
    Confirmation on|                            |
             Status|CONFIRMED                   |RESOLVED

--- Comment #3 from damjan@apache.org ---
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.