Libre setup
You should be able to download the ReStackor demo, double click the install file, enter the “ReStackor” password and run the demo.
However, there are numerous ways that gets messed up:
Incorrect file paths
No read/write access to the C:\ drive
Security disabled spreadsheet macros
Fixes for common setup problems are shown below.
Allow spreadsheet macros to execute
Shim ReStackor I/O and calculation results are loaded into the spreadsheet through macros. To allow macros to run they must be manually enabled when a spreadsheet is opened. Click on “Enable Macros” to allow the macros to run.
Some paranoid computer systems disable all macros without notification. To enable macros on those systems you have to go deeper into the menu system as shown further down in this HowTo.
Turn off link updating
LibreOffice spreadsheets update links when opened. That wipes out the data in the spreadsheet and loads any junk that is laying around from previous calculations. To prevent that from happening set:
Tools/Options/LibreOffice Calc/General: and set “Update links when opening” to “Never”
File paths
The install directory for ReStackor must be C:\ReStackor. All spreadsheet macros and I/O files are hardwired to work on that path. No other file path will work.
Once installed, the spreadsheets in C:\ReStackor\OpenOffice can be copied, renamed and run from any directory on the computer.
Run from command prompt
Running ReStackor directly from a command prompt is the most direct method to diagnose problems. Missing directories, bad file formats or read/write access permissions will show up as error messages when run from the command prompt.
A ReStackor spreadsheet has to be run at least once to generate the C:\ReStackor\Work\Stack.in input file. If that file is missing the code won’t make it far as the first thing the code does is try and read that input file.
- Go to “Start Menu” and type “command prompt”
- Select “Command Prompt”
- cd C:\ReStackor\Code
- Move to C:\ReStackor\Code working directory
- dir
- List contents of directory
- restackor.exe
- Run ReStackor calculations
File read/write access
The C:\ReStackor directory and all of the subdirectories and files need to have User read/write access. Virus scanners may disable access requiring permissions to be manually set.
To check for access permissions:
- Go to the C:\ReStackor directory in explorer
- Right click (not left) on the file or folder
- Select “Properties”
- Select “Security”
- Select “Authenticated Users”
- Set “Modify, Read & execute, List folder contents, Read and Write” to Allow
Enable spreadsheet macros
Shim ReStackor calculations and file I/O are loaded into the spreadsheet through macros. To allow the macros to run they must be manually enabled when a spreadsheet is opened.
Click on “Enable Macros” to allow the macros to run.
Some computer systems disable all macros with no prompt for optional permission. If the “Enable Macros” options does not appear when the spreadsheet is opened you have to go deeper in the menu system to enable macros.
- Click on “Tools”
- Click on “Options”
- Click on “LibreOffice”
- Click on “Security”
- Click on “Macro Security…”
- Click on “Medium”
Europe Dot/Decimal
Shim ReStackor file I/O requires periods (.) for decimals and commas (,) for field separators. To setup Excel and Libre OpenOffice spreadsheets to use dots for decimals:
- Click on the start menu and type “control panel”
- Click on “Control Panel”
- Under “Clock and Region” select “Change date, time, or number formats”
- Click on “Additional settings…”
- Set “Decimal symbol:” to . (period)
- Set “List separator:” to , (comma)