Bug 137629 - Calc Error when trying to use a regression analysis spreadsheet
Summary: Calc Error when trying to use a regression analysis spreadsheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
Reported: 2020-10-20 17:49 UTC by davew99
Modified: 2022-04-01 08:25 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:

Spreadsheet that shows problem (185.33 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2020-10-20 17:52 UTC, davew99

Note You need to log in before you can comment on or make changes to this bug.
Description davew99 2020-10-20 17:49:12 UTC
I have a regression analysis spreadsheet that gets an error when I go to execute the macros? (maybe).  When the sheet goes to determine the columns available, it gets a Basic runtime error.  If I click ok, then I do get the Mulitiple Regression variable selection window, but there is nothing there to select.
I am hoping that you all can help as I would really rather use your all product and not MS.

Steps to Reproduce:
1.Open spreadsheet
2.Agree to macros
3.On 'Calcs' sheet, click run regression

Actual Results:
BASIC runtime error

Expected Results:
Multiple regression variable selection window with column header shown.

Reproducible: Always

User Profile Reset: No

Additional Info:
I have no other information at this time.
Comment 1 davew99 2020-10-20 17:52:35 UTC
Created attachment 166557 [details]
Spreadsheet that shows problem

This sheet does work fine with MS excel.
Comment 2 Kevin Suo 2020-11-10 05:01:06 UTC
Have not yet investigated the bug, but I should say why not try the built-in regression analysis funtion in Calc? (Data - Statistics...)
Comment 3 Buovjaga 2022-04-01 08:25:47 UTC
BASIC runtime error.
Property or method not found: Cells.

Pointing to line

FinalCol = Application.Cells(1, 255).End(xlToLeft).Column

Arch Linux 64-bit
Version: / LibreOffice Community
Build ID: 678446780446ae568ee8b1b814158c54ea5e393f
CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded Jumbo
Built on 1 April 2022