Read and modify openoffice / libreoffice spreadsheets

[Kulrom]

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.

[Kulrom]

v 0.4.5 fixed ODS::GetCellValue() - fixed returned result if link in cell 11/10/2024

[blueb]

Thanks for the updates.. it's appreciated.

[Quin]

Nice, keep up the good work!

[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!

[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

[idle]

thanks this is great to have for PB.