Page 2 of 2
Re: Read and modify openoffice / libreoffice spreadsheets
Posted: Wed Aug 07, 2024 7:52 am
by Kulrom
blueb wrote: Fri Jul 26, 2024 4:12 pm
Hi Kulrom
I'll having issues with 6.11 LTS (x64) on line 347
Apparently some changes in:
AddPackMemory(zip_out, 0, 0, entry_name$)
Doesn't seem to like zeros
Hi, blueb!
I haven't installed version 6.11 yet. I'm using version 6.10. New versions are coming out too often
My mistake was here: instead of
AddPackMemory(zip_out, 0, 0, entry_name$) I needed to use the more suitable function
AddPackDirectory(zip_out, entry_name$) to create directories inside the archive.
Apparently, something changed in Packer Library in 6.11. Everything should be fine with
AddPackDirectory().
I posted a new version of the module in the topic.
Re: Read and modify openoffice / libreoffice spreadsheets
Posted: Fri Oct 11, 2024 1:41 pm
by Kulrom
v 0.4.5 fixed ODS::GetCellValue() - fixed returned result if link in cell 11/10/2024
Re: Read and modify openoffice / libreoffice spreadsheets
Posted: Sat Oct 12, 2024 1:03 pm
by blueb
Thanks for the updates.. it's appreciated.
Re: Read and modify openoffice / libreoffice spreadsheets
Posted: Sat Oct 12, 2024 2:17 pm
by Quin
Nice, keep up the good work!
Re: Read and modify openoffice / libreoffice spreadsheets
Posted: Tue Oct 15, 2024 11:25 am
by Kulrom
Hello everyone! I am posting two updates at once. While working with the module, problems with cells in which the text has several lines or styles were detected.
Now GetCellValue() returns the entire text.
Using SetCellValue(), you can write multi-line text to a cell. The separator is the line break character (~"\n")
Code: Select all
; v 0.4.6 fixed ODS::GetCellValue() - fixed returned result if type is "percentage"
; added constant #percentage for write values in percents 14/10/2024
; v 0.4.7 fixed ODS::GetCellValue() - fixed returned results if multirows and multiformated text in cell 15/10/2024
; modify ODS::SetCellValue() - added the ability to write multi-line text
Updated code in the start message!
Re: Read and modify openoffice / libreoffice spreadsheets
Posted: Thu Nov 21, 2024 6:27 am
by Kulrom
i am posting update
Code: Select all
; v 0.5.0 The internal mechanism for allocating memory has been changed. It is now a list
; Added ODS::freeAndNull() - The macro clears the memory and resets the variable.
; v 0.5.1 Fixed ODS::SaveOdsBook() - added support PB version < 611
Updated Module in first message
Re: Read and modify openoffice / libreoffice spreadsheets
Posted: Thu Nov 21, 2024 6:33 am
by idle
thanks this is great to have for PB.