We are using setPassword in Java to protect an Excel spreadsheet. This is working fine unless the password contains a dollar symbol in the middle of the text (e.g. test$test). It is even working fine if the password has a dollar at the end of the text (e.g. test$).
This leads us to suspect that $t is being treated as a special character, and is not being passed “as-is” to MS Excel. Have tried escaping the dollar symbol within the password (e.g. test\$test) in case it was a Java issue, but this has not made any difference. Indeed, changing test$ to test\$ just resulted in MS Excel requiring the additional slash character to be entered in the password.
Can you confirm whether this issue can be recreated, and whether there is a simple solution that will allow us to resolve it?
Thanks,
Kevan