Axolot Data

Hello! Thank you, but the values seem not to be correct. If I set the pixelwidth2 of a column to e.g.500 pixels and open the file afterwards, excel tells me that the width of the column is 497 pixels. This is only a minor issue if i format just one column but i need to format lots of columns and the...

Hi!
Can you reproduce the problem with the code and the image file above?

Here is a screenshot of the result (if I open the text.xlsx file in excel):
http://workupload.com/file/J3HKJR9d

Yes, of course. I can reproduce it with every image. The easiest way to see the problem is to create a jpg with a colored square in Ms Paint and add this to an excel file using the code above. -> The square is stretched to an rectangle (open the created text.xlsx and right click on the image in the ...

If I set the pixelSize of a row or column the width or height of the column/row is very inaccurate. It seems also to be very inconsistent. Small example: XLS := TXLSReadWriteII5.Create(nil); XLS.Filename := 'D:\test.xlsx'; .... XLS[0].Columns[0].PixelWidth := 64 <-results in '56'. ... for i = 0 to 1...

In addition to my last comment regarding the stretched images: If I manually correct the scaling via excel (via right click on the image -> Size and Properies > reset ) and compare the changes in the xml structure of the file I can see differences in xl/drawing1.xml: The excel file which is produced...

You can solve it by temporarily turning of range checks and overflow checks in unit xpgPXML.pas function TXpgReadXML.QNameHashA: longword; {$IFOPT R+} {$DEFINE R_PLUS} {$RANGECHECKS OFF} {$ENDIF} {$IFOPT Q+} {$DEFINE Q_PLUS} {$OVERFLOWCHECKS OFF} {$ENDIF} function TXpgReadXML.QNameHashB: longword; v...

1. Okay, thanks for the clarification. 2. Yes, I am sorry, I forgot that line in the code example. Stupid mistake :) 3. Thanks, works now! Nevertheless there seems to be some unexpected results in some cases or I am doing something wrong: 1. When I write an image with scale factor 1, the image is al...

There seems to be several issues regarding images in excel files: 1. XLS.IsEmpty function returns true for both XLS and XLSX: procedure TForm1.Button1Click(Sender: TObject); var XLS: TXLSReadWriteII5; begin XLS := TXLSReadWriteII5.Create(nil); XLs.Filename := 'D:\test.xlsx'; XLS.Insert(0); XLS.Items...

Hi! I am using the latest version 5.20.51: Reading an existing excel file that contains an image does not work. Repro is simple: Just create an excel file with an image and try to read the file: lExcelFile := TXLSReadWriteII5.Create(nil); lExcelFile.Filename := 'C:\test\test.xlsx'; lExcelFile.Read; ...

I have updated to 5.20.50 and I can no longer reproduce the problem. So it seems to be fixed due to some other changes I guess

Hi! Recently we received several bugreports from our customers with the following callstack: Exception Message : Access violation at address 000000000103EB8E in module 'Project.exe'. Write of address 000000000000000D. 350 1791 Project.exe XLSMMU5 TXLSMMURebuildVector.WriteVector +56 714 930 Project....

Unfotunately still problems with some values which needs more than one value to escape like: test_x1111__xfabc_ which should be escaped two times -> test_x0005F_x1111_x0005F_xfabc_ but this is not done. If there is no easy fix without a regex, maybe you could use the regex solution with {$if Compile...

Hi. I am using v5.20.49 and use the AutoWidthCol function to adjuste the cell width of user defined cells like '125,5 KB'. Unfortunately most of the time the widest cell is cut of a bit. I have debuged the code and the problem is caused by a wrong while loop in XLSMask5.pas function TExcelMask.Forma...

Thanks for your fix. Unfortunately your solution without regex seems to be wrong (50.20.48). Our xlsx unit tests fail since
strings like "test_x1001_test" is not escaped to "test_x005F_x1001_test" like expected.