| View previous topic :: View next topic |
| Author |
Message |
mylbco
General User
Joined: 25 Jan 2006
Posts: 15
|
 Posted: Mon Apr 09, 2007 1:23 am Post subject: Permanent enable the Tools/Options/regular expressions XLS ? |
 |
|
Very Strange ...
---------------------> OO 2.2
When I enable 'Regular Expression's in my Tools->Options selection, it is back disabled when I start Open Office again ?
Try it this way ...
Open Calc, enable the Tools/Options/regular expressions
Close Calc
Open Again, the option is enabled ...
Open Calc, enable the Tools/Options/regular expressions
Open an Excel (.XLS) spreadsheet
The Tools/Options/regular expressions is DISABLED (always ...) you have to enable it again manual.
When you do the same with an ods file it is no problem ...
Does somebody know anything about this ?
_________________
Peter Langenberg
Bubbles-iT |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Mon Apr 09, 2007 7:07 am Post subject: |
|
|
The only reason for saving as xls is that the file may be opened in Excel. But Excel does not support regular expressions. When you open a xls then OOo has to assume that this file does not have any regular expressions in it. So the regex option is turned off. Unfortunately, without this option there is no pattern-matching at all.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
mylbco
General User
Joined: 25 Jan 2006
Posts: 15
|
| Posted: Mon Apr 09, 2007 12:17 pm Post subject: |
|
|
Thanx, I'll save the master spreadsheet in ods ...
_________________
Peter Langenberg
Bubbles-iT |
|
| Back to top |
|
|
|
