The attached file was generated by .Cells 7.1.0.6. When opened in Excel 2010 it brings up a red error bar that says "Protected View. Office has detected a problem with this file. Editing it may harm your computer. Click for more details." However, when we tell it to allow editing anyway, the file seems perfectly operational, and we can save it as an XLS and open it again without any problem.
We have a suspicion that this may have something to do with validation. We have seen this problem when we put validation ranges on one worksheet but the validated cells on another. Apparently later versions of Excel (XLSX) allow this but Excel 2003 (XLS) does not. When this happened, we would get this notification on opening but ALSO an error on SAVING. Now that we've moved the validation ranges to the same sheet, the XLS we save is perfectly functional despite the warning on open.
We're afraid that this warning will scare our customers.
The Inputs sheet contains both the validated cells (e.g., H19:I24). These are being validated against $F$324:$F$327 on the same worksheet. The validation appears to work just fine.
Thanks for the update. As you can see from the attached file, the error persists. I will try to come up with a small example but that may be difficult. In the meantime, could you take a look at the XLS file and see whether there's anything you can learn about it? Can you verify that you get the error/warning when you open it?
Shakeel, I believe I've isolated the cause of the problem. It appears that there is a 33 character limit to the length of ErrorTitle in XLS format. XLSX format, at least in Excel 2010, doesn't have this limitation. If you write an XLS from .Cells with more than 33 characters in this field, then Excel 2010 will give a protection error when loading the file.
Ideally, it would be nice if you truncated these on output so as to not generate an illegal XLS, but at least we know what the problem is now.
We areencountering issue in this category. Please see the attached simple runnable proejct. Once the XLS file is generated, Office throws exception as Editing may harm your computer.
After initial investigation, we were able to replicate this issue using the latest version: Aspose.Cells
for .NET v7.3.4.2
We have logged this issue in our database. We will look into this issue and fix it. Once the issue is fixed or we have some other update for you, we will let you know asap.
We areencountering issue in this category. Please see the attached simple runnable proejct. Once the XLS file is generated, Office throws exception as Editing may harm your computer.
When XLSX file is generated, things are OK.
Please advise.
Arul
Hi,
Thanks for your posting and using Aspose.Cells.
We have looked into your project and found, there is a little mistake that should be rectified.