To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=32344
------- Additional comments from [EMAIL PROTECTED] Mon Aug 15 19:32:08 -0700
2005 -------
This gets a bit more complicated than it seems at face value, but I will
continue a bit more to see if there is an optimal solution to the problem.
> What should be exported if that argument is the result of a formula?
Keep in mind this would not be the argument with the wildcards/regular
expressions in it, but an additional, optional argument whose value would be
restricted to 0 or 1, True or False. If it is set to 1, then the formula uses
wildcards and you export the other argument to the function with the wildcards
in it as it is written by the author of the document and strip the 1 during
export since Excel does not use it because by default it uses wildcards. If it
is not set or set to 0, then you know you are exporting a document that is very
likely not to be compatible with Excel, but could warn and continue exporting
anyway.
If the additional, optional argument is a result of a formula, which should
not be necessary, then that formula should result in True or False, 0 or 1
otherwise it would be in error. That still would not matter because you would
just check to see if it results in 0 and 1 and strip the whole formula off just
like you would strip the 1 off. Though it would be easier to just restrict that
argument to only the values 0,1,True,False and anything else would result in a
formula error.
> I'd rather implement a simple wildcard search than fiddling around with
>the argument's string content. Bear in mind that all other content that
>possibly could form a regular expression would have to be escaped
>otherwise.
The additional, optional argument would just determine which code path is
taken. If you want to do a whole new implementation of the formula using
wildcards instead of messing with the string content of the argument containing
wildcards/regular expressions, the same principle would still work.
The biggest problem I see with the supposedly simple solution, just turn off
regular expressions and turn on wildcards is that it immediately eliminates the
use of more powerful regular expressions in that document, preventing someone
from importing a document containing wildcards from excel for the purpose of
using regular expressions. The continued incompatibility on export of formulas
with the same names using regular expressions would also still have to be dealt
with in the simple case.
The basis of my approach is almost exactly the same as doing it for the whole
document or sheet, with the exception that it is done for each cell where those
formulas are used, rather than the whole document at once. You still have to
decide whether its a regular expression or wildcard and fix the code for each
formula to handle it if you do it for the whole document.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
