E.Naumovich

Hi, CMake 4 looks like dont want to recognize cmake_minimum_required(VERSION 2.8) in CMakeLists.txt with strange error message. I replaced it with cmake_minimum_required (VERSION 3.15) It works.

This is commercial software, and producer is not very cooperative in such matters. There are chances that issue related to the resolved problem of the actual size of the sheet, but I cannot prove it at that moment. It looked like this: I create new project in this software, it is using number of the xlsx files to fetch data. At creation everything looks fine. But if I save project and than reopen, it cannot fetch data again. So I started re-save xlsx automatically and insisted other users to do ...

In general better to re-save generated file from Excel. There are no problems with reading for the Excel , but there are no guarantee concerning third party software. I have strange issues with some. 100% implementation of the xlsx for me looks problematic, however it is question to Alexandr Belyak.

Very likely it is an issue of the not-100% implementation of the Excel internal structures in generated file. When Excel opens generated file, it prepared these structures automatically and then wants to save them. In you case it might be result of the formula calculation. My suggestion is to save generated file from Excel if possible.

Hi, what about next release?

In case of the two-pass preparation of the sheet, usage of the memory buffer rather than file looks as more straight option.

There is an example, SimpleScratch.cpp, starting from line 125. You dont need to add row, you should prepare cell with desired coordinates and than add it to clsScratchTable. clsScratchTable Tbl; clsCell cl; cl.Set(0,2,CurTime,CustomDateTimeStyleIndex); Tbl.Add(cl); cl.Set(0,1,"Entry"); Tbl.Add(cl); cl.Set(0,0,"0:0"); Tbl.Add(cl); cl.Set(2,2,"2:2"); Tbl.Add(cl); cl.Set(3,0,"0:3, Long"); Tbl.Add(cl); cl.SetLong(3,1,std::numeric_limits<int64_t>::max()); Tbl.Add(cl); size_t Nr,Nc; CWorksheet::SParams...

There is a helper class, clsScratchTable, which is used to organize matrix-like filling of the xlsx. Its usage can be found in example "Samples\SimpleScratch.cpp" In general you have to open worksheet, to prepare styles for you needs, than you can make few ScratchTable's, for example one for each sheet you want to use. You can add cells to sheet, delete or replace added cell. When ScratchTable is finished, you can request its dimensions and then use them for filling xlsx file. Simple example can...