opening file in JWorkbook does not lock file

[plon...@gmail.com]

When calling JWorkbook.openWorkbook in most cases the Excel file is not locked i.e. we can open the same file in Excel and edit it.

However on certain machines it IS locked, so we are confused.   Under what circumstances is the file locked?  And would we not expect it to be locked by the process opening the file?

[Anna Dolbina]

Hi,

Is it correct that you observe the "File is locked for editing by another user" in some environments, but this error is not reproducible in other environments?

The general description of this error and a few possible causes can be found in the following article:

https://support.office.com/en-us/article/Excel-file-is-locked-out-for-editing-to-another-user-6fa93887-2c2c-45f0-abcc-31b04aed68b3?ui=en-US&rs=en-US&ad=US

In addition, could you please check whether the presence of this error is related to the installed Microsoft Excel version?
Also, does the order in which the same workbook is opened by Microsoft Excel application and JExcel affect the observed behavior?
For example, is the same error present if you open the workbook in Microsoft Excel first and then open it using JExcel?

Sincerely,
Anna

On Fri, Dec 8, 2017 at 11:23 PM, <plon...@gmail.com> wrote:

When calling JWorkbook.openWorkbook in most cases the Excel file is not locked i.e. we can open the same file in Excel and edit it.

However on certain machines it IS locked, so we are confused.   Under what circumstances is the file locked?  And would we not expect it to be locked by the process opening the file?

--
You received this message because you are subscribed to the Google Groups "JExcel Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jexcel-forum+unsubscribe@teamdev.com.
To view this discussion on the web visit https://groups.google.com/a/teamdev.com/d/msgid/jexcel-forum/938ca95d-cfa8-41e7-acd3-671056f579be%40teamdev.com.