fxl
fxl copied to clipboard
zero-one-group
fxl is a Clojure spreadsheet library
Hi, I'm loving this approach to building spreadsheets in Clojure. I'm wondering if support for using arbitrary colours in cell styles is planned as the [current colour selection](https://github.com/zero-one-group/fxl/blob/develop/src/zero_one/fxl/colours.clj) is fairly...
https://github.com/zero-one-group/fxl/blob/a2f36e9f5482b2df9456d9a97309e7b904e11c60/test/zero_one/fxl/core_test.clj#L30 Based on some tests, it seems that the colours in the `test/resources/dummy-spreadsheet.xslx` are incompatible with `.getFillForegroundColor`. Colours are however read correctly from files generated with fxl. This might be...
Formula cells currently take cached values and display them as they are Have a flag to re-evaluate formulas with `setForceFormulaRecalculation` https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFSheet.html#setForceFormulaRecalculation-boolean- Or stuff here https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/FormulaEvaluator.html
```clj (let [cell (list (fxl/->cell {:coord {:row 0 :col 0}}))] (fxl/concat-right cell cell)) ``` cell has to be wrapped in a list like so to work
https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFSheet.html#addMergedRegion-org.apache.poi.ss.util.CellRangeAddress-
This was another data format from reading the previous `dummy-spreadsheet.xslx` but seems like `0.00` does exactly this already. Not sure what is different per se `"0.00_ ;\\-0.00\\ "`
Previous was implied by (fact "Font style should be preserved") by removal of font-size 11 since it was a default but have since changed it as the default font size...
I see an opportunity to shape a dataset into fxl cells. Would the project take on `tech.ml.dataset` as a dependency? Perhaps it's best as a utility namespace or other library.
