Skip to content

Formulas in the Excelfile where not exportet to CSV #6

@clangrock

Description

@clangrock

Cells with formulas are not exported correctly to CSV.

My solution for this Bug is in the function "CopyTemplatesToExportWorksheet"
at Line 299
delete:
ws.Range("A1").CurrentRegion.Copy ExportWorksheet.Cells(FirstBlankRow, 1)
insert:
ws.Range("A1").CurrentRegion.Copy
ExportWorksheet.Range("A" & FirstBlankRow).PasteSpecial xlPasteValues '// copy only Values

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions