Issue 75097 - Search in Calc doesn't find value generated by formula
Summary: Search in Calc doesn't find value generated by formula
Status: CLOSED DUPLICATE of issue 60307
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.2 RC2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: 4.2.0
Assignee: ooo
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-03-04 10:11 UTC by gustaaf
Modified: 2017-05-20 09:52 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---

Attachments
file used to test search function (13.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-03-04 10:12 UTC, gustaaf 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description gustaaf 2007-03-04 10:11:04 UTC 
Calc 2.2 RC2 (NL) testing Calc-32 :

I generated a spreadsheet containing dates, and decimal values as stated in the 
test steps. I also generated a column with calculated dates. 
When searching for a value (ex. 10) and set the option to Values, the year 10 
(from 2010)is found into the column with dates, but not in the column with 
results based on a calculation. 

When the cell is showing the month by its name, the month isn't found when 
using the name. It is found when using the months corresponding number. (ex:  
12 in stead of december)µ

See also attached file, used to perform te test.
Comment 1 gustaaf 2007-03-04 10:12:07 UTC 
Created attachment 43514 [details]
file used to test search function
Comment 2 epochiero 2007-03-06 19:50:52 UTC 
I've reproduced the issue, but i think it's very similar to #66102.
I would say it's a duplicate.
Comment 3 gustaaf 2007-03-08 21:17:23 UTC 
Issue is the same in 2.2 RC3.
Comment 4 gercokees 2007-03-09 14:03:44 UTC 
Marked as duplicate

*** This issue has been marked as a duplicate of 66102 ***
Comment 5 frank 2007-03-09 14:51:58 UTC 
not a double to Issue 66102

to workaround the problem, just set the numberformnat for the result cells to a
date format.

Frank
Comment 6 frank 2007-03-09 14:53:10 UTC 
Hi Eike,

please have a look at this one and keep the API in mind.

Frank
Comment 7 damjan 2015-11-03 18:53:10 UTC 
My patch to #60307 fixes this as well. Resolving duplicate.

*** This issue has been marked as a duplicate of issue 60307 ***