Axolot Data

I also needed comments: var ... comments : TXLSComments; begin ... //..Copy comments comments := XLS[aSrcSheetId].Comments; for i := 0 to comments.Count-1 do begin //TODO - Add size info when that is actually available. (Currently not 7/10/2015) - Matt W XLS[aDestSheetId].Comments.Add(comments[i].Co...

MLG, This was my fix for copying sheets as merged cells aren't the only thing that doesn't copy. This gets everything I was concerned about. Hopefully this is helpful procedure SetSheetProperties(aSheetId: integer); begin //Freeze panes XLS[aSheetId].FreezePanes(2,4); //Set the groups to have the co...

Row height (ht attribute) is correctly passed on to the xml, however the customHeight attr is not passed because it is not set unless setting the height before the row is created. This does not cause a problem when all rows in the worksheet have the same height, but shows up when trying to make them...

Issue resolved I verified that if the ca attribute is added to the formulas both the hyperlinks and the formulas with names will calculate in 2007. Verified by setting this in WriteFormula procedure of TXLSWriteSheetData.OnWriteCell Cell.F.CA := true; I then played around until I found the followin...

When opening in Excel 2007 and then saving, the formula tag for the cell does not contain the aca nor ca attribute. When I edit the cell and save it, the ca attribute is added. <c r="C6" s="6"> <f ref="C6:R6" t="shared" si="0">InputCell</f> <v>0</v> ...

Are these being written out as Text cells instead of Formula cells?

When using AsFormula to create a cell, the formula cell created will have a result of 0 when opened in Excel 2007. When opening in 2010 and 2013 the cell shows the result of the formula as expected. This appears to only be the case when the formula is not a plain arithmetic formula. For Instance: Co...

Lars, I apologize for being so quick to label this as a bug. Here is what I've found. Specifying the column format does work if the sheet name is also passed in. The sheet name is correctly adjusted in the name definition when a sheet is renamed. From my code example above, the following correctly g...

I was incorrect in the xml generation needed. Below is correct and when I alter TCT_DefinedNames.Write to generate this way the xlsx pulls up correctly. <definedName name="InputCell" >INDIRECT("R[-1]C",FALSE)</definedName> <definedName name="_TotalPremium" localSheetId=...

Using version 50.20.41. Column names are corrupting the xlsx and not allowing it to be opened. Excel's recovery of this is to remove the names and clear cells that referenced. Based on the xml generated, it appears that any sheet specific names will corrupt the xlsx but I haven't tested that out. XL...

See viewtopic.php?f=16&t=2330&p=5683&sid=9e ... 0a8a#p5683. I posted code that will work for the Data Validations
(I'm using 50.20.41)

I'm using version 50.20.41: As Lars hasn't answered and I had to get this working for a project I'm on, here is my solution: The xpgParserXLSX unit has a lot of TODO comments and looks unfinished. The TCT_DataValidations.WriteAttributes procedure below needs to be replaced with the following. proced...

I'm upgrading from ver 4 in which I was able to specify the size of the comment box when adding a comment. Using version 50.20.41 I am struggling to determine how to specify the size. I have adjusted the code to the following, but although the Col1/2 and Row1/2 properties are read and write, it does...

Here's a workaround for anyone that is having the same problem: Change the following in the TXLSWorksheet.AutoWidthCol function of the XLSSheetData5 unit Original if FCells.FindCell(ACol,FCells.IterCellRow,C) and (FMergedCells.CellInAreas(ACol,FCells.IterCellRow) <= -1) then begin Workaround if FCel...

Lars, The TXLSWorksheet.AutoWidthCol appears to ignore all cells within a merged cell area when looking for the largest cell pixel length in the column. I'm guessing this is a bug as Excel does not ignore merged cells when auto setting the width. I can understand skipping if the merge areas has mult...