[sc-issues] [Issue 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 08:12:57 + 2008 --- Hi, Eike I have seen this issue several days, but I can not find out a clear clue. I feel a little confuzed. can you point me a way to do this? Yue - 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]
[sc-issues] [Issue 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 User pagalmes changed the following: What|Old value |New value CC|'rpolach' |'pagalmes,rpolach' - 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]
[sc-issues] [Issue 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 --- Additional comments from [EMAIL PROTECTED] Thu Apr 19 16:54:09 + 2007 --- *** Issue 76526 has been marked as a duplicate of this issue. *** - 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]
[sc-issues] [Issue 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 User jodygoldberg changed the following: What|Old value |New value IssuesThisDependsOn| |71455 --- Additional comments from [EMAIL PROTECTED] Thu Apr 19 16:57:01 + 2007 --- There are XL compatible versions in mainline now, from the R1C1 work (although they do not handle the .de style ZnSn localization). They'll be generally enabled as part of the OpenFormula work rather than the current INDIRECT_XL approach used in oo-build. Unfortunately none of this will help with the differences in allowable sheetnames which may cause a sheet to be renamed on import. - 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]
[sc-issues] [Issue 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 --- Additional comments from [EMAIL PROTECTED] Fri Dec 15 02:46:53 -0800 2006 --- Or should be enough to automatically translate =INDIRECT(!a1) into =INDIRECT(SUBSTITUTE(!a1; !; .)) when importing excel 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]
[sc-issues] [Issue 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 --- Additional comments from [EMAIL PROTECTED] Fri Dec 15 04:20:58 -0800 2006 --- Not quite. We'll have to take into account that the sheet name may contain an exclamation mark as well, or the reference string may actually consist of an external reference and file name containing exclamation marks. Only the last exclamation mark right before a cell address or range name can be converted. - 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]
[sc-issues] [Issue 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 User rpolach changed the following: What|Old value |New value CC|''|'rpolach' - 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]
[sc-issues] [Issue 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 --- Additional comments from [EMAIL PROTECTED] Fri Dec 15 15:06:41 -0800 2006 --- Allow me to propose a workaround using a name reference(Ctrl+F3) shSep =MID(ADDRESS(1;1;1;Foo);4;1) =INDIRECT(shSepa1) Now your formula works in both applications. Same is possible with pattern matching: anyChar =IF(shSep=.;.*;*) =FIND(FanyChar;A1) Notice that regular expressions are turned off when you open xls. ToolsOptionsCalcCalculation:Allow Regexes in Formulae - 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]
