Issue 91873 - "Enable regular expressions in formulas" default not checked for .xls
Summary: "Enable regular expressions in formulas" default not checked for .xls
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0 Beta 2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-20 18:57 UTC by j2006
Modified: 2008-09-16 15:50 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
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 j2006 2008-07-20 18:57:13 UTC 
One thing I noticed is that opening a .sxc or .ods ODF spreadsheet the
preference for Calc has the option "Enable regular expressions in formulas" uner
"Calculate" checked (or maybe that is saved in the file?). Opening a .xls
spreadsheet that is never the case so I have to enable it always when I open a
.xls spreadsheet using regular expressions.

I became aware of this different behaviour when I switched back to using .xls
for a spreadsheet that I originally created in the OOo 1.x .sxc format. So I
guess this "feature" exists since the early 2.x versions when I started using
.xls instead of .ods

I don't know if checking this option causes problems with .xls spreadsheets  but
if that is not the case I would suggest to use the same default preferences as
with ODF spreadsheets.
Comment 1 ooo 2008-09-16 15:49:36 UTC 
Excel does not know regular expressions, that's why the option is switched off
when importing an .xls file. This will not be changed. We'll need a third option
to support simple wildcards like Excel uses, which issue 32344 is about.
Comment 2 ooo 2008-09-16 15:50:02 UTC 
Close wontfix.