Mirror of forum.nim-lang.org

11218 :: xl and excelin both turn external file references to all lowercase

• mszs (orginal) [2024-03-14T13:14:39+01:00] view original

  I am generating xlsx files from nim. When a formula contains a reference to an external file (e.g. 'file:///home/User/...') I can assert that the formula is set correctly. But when I open the file in libreoffice calc, for example, the path to the external file is all lowercase (e.g. 'file:///home/user/...'). I wanted to debug this in gdb, but ran into issues (posted in another thread). Since this happens with both xl and excelin, I'm suspecting that this could be either a problem in parsexml itself or a common mistake in both projects in the way they are using parsexml. I'd love to inspect this further, but the problem I have with gdb stops me here.

---

• Araq (orginal) [2024-03-14T15:19:39+01:00] view original

  Just add some echo statements for debugging. It works.

---

• mszs (orginal) [2024-03-16T17:37:50+01:00] view original

  Thanks for this workaround. It did help me on this occasion. But, of course, it's not a replacement for debugging in general. On this occasion I ended up dereferencing the links to the external files and so I do not run into the problem. Again, that's not a solution, just a workaround.

  I did not fully investigate the problem, but I used the libraries to look into a file written out from LibreOffice and there the external references use shared strings. Might have something to do with what I'm seeing here...

---