https://bugs.documentfoundation.org/show_bug.cgi?id=145040
--- Comment #2 from flywire <flywi...@gmail.com> --- Created attachment 175621 --> https://bugs.documentfoundation.org/attachment.cgi?id=175621&action=edit Spreadsheet to demonstrate range failure 1. Open LibreOffice Calc sheet untitled 1.xlsx with numbers in cells C3:G3 ($1.00 - $5.00) 2. Add the sum function to Cell B3 3. Can't define the range from G3 to C3 (only from G3 to D3) Note: Works if range is defined as C3:G3 Version: 7.2.0.3 (x64) / LibreOffice Community Build ID: 2a7ea282da28d665a7dc086360567b4aea27bf08 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-AU (en_AU); UI: en-GB Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.