Troubleshooting.
- Important! Recalculate the full workbook to
ensure that all formulas were updated. The build-in Excel key combination for
workbook recalculation is
Ctrl+Alt+F9
. We also added a shorter
Ctrl+Shift+C
key combination for the majority of the aplications.
(If full workbook recalculation is not performed, some of the objects will not be
recalculated and will not exist on the server. As a result, the results will not
be calculated correctly. For example, in some cases whenever you save the workbook, Excel attempts
to recalculate partially the Excel formulas resulting in incorrect state of the
formulas being saved. After you force recalculation of all formulas and disable the
calculations, it is safe to save the file with the assurance that the correct
state of all formulas is being saved).
- Output array resizing Array output is modelled using array functions in the
applications. Whenever the size of the function array is less than the output
array size, the output outside the function array bounds is not displayed.
Whenever the size of the function array is greater than the output array size,
the function array cells, which are outside the output array bounds, are filled
with N#A. To ensure that the size of the function array matches the output array,
we execute the macros that estimates and adjusts the size of the function array.
Parameters of each function array must be configured in the Excel application.
The macros short-cut is
Ctrl+Shift+R
key combination.
- Connection. If the connection is performed
using localhost, the applications should work on most computers. If however the
connection is made to alexacom, the client Excel application is behind the
corporate firewall, and the addin uses binary protocol for connection, the
connection and data transfer will most likely fail. The http protocol is currently
not working (but will likely be fixed and tested).
- Fail to register functions. This typically happens if a new version
of xlloop addin was copied into the folder to replace the old or the java server
was started after xlloop and the functions were not registered. The non-registered
are not recognized by Excel and
#NAME
error is displayed in the respective cells.
To fix the problem, you need to reload the xlloop addin via the
File> Options> Add-Ins
menu option and then recalculate the
application (Ctrl+Shift+R
).
- Java fails to start. Java server requires 512m of memory (memory size
can be set in the addin configuration file). If there is not enough memory,
the "Error occurred during initialization of VM. Could not reserve enough space
for object heap" will be thrown and java server will fail to start.
- Stability. Stability of XLLoop addin is still being tested.
For more details on XLLoop project development status see
xlloop notes page.