Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CalcCellValue silently fails when formula is =OTHER_CELL and OTHER_CELL has a formula evaluation error #1936

Open
paolobarbolini opened this issue Jul 2, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@paolobarbolini
Copy link
Contributor

paolobarbolini commented Jul 2, 2024

Description

CalcCellValue returns an empty string, with no error, if the evaluated cell references another cell (=OTHER_CELL) that contains a formula that fails to evaluate.

Steps to reproduce the issue:

  1. Create a new Excel file
  2. Write a number in A1
  3. Write a string in B1
  4. Write =A1+B1 in C1
  5. Write =C1 in D1
  6. Call CalcCellValue on D1

Repository: https://github.com/paolobarbolini/excelize-repro-1936

Describe the results you received:

An empty string is returned, with no error

Describe the results you expected:

A formula evaluation error

Output of go version:

go version go1.22.4 linux/amd64

Excelize version or commit ID:

4e6457accde38876ecdf8bb1c6f1e8bce8fd2139

Environment details (OS, Microsoft Excel™ version, physical, etc.):

Arch Linux with LibreOffice Calc v24.2.4-2

@xuri xuri added the bug Something isn't working label Jul 2, 2024
abdelaziz-ouhammou added a commit to abdelaziz-ouhammou/excelize that referenced this issue Jul 22, 2024
…OTHER_CELL and OTHER_CELL has a formula evaluation error bug
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants