Cell formula failed to update when it contains named range


Version: 2024b

Type: Bug Fixes

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-28869


The bug started in Origin 2022 when named range was introduced.

One example to reproduce the bug

  1. Fill Col(A) with row numbers.

  2. Highlight column A and choose Data: Define Name (Ctrl+L)…

  3. Set Name as alpha and Scope: Book. Click OK.

  4. In B1, type a formula =total(alpha) and press Enter to see calculated value.

  5. Change any value in Column A

==> B1 failed to update.

Fixed in Origin 2024b