Axolot Data

Thanks!

Hello, Thanks for answer, but maybe we did not understand. I have a cell with some formatting(color,font...) and a value ('XYZ'). How clear cell VALUE ('XYZ') without losing formatting? In previous version xlsrw 4 I use AsBlank:= true, cell is cleared and formatting preserved. In version xlsrw 5 is ...

Hello,

how to keep the cell format after calling Cell[x, y].AsBlank: = true; in current version XLSRW ?

In version XLSRW 4 remained formatting preserved.

Thank PMal

OK, now I look viewtopic.php?f=16&t=2206&p=5322&hilit= ... 9a8e#p5322
Visibility property is propably solution...

PMal

Hello,

I found viewtopic.php?f=16&t=2192&p=5263&hilit= ... 6d68#p5263

Is implemented? I cannot find Hidden property of TXLSWorksheet object.
Or is other way how hide worksheet?

Thanks PMal

Hello, I testing XLSRW v.5 in our application (before buying upgrade from v.4). Please help me. How rewrite this code in version 5 v4 - worked procedure RepairLockList; var K: Integer; begin with xlsReadWrite do for K:= 0 to Sheets.Count - 1 do Sheets[K].SheetProtection:= DefaultSheetProtections; en...

Hello, I have a big problem with XLSReadWriteII. I have file Sample.xls. I run this simple procedure under Delphi 2010: Procedure Test; var XLS: TXLSReadWriteII4; path: string; begin XLS:= TXLSReadWriteII4.Create(nil); path:= ExtractFilePath(Application.ExeName); CopyFile(pchar(path + 'sample.xls'),...

Hi, > Where did you download the newer versions? On the XLSReadWriteII version history page the newest version mentioned is 4.00.26. from axolot.com/components/f_downloadreg.htm . Sometimes I testing if new version is available... > P.S. It seems that Larsa takes long holidays as usual! Grrrrrrrrrrr...

Version 4.00.29 have the same bug.

PMal

Steps to reproduce: 1) create new empty test.xls file in Excel 2) set Sheet1 as Protected with password 3) set Sheet1 as NON Protected 4) save test.xls and close Excel 5) read test.xls with XLSW.Read; 6) write test.xls with XLSRW.Write; 7) open test.xls in Excel. Sheet1 stay incorrectly set as Prote...

Version 4.00.28 have the same bug.

PMal

Hi,

after upgrade XLSRW from 4.00.25 to 4.00.26/27 in D2009/D2010 IDE raise exception "Error reading form: TSheet.MergedCells". This property in version 4.00.26/27 is invalid for property editor.

What is wrong?

Thanks, PMal