Package org.spdx.spreadsheetstore.ods

package org.spdx.spreadsheetstore.ods
Custom Apache POI adapter layer using the SODS library to provide OpenDocument Spreadsheet (ODS) support.

This package maps the Apache POI org.apache.poi.ss.usermodel interfaces to the underlying com.github.miachm.sods library.

Standard spreadsheet styling elements (colors, fonts, alignments, text wrapping, and cell borders) are fully supported.

Limitations

Custom cell data formatting (e.g., specific number formats and custom date patterns) has limited support due to the underlying SODS 1.10 library. SODS only natively supports plain text ("@") or an ISO date format ("YYYY-MM-DD").

Consequently, any target cell format representing a date is mapped to the standard "YYYY-MM-DD" format, while custom numerical and string format patterns remain unstyled.

This is a display-only limitation. Date/time values are still stored with full HH:mm:ss precision in the cell's underlying office:date-value attribute; only the visual rendering in spreadsheet applications (e.g. LibreOffice, Excel) is truncated to the date portion.

  • Classes
    Class
    Description
    OdsCell
    Adapter for Apache POI Cell over the SODS Range.
    OdsCellStyle
    Adapter for Apache POI CellStyle over the SODS Style.
    OdsComment
    Adapter for Apache POI Comment over SODS OfficeAnnotation.
    OdsCreationHelper
    Adapter for Apache POI CreationHelper for ODS documents.
    OdsDataFormat
    Adapter for Apache POI DataFormat for ODS documents.
    OdsFont
    Adapter for Apache POI Font over SODS styles.
    OdsRichTextString
    Adapter for Apache POI RichTextString for ODS documents.
    OdsRow
    Adapter for Apache POI Row managing a specific row in a SODS Sheet.
    OdsSheet
    Adapter for Apache POI Sheet over a SODS Sheet.
    OdsWorkbook
    Adapter for Apache POI Workbook over a SODS SpreadSheet.