Rating in Excel assessment not updating on Mac and Online Versions

[marc-on-github]

Hello,

I've encountered a problem with the OWASP SAMM Excel Assessment tool that might affect other users as well. The tool works fine on a Windows system, but there are issues when using it on macOS and in the online version of Excel (Office 365).

Problem:

• On macOS and in the online version of Excel, the rating in the assessment tool does not update even when all the inputs are correctly entered.
• The tool works as expected on a Windows system, where the ratings are updated accordingly.

Steps to Reproduce:

1. Download the OWASP SAMM Assessment tool and open it on a Mac or in the online version of Excel.
2. Perform the assessment and input the required data into the appropriate fields.
3. Notice that the rating does not automatically update.

Expected Behavior:

The rating should automatically update regardless of the operating system or Excel version being used, once the data is entered.

Actual Behavior:

On macOS and in the online version of Excel, the rating remains unchanged even after the data is inputted.

[SebaDele]

Hello Marc, Thank you for raising this issue. Can you let us know what language setting you have and use on your system? We recently fixed an issue with formulas that did not update in languages other than English.

Can you check if you have the same issue with this version: https://github.com/owaspsamm/toolbox-spreadsheet/blob/main/resources/SAMM_spreadsheet.xlsx

thank you Seba

[johnellingsworth]

@marc-on-github

I tested the file available at the link @SebaDele shared (Version 2.0.10) on OSX and did not encounter functional issues with the desktop version; the web version has some quirks with formatting - font changing to bold & italic - but functionality it worked as expected.

Any chance you can share screenshots, or a screen recording? It will provide better context.