f35f22fan / ods2 Goto Github PK

Is it possible to get cell's position by its contents?
I have an ods which acts as template for a report. It contains cells with MAGIC identifiers. It needs to replace this MAGIC identifiers with actual data.
Iterate over all cells isn't efficiently - because rows and columns count may be variant.

Hello,

I am trying to build Ods2 by Visual Studio 2022 (C++20) on Win10, and I got two build errors:

1. regarding headers that are related to linux: fatal error C1083: Cannot open include file, No such file or directory
   #include <dirent.h>
   #include <sys/sysmacros.h>
   #include <zstd.h>

2. fatal error LNK1104: cannot open file '..\lib\Debug\ods.lib'

I need your help please to be able to build your Ods2 lib.

Thank you.
Mahmoud Wali

The cleanup method only checks for Date and Time but not for DateTime and will leak the QDateTime Pointer on destruction.

Hi,
I have .ods, it has first 2 cells on the row, which are empty.
If I do row->GetCell(0)->is_empty() I get true, and row->GetCell(0)->ValueToString() returns "" that is correct
but row->GetCell(1)->is_empty() returns false, and row->GetCell(1)->ValueToString() returns value of third cell, same as
row->GetCell(2)->is_empty() returns false, and row->GetCell(2)->ValueToString() returns value of third cell, which is correct

Row in the .ods/content.xml is defined as

 <table:table-row table:style-name="ro1">
               <table:table-cell table:number-columns-repeated="2" />
               <table:table-cell table:style-name="ce4" office:value-type="date" office:date-value="2021-06-02" calcext:value-type="date">
                  <text:p>02.06.2021</text:p>
               </table:table-cell>

Do you use number-columns-repeated property somehow when loading cells? Or just when saving them?

Sometimes it's usefull to set a custom text decoration to a number style. I.e. in cases where you want to add an unit to a number.

The resulting number style requires to look like this example:

<number:currency-style style:name="ncs1">
<number:number number:decimal-places="4" number:min-integer-digits="1"/>
<number:text> Unit</number:text>
</number:currency-style>

This could be achieved by adding

inst::NumberText *NumberCurrencyStyle::NewText()
{
	auto *p = new NumberText(this);
	Append(p);
	return p;
}

to NumberCurrencyStyle.cpp

Calling cell->SetDateTime(dateTime); causes that in the content.xml an entry is created which can not be read by libreOffice Version: libreoffice-7.3.2.2

The created entry looks like this:
<table:table-cell office:value-type="date-time" office:value="2022-10-31T10:09:41"/>

In order to make it compatible with libreOffice the office:value-type needs to be changed to date without "-time".
Implementing this change keeps it still loading correctly in Microsoft Office.