[Libreoffice-bugs] [Bug 144252] New: Compatibility issues with cell summation formulas across worksheets

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144252

            Bug ID: 144252
           Summary: Compatibility issues with cell summation formulas
                    across worksheets
           Product: LibreOffice
           Version: 7.2.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dongshili at qq.com

Description:
=SUM($'1'.B3:$'10'.B3)

Use this formula to calculate the sum of cells B3 in worksheets 1-10; After the
first creation of the formula, it works fine, but after saving it as *.xlsx and
re-opening the table, the formula becomes =SUM('1':$'10'.b3 :B3), and the cell
displays an error message: #NAME?



In my tests, the same tables and formulas were saved as *.xls and *.ods without
error.

So I think it's a formula compatibility issue.


=SUM($'1'.B3:$'10'.B3)
使用这个公式来计算1-10工作表内B3单元格的和；在初次创建这个公式后，可以正常使用，但是保存为*.xlsx格式后，重新打开表格，公式就变成了=SUM('1':$'10'.B3:B3)，单元格内显示的错误信息是：#NAME?

经过我的测试，同样的表格和公式，当保存为*.xls和*.ods格式时，并没有发生错误。
所以我认为这是一个公式的兼容性问题。

Steps to Reproduce:
1.Open my attachment test.xls or test.ods, view the formula and result, and
save it as *.xlsx

Actual Results:
Open a new XLSX file, look at the formula

Expected Results:
Find problems and solve them


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210902/f121e1b5/attachment.htm>