Superimposing unnecessary styles odfdom-java 0.9.0

[Nikita78787878]

I'm building tables ranging in size from 15 by 36.

Up to 360 and 400
But with the small ones, and with the big ones, I face the problem of incorrect cell outline, as well as incorrect cell union.

The solution was found by experiment
if you clear the borders across the entire table after creating the table, then the incorrect outline and other unnecessary styles go away.

here is an example

CLEAR_BORDER_UP_TO_COLUMN and CLEAR_BORDER_UP_TO_ROW - The value is 40

OdfSpreadsheetDocument odsFile = OdfSpreadsheetDocument.newSpreadsheetDocument();

        OdfTable table = odsFile.getTableByName(ODS_DEFAULT_SHEET_NAME);
        table.setTableName(SHEET_NAME);

        clearTableBorders(odsFile, table);

ublic void clearTableBorders(OdfSpreadsheetDocument odsDocument, OdfTable table) throws Exception {
OdfOfficeAutomaticStyles styles = odsDocument.getContentDom().getAutomaticStyles();

    OdfStyle noBorderStyle = styles.newStyle(OdfStyleFamily.TableCell);
    noBorderStyle.setStyleNameAttribute(NO_BORDER_STYLE);
    noBorderStyle.setProperty(OdfTableCellProperties.Border, TYPE_BORDER_NONE);

    for (int col = 0; col <= CLEAR_BORDER_UP_TO_COLUMN; col++) {
        for (int row = 0; row <= CLEAR_BORDER_UP_TO_ROW; row++) {
            OdfTableCell cell = table.getCellByPosition(col, row);
            TableTableCellElement cellElement = (TableTableCellElement) cell.getOdfElement();
            cellElement.setTableStyleNameAttribute(NO_BORDER_STYLE);
        }
    }
}          

But I have a 360 by 400 table.
And as you know, you can't go through the cells there.

Has anyone come across this, do you have any advice?
I will be very glad

[svanteschubert]

Hi Nikita,

Just some quick remarks:

1. Please try the latest release of ODFDOM (0.12.0), please even try the master branch (0.13.0-SNAPSHOT)
   There is a ZIP with all JARs to be downloaded at GitHub under ODFTOOLKIT releases.
   You may as well download or use in Maven the latest SNAPSHOT release.
2. If you create a new ODF document
   OdfSpreadsheetDocument odsFile = OdfSpreadsheetDocument.newSpreadsheetDocument();
   The ODF document within the JAR is being taken, which is being updated from version to version.
   Look intot his directory - https://github.com/tdf/odftoolkit/tree/master/odfdom/src/main/resources
   If you use the master branch, you will load this document with newSpreadsheetdocument()
   https://github.com/tdf/odftoolkit/blob/master/odfdom/src/main/resources/OdfSpreadsheetDocument.ods
   Therefore, download the ODS and open it in LibreOffice (LO) and see if there is a problem with styles.
   Or you might edit the ODS in LO to have the table styles you like - and even tweak the ODF XML afterwards.

Does this already help you, Nikita?

All the best,
Svante

[Nikita78787878]

I can't use the latest version of the library because there are 8 java projects on the project and unfortunately I can't raise the version (Tell me more about your idea about Newspread sheetdocument()! And I have to open it in R7 because the customer has this program. Based on this, please help me, I've been suffering for 2 months now.

[svanteschubert]

PS: And in the end - after editing - you might load the your ODS as default instead of the default from the jar with newSpreadsheetDocument()!

[Nikita78787878]

I can't use the latest version of the library because there are 8 java projects on the project and unfortunately I can't raise the version (Tell me more about your idea about Newspread sheetdocument()! And I have to open it in R7 because the customer has this program. Based on this, please help me, I've been suffering for 2 months now.

[svanteschubert]

Load an ODS like in this test and adopt the styles of the ODS earlier in LibreOffice according to the customer's desires! :-)

[Nikita78787878]

I did as you said, it didn't help, the bug remained