Recent

Author Topic: cell reference style  (Read 2767 times)

kjteng

  • Sr. Member
  • ****
  • Posts: 259
cell reference style
« on: May 06, 2018, 07:44:58 am »
How can I change the cell reference style to R1C1 format in fpSpread?

wp

  • Hero Member
  • *****
  • Posts: 11855
Re: cell reference style
« Reply #1 on: May 06, 2018, 09:55:34 am »
You can't. I began this project, but did not finish it so far.

kjteng

  • Sr. Member
  • ****
  • Posts: 259
Re: cell reference style
« Reply #2 on: May 06, 2018, 11:08:19 am »
Is there a procedure or method to convert r1c1 to A1 format . It is not difficult to write such method but if there is one then i would not recreate the wheel.

wp

  • Hero Member
  • *****
  • Posts: 11855
Re: cell reference style
« Reply #3 on: May 06, 2018, 11:38:01 am »
In fpsutils you can find these:

Code: Pascal  [Select][+][-]
  1. function ParseCellRangeString_R1C1(const AStr: string; ABaseRow, ABaseCol: Cardinal;
  2.   out AFirstCellRow, AFirstCellCol, ALastCellRow, ALastCellCol: Cardinal;
  3.   out AFlags: TsRelFlags): Boolean;
  4. function ParseCellString_R1C1(const AStr: String; ABaseRow, ABaseCol: Cardinal;
  5.   out ACellRow, ACellCol: Cardinal; out AFlags: TsRelFlags): Boolean; overload;
  6. function ParseCellString_R1C1(const AStr: string; ABaseRow, ABaseCol: Cardinal;
  7.   out ACellRow, ACellCol: Cardinal): Boolean; overload;
  8.  
  9. function GetCellString_R1C1(ARow, ACol: Cardinal; AFlags: TsRelFlags = [rfRelRow, rfRelCol];
  10.   ARefRow: Cardinal = Cardinal(-1); ARefCol: Cardinal = Cardinal(-1)): String;

 

TinyPortal © 2005-2018