Limitation


1. Bug and Limitation



1. Bug and Limitation

1-1. [Excel X for Mac] If active sheet does not exist and if you show the dialog and find , the progress is not shown.

Detail:
  In this specification , the progress is shown in the Status bar. If Windows , there is the status bar in the lower side of Excel Application Window.
But if Mac , there is the status bar in the lower side of the active window.
  Therefore, if Mac and if active window (active sheet) does not exist , the progress is not shown.
Correction schedule: None.

1-2. When you show the result place and if it is in hidden sheet , the place can not be shown.

Detail: The previous sheet is activated.

Correction schedule: None.

1-3. When you show the result place and the place type is cell comment and if it is hidden, the place can not be shown.

Detail: Sorry , an error is occured.

Correction schedule:None.

1-4. Chart sheets is not range of the finding.

Detail: This is a specification.

Correction schedule:None.

1-5. [Excel 97] If you cancel the find , there is a case that an error is occured when file closing.

Detail: The cause is uncertain. Please close the file.

Correction schedule:None.

1-6. If you cancel the find , the status bar is not put back.

Detail: Because if you cancel , the process that the status bar is not put back does not do.
If you want to put back , please input "Application.StatusBar = False" and push the [Enter] key in the immediate window in VBE (Visual Basic Editor).

Correction schedule:None.

1-7. When you find , if target excel file is opend and edited , the editing content is found.

Detail: This is a specification.

1-8. There is a case that it is made to wait from clicking [Find] button to showing the progress in the statuts bar. And there is a case that it is made to wait even if the progress rate is 100%

Detail: This is a specification bug. Sorry.
Because before the progress is shown , the process checking target files is done.
Therefore , if there is a lot of files ( a lot of subfolder ) , it takes time.

Because the progress rage is 100% means ending of the find , but the outputing result is not done.
Therefore , if there is a log of match place and log , it takes time.

Correction schedule: It corrects it when there is free time.

1-9. If you find in Mac and send the result to Windows , you can not show (jump) the result place. The opposite is also.

Detail: It is because the delimiter of path is different in Mac and Windows.

1-10. There is a bug about grouped autoshape.

[Excel X for Mac] You can not show (jump) the place. ( A runtime error (Number=70) is occured. )
[Excel 97] You can not show (jump) the place. ( A runtime error (Number=1004) is occured. )
[Excel 2000] It is the same as Excel 97.
[Excel 2003] The text in the grouped autoshape is not found.
Note. I confirmed that it can found in Excel 97 , 2000 and Excel X for Mac.
If you find in excluding Excel 2003 and you open result excel file in Excel 2003 , this trouble is not occured.

Detail: I think the bug of the Excel.

1-11. There is a case that when you click the [Browse...] button, automation error is occured.

I confirmed the Excel 2000 only (OS is Windows 98 SE) .
If the target folder is "" , you click [Browse...] , I think that this trouble is occured and Excel Application is abended.
In this case , please input the [target folder] text box. Please don't use [Browse...] button.

1-12. There is a case that the target files is shown in finding

I confirmed the Excel 2003. When file is opened , There is a case that "Application.ScreenUpdating = True". (Therefore , in the macro of this add-in , after opening file , "Application.ScreenUpdating = False" is done.)
If window is shown , the find does not stopped.

1-13. [Excel X for Mac] The [target folder] text box can not be copyed and pasted.

Even if you push the [Command] + [C] key , it is not copyed.
Even if you push the [Command] + [V] key , it is not pasted.

Please use the [Control] key instead of the [Command] key.

Back to Top