So after I searched through the forums here and read as much of possible treads outside, I regret to find put that issues with key windows software are still persisting after 10-12 years of development.
MS Excel is a kind of application that should be the main focus of development for compatibility with CrossOver Office, since its features are not replicated by anything - not Libre Calc, not Google Sheets, not anything.
Installing add-ins in Excel (one of the key unique features) is still in shambles. I tried to help out with the following bash script:
!/bin/bash
Set CrossOver environment variables
export CX_ROOT="/home/junior/.cxoffice/"
export CX_BOTTLE="Microsoft_Office"
export WINEPREFIX="$CX_ROOT/$CX_BOTTLE"
export WINELOADER="/opt/cxoffice/bin/wine"
export WINESERVER="/opt/cxoffice/wineserver"
export path of solver
export LD_LIBRARY_PATH="$WINEPREFIX/drive_c/Program Files/Microsoft Office/root/Office16/Library/SOLVER"
Launch MS Excel with Solver
/opt/cxoffice/bin/wineloader /opt/cxoffice/lib/wine/i386-windows/winewrapper.exe --run -- /home/junior/.cxoffice/Microsoft_Office_2016/drive_c/Program Files/Microsoft Office/root/Office16/EXCEL.EXE
The script worked somewhat as I finally was able install it, BUT it is unusable, as the macros are disabled, and it uses multiple macros to run.
Note that I bought CrossOver Office EXACTLY TO NOT DEAL WITH THIS TYPE OF BS, and needing to script my way to using common windows functionalities.
Also it seems like you need to fine tune a LLM, for the help, since here is what I get in ChatGPT almost nothing.
