TimG1964

possible release notes for v0.11.0

12

(EDIT1 18-Sep - to reflect comments from @nhz2, below) (EDIT2 19-Sep - to reflect #321 from @nhz2) (EDIT3 09-Oct - to reflect #326 (proposed `setFormula` function) and add list of...

Question: Should cells containing errors return missing?

2

``` julia> XLSX.getcell(f[1], "M4") XLSX.Cell(M4, "e", "", "#DIV/0!", "", XLSX.Formula("1/0", nothing, nothing, nothing)) julia> f[1]["M4"] missing ``` I ask this because I'm looking at how `FileIO.jl` and the related `ExcelFiles.jl`...

How to add a file to the package artifacts?

2

IIUC, artifacts seem to be created from here: "https://www.dropbox.com/s/9rgm3pnd1dmzmy9/xlsx_artifacts.tar.gz?dl=1" I need to add a new artifact so that XLSX.jl can understand dynamic array functions like `SORT` or `UNIQUE`. This is...

This worksheet has the formulas `=UNIQUE(D1:D10)` in cell F1 and `=SORT(C1:C10,,-1)` in cell G1. These formulas belong to a family that produce "spill" ranges, and you can see this for...

``` julia> f=XLSX.openxlsx("mynewtest.xlsx", mode="w") XLSXFile("C:\Users\tim\.julia\artifacts\c0b84c4a80d13f58b3409f4a77d4a11455b5609e\blank.xlsx") containing 1 Worksheet sheetname size range ------------------------------------------------- Sheet1 1x1 A1:A1 julia> s=f[1] 1×1 XLSX.Worksheet: ["Sheet1"](A1:A1) julia> s["A1"]=" " " " julia> s["A2"]=" hello" " hello"...

Illegal characters can corrupt exported xlsx file

1

Rarely, I can find a csv file that contains illegal characters (e.g. 0x02, 0x03, etc). An example of such a file can be downloaded from [here](https://nationallottery.dcms.gov.uk/data) (CAUTION: big CSV file)....

Writing to a cell in a template overwrites existing formats

1

If I open an xlsx file as a template, populate some cells and then save to a new file, the formatting in the template gets overwritten with the default style....