Search found 14 matches

by mclot
Mon Nov 27, 2023 9:55 am
Forum: XLSSpreadSheet
Topic: What about new Delphi 12 support?
Replies: 2
Views: 507

Re: What about new Delphi 12 support?

Great! :D

Thank you very much and best regards
Massimo
by mclot
Fri Nov 24, 2023 12:47 pm
Forum: XLSSpreadSheet
Topic: What about new Delphi 12 support?
Replies: 2
Views: 507

What about new Delphi 12 support?

Hi,
when will you release a new version including the support for Delphi 12 Athens?

Thanks in advance and best regards
by mclot
Tue Jul 04, 2023 9:42 am
Forum: XLSSpreadSheet
Topic: Problem with formula referring to another sheet
Replies: 0
Views: 693

Problem with formula referring to another sheet

Hi Larsa, if you try to enter a formula in a cell with a reference to another sheet (e.g. =Sheet1!C1), after typing the sheet name and pressing the ! key, the error message "Unknow sheet reference type: "00" appear. Instead, if I enter the formula without the ! and add it after, then ...
by mclot
Thu Jun 29, 2023 4:01 pm
Forum: XLSSpreadSheet
Topic: Invalid XLate code
Replies: 5
Views: 6294

Re: Invalid XLate code

Hi Larsa, there's a big problem in this last XLSSpreadSheet3 build (3.00.17): this bpl does not include the components of the XLSRWII6 bpl (TXLSDbRead5, TXLSExportHTML5, TXLSGrid and TXLSReadWriteII5 do not appear in the components palette and my program build fails). This didn't occur before (v. 3....
by mclot
Tue Jun 20, 2023 8:44 am
Forum: XLSSpreadSheet
Topic: Invalid XLate code
Replies: 5
Views: 6294

Re: Invalid XLate code

Hello,
this old bug is still alive in my current version 3.0.0.13, thus never fixed (and no feedback received).

Please, any news ???
Can you help me?

Thanks a lot
Luigi
by mclot
Wed Jan 08, 2020 1:06 pm
Forum: XLSSpreadSheet
Topic: Invalid XLate code
Replies: 5
Views: 6294

Re: Invalid XLate code

Hello,
any news ???
Can you help me?

Luigi
by mclot
Mon Sep 09, 2019 10:24 am
Forum: XLSSpreadSheet
Topic: Invalid XLate code
Replies: 5
Views: 6294

Invalid XLate code

Hello,
if I try to set a formula on a cell that is configured with a cell format (backround color, text color, etc.), writing the character '=', the error message "Invalid XLate code" appears.

Can you help me?

Thank you very much!
Luigi
by mclot
Tue Jun 25, 2019 2:21 pm
Forum: XLSSpreadSheet
Topic: How retrieve the color of the cells
Replies: 1
Views: 5028

How retrieve the color of the cells

Hi,
I'm trying to retrieve the color of the cells of an Excel file through the following properties "cell [Col, Row]. CellColorRGB" or "cell [Col, Row] .FillPatternForeColorRGB but the value I get is not the same as the cell color questioned.
Can you help me?

Thank you very much!
Luigi
by mclot
Wed May 29, 2019 11:46 am
Forum: XLSSpreadSheet
Topic: XLSSpreadsheet in a frame
Replies: 1
Views: 4916

XLSSpreadsheet in a frame

Hi, I created a frame that contains an XLSSpreadSheet component and a form that contains that frame. When I try to open the form on the Delphi project, after saving it, an exception like this is raised: " Access violation at address 0F1FE13A in module "XLSSpreadSheet3_D2007.bpl " and ...
by mclot
Tue May 21, 2019 3:19 pm
Forum: XLSSpreadSheet
Topic: Text does not appear in some cells
Replies: 1
Views: 4728

Text does not appear in some cells

Hi, i created a multi sheet excel file with the XLSReadWritwII 6 component and when I open this file with Microsoft Excel, all the cells appear correctly but if I open the same file with XLSSpreadSheet component, on different cells the text does not appear even if present. Can you help me ? Thank yo...
by mclot
Fri May 10, 2019 8:03 am
Forum: XLSSpreadSheet
Topic: Sheet assign problem
Replies: 1
Views: 4947

Sheet assign problem

Hi, i'm using the XLSSpreadSheet component and I want to copy a sheet from XLSSpreadSheet.XLS.Sheets (XSS) to another XLSReadWrite componenet (XLS) through this code: XLS.Sheets[0].Assign(XSS.XLS.Sheets[0]); but if the source sheet contains a cell with formula, sheet.assign command raise an error li...
by mclot
Wed Oct 24, 2018 12:04 pm
Forum: XLSSpreadSheet
Topic: Screen coordinates of selected cell
Replies: 1
Views: 5116

Screen coordinates of selected cell

Hi,
i'm using the XLSSpreadSheet component and I want to show a lookup combo box just under left-top corner of particular cell when selected.
How do I get screen coordinates of selected cell like TCustomGrid.CellRect function or MouseToCell procedure ?

Thank you very much!
Massimo
by mclot
Wed Jul 11, 2018 12:09 pm
Forum: XLSSpreadSheet
Topic: Vertical alignment of text in cells
Replies: 1
Views: 5017

Vertical alignment of text in cells

Hello guys, we're already using the XLSSpreadSheet component, previous release. We recently downloaded the demo of the last version of XLSSpreadSheet and we still have the following problem (also in previous release): cells with vertical alignment of text are not correctly displayed. In Excel 2016 t...
by mclot
Thu Aug 27, 2009 8:07 am
Forum: XLSReadWriteII 3/4/5
Topic: XLSReadWriteII2 performance issue
Replies: 1
Views: 2290

XLSReadWriteII2 performance issue

I'm using the XLSReadWriteII2 component (v. 3.01.02) with Delphi7 to create and read excel files in a terminal server environment (Citrix). My big problem is that if the file to create or to read is on the user local disk and not on the terminal server disk, the performances are terrifying! For exam...