Skip to content

After using insertDate, all subsequent insertTexts with the applied format are defined as dates #548

@ovsyan

Description

@ovsyan

I am using version 1.5.8 and found that after the first use of insertDate - all subsequent columns are assigned its format even if it is a text cell with a different format.

Could there be a problem with the new version? Which of the older versions can I try?

Example:

 for ($rowIndex = 1; $rowIndex <= 20; $rowIndex++) {
    $xlsxFile->insertText($rowIndex, 0, 'name' . $rowIndex);
    $xlsxFile->insertDate($rowIndex, 1, time());
    $xlsxFile->insertDate($rowIndex, 2, time(),'dd/mm/yyyy');
    $xlsxFile->insertText($rowIndex, 3, round(123 / 1000, 2), "# ##0.00");
    $xlsxFile->insertText($rowIndex, 4, 42 * $rowIndex, '# ##0.00 [$₽-419];-# ##0.00 [$₽-419]');
}

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions