On Sun, 2024-01-28 at 22:44 +0100, hw wrote: > Hmm, cellValue() always puts text. How do I put numbers and formulars > instead?
Ok, it's cellFormula(), and you have to change the value type of every cell that should contain anything having a type different from the default type of the sheet. Ugh ... I'll have to write a wrapper for that so the cell value type is being adjusted automatically, at least for text and floats. How efficient is that ... So how do I freeze rows/columns? I always feeze the first row by default ... I haven't seen anything in the documentation yet that would allow to freeze the view. -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/