Re: https://metacpan.org/pod/OpenOffice::OODoc

I don't. Mike On 1/31/24 16:51, hw wrote: Ok and how do you do it with OpenOffice::OODoc? -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/

Re: https://metacpan.org/pod/OpenOffice::OODoc

On Tue, 2024-01-30 at 20:45 -0600, Mike wrote: > FWIW, in Spreadsheet::WriteExcel I do this: Ok and how do you do it with OpenOffice::OODoc? > $sheet = $book1 -> worksheets(2) -> {Name}; > $sheet = $book1 -> worksheets($sheet); > $sheet -> Activate; > > $sheet -> Range("B2") -> Activate; > $ex -

Re: https://metacpan.org/pod/OpenOffice::OODoc

FWIW, in Spreadsheet::WriteExcel I do this: $sheet = $book1 -> worksheets(2) -> {Name}; $sheet = $book1 -> worksheets($sheet); $sheet -> Activate; $sheet -> Range("B2") -> Activate; $ex -> ActiveWindow -> {FreezePanes} = "True"; Mike On 1/28/24 16:26, hw wrote: So how do I freeze rows/col

Re: https://metacpan.org/pod/OpenOffice::OODoc

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

Re: https://metacpan.org/pod/OpenOffice::OODoc

On Sun, 2024-01-28 at 12:21 -0800, Jim Gibson via beginners wrote: > Check out the OpenOffice::OODoc module on CPAN: > > > The documentation is a little sparse, especially with regard to “spreadsheet” > mode, and I don’t have Libre Office on my

Re: https://metacpan.org/pod/OpenOffice::OODoc

Check out the OpenOffice::OODoc module on CPAN: The documentation is a little sparse, especially with regard to “spreadsheet” mode, and I don’t have Libre Office on my system to test it out, but the following code produces an ods file that can

Re: https://metacpan.org/pod/OpenOffice::OODoc

On Thu, 2024-01-25 at 20:28 -0600, Mike wrote: > It can be done with a Perl module: > https://unix.stackexchange.com/questions/723650/editing-libreoffice-calc-spreadsheets-in-the-terminal > > I have not tested that. I do not want to edit spreadsheets in a terminal. There's some other software fo

Re: https://metacpan.org/pod/OpenOffice::OODoc

It can be done with a Perl module: https://unix.stackexchange.com/questions/723650/editing-libreoffice-calc-spreadsheets-in-the-terminal I have not tested that. Mike On 1/25/24 13:05, hw wrote: Hi, is there a way to create libreoffice spreadsheets (ods) similar to Excel::Writer::XLSX? Th