kjn

You can write any table as list table. When a table is in a list table form, you have access to individual table cells. This means you can pick and...

That is a nice bug you have run in to ... It gave me good insights on where the ODS exporter falls short and how it can be improved. I...

**_One of the "multi-box" comments says that the `TBLFM` formula MUST BE A MIRROR IMAGE of `LO Calc` formula .... as long as this condition is meant by hook-or-crook, ODS...

Let me know how my `ISBLANK` fix fared on your end > So I have somehow to try to translate the formulas ... Start with LO end ... and teach...

> SolutionRemyGauthier.ods **There is no one to one correspondence between the `org` file and the `ods` file.** **I will just copy paste what I have gathered from the files, and...

> [org-vslookup.txt](https://github.com/kjambunathan/org-mode-ox-odt/files/12869721/org-vslookup.txt) > > [ods-vslookup.ods](https://github.com/kjambunathan/org-mode-ox-odt/files/12869725/ods-vslookup.ods) Thanks. Looks good. Notes to myself ... ```lisp (("Final1" . "of:=VLOOKUP([.A2];[Table1.$A$1:.$G$7];7;FALSE())") ("Final2" . "of:=[$Table1.G2]")) ``` ``` #+name: Final1 | Name  | Table1 | Table2 |...

I have pushed a fix. I remember we having some discussion about locale-specific rendering of date in gnumeric / libreoffice calc, and some of the decisions I made in regards...

> I always obtain the format 26/07/2023 while I would prefer 26.07.2023 as in the ods export. You aren't saying if you flipped the following boolean _locally_ or not ......

Try flipping the value of `automatic-order` in the following places https://github.com/search?q=repo%3Akjambunathan%2Forg-mode-ox-odt+number%3Aautomatic-order+path%3A%2F%5Eetc%5C%2Fstyles%5C%2F%2F&type=code

This is how you identify the styles that would be of interest to you: In the `content.xml` of `ods` file search for date of interest, say `C-s 2023`. ```xml ```...