Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | SUMIF with a string with jolly character criteria doesn't work | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | trigone <tiziano.pappalardo> | ||||
Component: | open-import | Assignee: | spreadsheet <spreadsheet> | ||||
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues, rainerbielefeld_ooo_qa | ||||
Version: | OOO300m9 | Keywords: | oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Windows Vista | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
trigone
2008-11-24 22:08:48 UTC
I checked with "Ooo 3.0.0 (DE) Multilingual version German UI WIN XP: [OOO300m9 (Build9358)]" and can NOT confirm the reported effect. Vista-specific? @trigone: Great idea to type the example instead of attaching a sample document ;-) Can you please attach a document demonstrating your problem? Created attachment 58364 [details]
Excel 2003 sheet showing syntax difference from Calc
Attached an Excel 2003 win xp sp2 workbook that shows the syntax differences between Excel and Calc. Calc needs a period (stop) added to the formula along with regualar expressions enabled. It appears that Calc does not translate the Excel syntax to Calc syntax. This was using OOO300m9 (Build:9358) and Dev300m35 (Build:9367) Calc versions. TomW @trigone: 'Tools -> Options -> Calculate', checked "enable regular expressions in formulas", everything will work as expected for the sample document. But OOo regular expression ".*" is something different from EXCEL's "*". for support of those simple wildcards we have Issue 32344 May be also information in "Wontfix" Issue 91873 might be interesting for you. May be you want to vote for Issue 32344 *** This issue has been marked as a duplicate of 32344 *** . duplicate -> closed |