Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Packages and Libraries
»
FPSpreadsheet
»
cell reference style
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
IRC channel
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
TiniFile alters inifile c...
by
polinkuer12
[
Today
at 05:27:15 am]
Distro has depreciated qt...
by
TheMouseAUS
[
Today
at 03:26:50 am]
[solved]FP IDE(FP.exe) fa...
by
gasensor
[
Today
at 03:00:19 am]
For-in loop over constant...
by
dsiders
[
Today
at 02:18:24 am]
ThumbControl : how to loa...
by
the_magik_mushroom
[
Today
at 01:48:57 am]
[solved] Iteration of cla...
by
Joanna
[
Today
at 01:45:47 am]
leetcode doesn’t support ...
by
Joanna
[
Today
at 01:18:56 am]
Demoscene Square dot flag...
by
TRon
[
Today
at 01:10:22 am]
How does Castle Game Eng...
by
michalis
[
Today
at 01:07:14 am]
How to use the Event Log?
by
piola
[
Today
at 12:18:19 am]
[solved] Lazarus does not...
by
RayoGlauco
[
Today
at 12:09:11 am]
How to: create DLL file f...
by
paule32
[April 15, 2024, 10:57:14 pm]
Azure sql database will n...
by
wpflum
[April 15, 2024, 09:04:08 pm]
Your best UI design - con...
by
Lulu
[April 15, 2024, 08:51:36 pm]
Is it possible to open a ...
by
Martin_fr
[April 15, 2024, 08:50:05 pm]
JCF - File location query...
by
bglazuser
[April 15, 2024, 08:02:40 pm]
Adding a named separator
by
440bx
[April 15, 2024, 06:54:21 pm]
SDL2 Software_Render
by
mosquito
[April 15, 2024, 06:36:41 pm]
RayLib 5.0
by
mosquito
[April 15, 2024, 06:35:40 pm]
How can I draw a rectangl...
by
TRon
[April 15, 2024, 06:20:57 pm]
Does anyone know how to p...
by
paule32
[April 15, 2024, 06:07:15 pm]
[re-opened] Package PPU l...
by
CCRDude
[April 15, 2024, 06:07:09 pm]
BUG REPORT: Unable to gen...
by
gasensor
[April 15, 2024, 06:03:15 pm]
How to pass the value of ...
by
Remy Lebeau
[April 15, 2024, 05:46:29 pm]
Lazreport: Question about...
by
teco
[April 15, 2024, 04:34:12 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: cell reference style (Read 2775 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?
Logged
wp
Hero Member
Posts: 11906
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.
Logged
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.
Logged
wp
Hero Member
Posts: 11906
Re: cell reference style
«
Reply #3 on:
May 06, 2018, 11:38:01 am »
In fpsutils you can find these:
Code: Pascal
[Select]
[+]
[-]
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
;
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Packages and Libraries
»
FPSpreadsheet
»
cell reference style
TinyPortal
© 2005-2018