bss-xlsx

bss-xlsx

About this fork

This fork has bben made on order to provide xlsx-style a simple way to add comments to cells.

It is done by adding plain dataValidation.

workbook.Sheets[SheetName]['!dataValidation'] = [ {sqref: 'Cell_of_reference', title: "title_message", message: "message"}, ... ]

Comment will appear when focusing cell

License

Please consult the attached LICENSE file for details. All rights not explicitly granted by the Apache 2.0 license are reserved by the Original Author.

It is the opinion of the Original Author that this code conforms to the terms of the Microsoft Open Specifications Promise, falling under the same terms as OpenOffice (which is governed by the Apache License v2). Given the vagaries of the promise, the Original Author makes no legal claim that in fact end users are protected from future actions. It is highly recommended that, for commercial uses, you consult a lawyer before proceeding.

References

ISO/IEC 29500:2012(E) "Information technology — Document description and processing languages — Office Open XML File Formats"

OSP-covered specifications:

• [MS-XLSB]: Excel (.xlsb) Binary File Format
• [MS-XLSX]: Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format
• [MS-OE376]: Office Implementation Information for ECMA-376 Standards Support
• [MS-CFB]: Compound File Binary File Format
• [MS-XLS]: Excel Binary File Format (.xls) Structure Specification
• [MS-ODATA]: Open Data Protocol (OData)
• [MS-OFFCRYPTO]: Office Document Cryptography Structure
• [MS-OLEDS]: Object Linking and Embedding (OLE) Data Structures
• [MS-OLEPS]: Object Linking and Embedding (OLE) Property Set Data Structures
• [MS-OSHARED]: Office Common Data Types and Objects Structures
• [MS-OVBA]: Office VBA File Format Structure
• [MS-CTXLS]: Excel Custom Toolbar Binary File Format
• [MS-XLDM]: Spreadsheet Data Model File Format
• [MS-EXSPXML3]: Excel Calculation Version 2 Web Service XML Schema
• [XLS]: Microsoft Office Excel 97-2007 Binary File Format Specification

Open Document Format for Office Applications Version 1.2 (29 September 2011)

Badges