Bug 88718 - Error in COUNTIF function - case sensitive to external file.
Summary: Error in COUNTIF function - case sensitive to external file.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.2.8.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-22 19:02 UTC by Paulo San
Modified: 2015-01-22 20:12 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
Function.ods is the file with function to test, and the External_file.ods is the file with the external data to reference. (21.63 KB, application/zip)
2015-01-22 19:02 UTC, Paulo San 		Details
Function file (13.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-22 19:04 UTC, Paulo San 		Details
File to external reference. (11.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-22 19:04 UTC, Paulo San 		Details
View All

Description Paulo San 2015-01-22 19:02:59 UTC 
Created attachment 112680 [details]
Function.ods is the file with function to test, and the External_file.ods is the file with the external data to reference.

In CONT.SE function if the search is done in an external file the function becomes case sensitive, if the search is made in own not.

If you change the cell D1 of Function.ods spreadsheet to the A (and A to a...) we can see the difference between an internal search and the same external search. 
Since the external and internal data are the same.

thank you for all...
Comment 1 Paulo San 2015-01-22 19:04:24 UTC 
Created attachment 112681 [details]
Function file
Comment 2 Paulo San 2015-01-22 19:04:56 UTC 
Created attachment 112682 [details]
File to external reference.
Comment 3 raal 2015-01-22 20:07:58 UTC 
I can confirm with Version: 4.5.0.0.alpha0+
Build ID: 60143f4f7bc50054dcef923218b8c7c3bc154933
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-21_04:58:34

Tools->Options->LibreOffice Calc->Calculate , checked 'Case Sensitive'.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.