cell reference style lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- kjteng · 2018-05-06 05:44 How can I change the cell reference style to R1C1 format in fpSpread? ---------------------------------------------------------------------- wp · 2018-05-06 07:55 You can't. I began this project, but did not finish it so far. ---------------------------------------------------------------------- kjteng · 2018-05-06 09:08 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 · 2018-05-06 09:38 In fpsutils you can find these: Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i function ParseCellRangeString_R1C1(const AStr: string; ABaseRow, ABaseCol: Cardinal;  out AFirstCellRow, AFirstCellCol, ALastCellRow, ALastCellCol: Cardinal;  out AFlags: TsRelFlags): Boolean;function ParseCellString_R1C1(const AStr: String; ABaseRow, ABaseCol: Cardinal;  out ACellRow, ACellCol: Cardinal; out AFlags: TsRelFlags): Boolean; overload;function ParseCellString_R1C1(const AStr: string; ABaseRow, ABaseCol: Cardinal;  out ACellRow, ACellCol: Cardinal): Boolean; overload; function GetCellString_R1C1(ARow, ACol: Cardinal; AFlags: TsRelFlags = [rfRelRow, rfRelCol];  ARefRow: Cardinal = Cardinal(-1); ARefCol: Cardinal = Cardinal(-1)): String;