Search found 13 matches

by flls
Wed Mar 05, 2014 5:39 pm
Forum: XLSReadWritwII 6
Topic: Problem with images
Replies: 10
Views: 4270

Re: Problem with images

This is exactly the problem occurs when I use the mouse wheel, there was no attempt to do so before. Thanks, I'll be awaiting the next version with the fix.
by flls
Fri Feb 28, 2014 1:22 pm
Forum: XLSReadWritwII 6
Topic: Problem with images
Replies: 10
Views: 4270

Re: Problem with images

I have the latest version, but the image always appears above the TXLSSpreadSheet component, in the same position. Is it a problem in my code for displaying the image? I'm doing the following: procedure TPlanAnuncios.LoadPic(const aXLS: TXLSReadWriteII5; const cl, rw, ts: Integer; const FileName: St...
by flls
Fri Feb 28, 2014 12:43 pm
Forum: XLSSpreadSheet
Topic: Comments displayed incorrectly
Replies: 0
Views: 6869

Comments displayed incorrectly

When I add a comment to a cell TXLSSpreadSheet component, the comment is identified correctly in the cell (with the little red arrow) but pass the mouse over the cell, is drawn a huge line from the cell to the upper left corner of the spreadsheet and does not display the comment text. When you open ...
by flls
Fri Feb 28, 2014 12:34 pm
Forum: XLSSpreadSheet
Topic: Add new sheet
Replies: 8
Views: 11814

Re: Add new sheet

I installed version 2.00.5 but nothing has changed, still without drawing new sheets in TXLSSpreadSheet component. Although not view the sheets in the component when the spreadsheet is saved to disk and open in the Excel sheets are displayed correctly, then the problem is with the TXLSSpreadSheet co...
by flls
Thu Feb 27, 2014 9:55 pm
Forum: XLSReadWritwII 6
Topic: CopyColumns and CopyCells not update the formulas reference
Replies: 5
Views: 3571

Re: CopyColumns and CopyCells not update the formulas reference

SOLVED the problem for Excel2007 spreadsheets (.xlsx) For Excel2007 spreadsheets just put the " XLS.CompileFormulas " command after the "XLS.Read" (open the spreadsheet) command or before the "XLS.Write" (save the spreadsheet) command. Excel97 spreadsheets and earlier ...
by flls
Thu Feb 27, 2014 7:34 pm
Forum: XLSReadWritwII 6
Topic: CopyColumns and CopyCells not update the formulas reference
Replies: 5
Views: 3571

Re: CopyColumns and CopyCells not update the formulas reference

I noticed one thing analyzing the code of your example "CopyMoveDelete". If I have in cell "B1" to the following formula: "=A1*10" When I copy the cell "B1" using the command: XLS.CopyCells(0,1,0,1,0,0,2,0); // Copy B1:B1 from Sheet0 to C1 the cell "C1&qu...
by flls
Thu Feb 27, 2014 6:42 pm
Forum: XLSReadWritwII 6
Topic: CopyColumns and CopyCells not update the formulas reference
Replies: 5
Views: 3571

Re: CopyColumns and CopyCells not update the formulas reference

I installed version 5.20.18a but still with the same error when copying cells that contain formulas. It's hard for me to explain because my native language is Portuguese and not English, but I will try to demonstrate using your sample application called "CopyMoveDelete". 1) Open the sample...
by flls
Tue Feb 11, 2014 9:13 pm
Forum: XLSSpreadSheet
Topic: Add new sheet
Replies: 8
Views: 11814

Re: Add new sheet

In the current version of TXLSSpreadSheet there is no more "InvalidateSheet (Sheet)" method, it was replaced by "InvalidateSheet ()" method (without parameters). The problem is that this method is not drawing new worksheets. How do I draw them now? TXSLReadWriteII V5.20.15a TXLSS...
by flls
Mon Feb 10, 2014 5:26 pm
Forum: XLSReadWritwII 6
Topic: CopyColumns and CopyCells not update the formulas reference
Replies: 5
Views: 3571

Re: CopyColumns and CopyCells not update the formulas reference

larsa wrote:Hello

Please try the latest update.
Unfortunately the problem persists in the new version. :cry:
by flls
Mon Feb 10, 2014 5:22 pm
Forum: XLSReadWritwII 6
Topic: Problem with images
Replies: 10
Views: 4270

Re: Problem with images

Hello Please try the latest update. Thank you, the picture appeared in the new version, but it is not anchored in the cell. When we roll the screen in the component, the image is always above the screen in the same position. When I open the spreadsheet in Excel, the image is anchored properly and s...
by flls
Mon Feb 10, 2014 4:58 pm
Forum: XLSReadWritwII 6
Topic: Error exchanging XLS.Version to xvExcel97
Replies: 1
Views: 1441

Error exchanging XLS.Version to xvExcel97

In version 5 when I try to change the version for Excel97 the following error occurs: List index out of bounds (0) followed by error: Access violation at 0x02550286: read of address 0x00000014 The code used for the test is as follows: XLS := TXLSReadWriteII5.Create(nil); // Creates with Default Vers...
by flls
Mon Feb 10, 2014 3:39 pm
Forum: XLSReadWritwII 6
Topic: Problem with images
Replies: 10
Views: 4270

Re: Problem with images

When I insert an image does not appear in TXLSSpreadSheet component. When I open the spreadsheet in Excel, the following text appears in place of the image: Unable to display this image at the time. The same problem occurs with "Advanced_Invoice" sample that came with the component. XLSSpr...
by flls
Fri Feb 07, 2014 9:14 pm
Forum: XLSReadWritwII 6
Topic: CopyColumns and CopyCells not update the formulas reference
Replies: 5
Views: 3571

CopyColumns and CopyCells not update the formulas reference

I have a template excel sheet with the structure of a calculation of daily costs. This worksheet has a hidden column that contains only formulas that are later copied for daily columns. I open the worksheet model with TXLSSpreadSheet component and then copy them hidden column for each day that I am ...