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/
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 -
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
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
On Sun, 2024-01-28 at 12:21 -0800, Jim Gibson via beginners wrote:
> Check out the OpenOffice::OODoc module on CPAN:
> <https://metacpan.org/pod/OpenOffice::OODoc::Intro>
>
> The documentation is a little sparse, especially with regard to “spreadsheet”
> mode, and I don’t ha
Check out the OpenOffice::OODoc module on CPAN:
<https://metacpan.org/pod/OpenOffice::OODoc::Intro>
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 th
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
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
Hi,
is there a way to create libreoffice spreadsheets (ods) similar to
Excel::Writer::XLSX?
There is OpenOffice::OODoc and I don't see how to create spreadsheet
documents with that.
Is there still no way to do that?
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional comma
