Recent

« previous next »
Pages: [1]

Author Topic: How to get cell address  (Read 646 times)

veb86

  • Jr. Member
  • **
  • Posts: 60
How to get cell address
« on: July 04, 2024, 08:33:34 am »
Hello
I have a row number and a column number.
How to get the cell address?
I searched for ready-made functions and couldn't find anything. I can write it myself, but suddenly I didn’t find it.
For example
function GetCellAddress(iRow,iCol:Cardinal):string;
(0,0) => "A1"
Logged

wp

  • Hero Member
  • *****
  • Posts: 12288
Re: How to get cell address
« Reply #1 on: July 04, 2024, 09:10:52 am »
Code: Pascal  [Select][+][-]
  1. function GetCellString(ARow, ACol: Cardinal; AFlags: TsRelFlags = (rfRelRow, rfRelCol)): String;
and similar ones in unit fpsUtils.
Logged

veb86

  • Jr. Member
  • **
  • Posts: 60
Re: How to get cell address
« Reply #2 on: July 04, 2024, 09:31:14 am »
Quote from: wp on July 04, 2024, 09:10:52 am
Code: Pascal  [Select][+][-]
  1. function GetCellString(ARow, ACol: Cardinal; AFlags: TsRelFlags = (rfRelRow, rfRelCol)): String;
and similar ones in unit fpsUtils.

Thank you. I only looked inside fpSpreadsheet
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018