Please enable JavaScript to view this site.

A-Shell 7.0 Release Notes

LIBXL.BSI [131] includes several fixes, refinements, and enhancements:

•Increase the stack size (needed for libxl.dll 3.8.5+)
•Support changes to the calling signatures of some existing functions.
•Add sheet parameter default to definition of several Sheet-related functions so it can be omitted in case of a single sheet workbook.
•Add tempfile$ parameter to LoadBook and SaveBook function (may reduce memory requirements for very large files).
•Add optional sheetindex, firstrow and lastrow params to the LoadBook() function to allow loading a partial file
•Add SheetSetTabColor()
•Add lastrow option to SheetSetRow() to operate on a range of rows.
•Add password and enhanced options to SheetSetProtect()
•Add NamedRange functions
•Add option to GetColWidth() and GetRowHeight() to return size in pixels.
•Fix problems with the fit-to-cell scaling option in SheetSetPicture() and SheetSetPicture2().