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:
2.Agree to macros
3.On 'Calcs' sheet, click run regression
BASIC runtime error
Multiple regression variable selection window with column header shown.
User Profile Reset: No
I have no other information at this time.
Created attachment 166557 [details]
Spreadsheet that shows problem
This sheet does work fine with MS excel.
Have not yet investigated the bug, but I should say why not try the built-in regression analysis funtion in Calc? (Data - Statistics...)
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: 184.108.40.206.alpha0+ / 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