LibreOffice Calc ledaancho pirogiraamera

Qorophishu Bido

Calc ledaanchuwatenni halashshate hayyo aanannohu giddo diru goofinoha xawissanno . Xaa geeshsha reqecciimootu horonnireetinna irkisaminoreeti, noo ledaanchuwa ledo sumaancho ikkasi buuxate, kayiinni haaroo ledaancho pirogiraamete ledate haaroo API assiishshahoroonsira hasiissannohe.


LibreOffice Calc can be expanded by Add-Ins, which are external programming modules providing additional functions for working with spreadsheets. These are listed in the Function Wizard in the Add-In category. If you would like to program an Add-In yourself, you can learn here which functions must be exported by the so that the Add-In can be successfully attached.

LibreOffice searches the Add-in folder defined in the configuration for a suitable . To be recognized by LibreOffice, the must have certain properties, as explained in the following. This information allows you to program your own Add-In for Function Wizard of LibreOffice Calc.

Ledaanchu Hedo

Mittu mittunku maxaafate mini batinye assiishshubba aanno. Gama assiishshubba gashshootu loosira kaa'litanno. Umikki assiishshubbara wo'munni xea ayee su'ma doodha dandaatto. Ikkollana, Insanosaino eishshi kaiminniuminsa wodhuwa harunsa noosa. Su'minsa nna seeru suudinsa garinni babbaxxitanno.

Functions of

Shiimunni, gashootu assiishshubba Asiishshukiiroafira nna AsiishshuDaataAfira heera noosi. Kuriu horoonsiratenni, assiishshunna eishshu borrowa nna qolantino hornyo gumulama noose. Qolantino hornyuwa gede, lamenna naanni fikiimu borruwa irkisantino. Eishshu gede, ledote bisiccote qarqarubba Double Array, naanni fikiimu dirra, nna Bisiccote Dirra irkisantino.

Eishshubba maqishsha horoonsidhe saino. Konni daafira, Kuriu hornyuwa kaimunni soorra dandiinanni. Ikkollana, kuni LibreOffice Calc giddo di"irkisamanno korkaatuno because isipiridishittete giddo tiro diaanno.

Maxaafate minnaharate yannara wirro higge hogowamanna amadubbansa gashshootu assiishshubbanni tittirama dandiitanno. Mittu mittunku assiishshira, eishshu kiirorinna borrori, gidoyiidinna gobayiidi assiishshi su'muwinna gashshootu kiiro taje amadino.

Asiishshubba suwashshonna uminsa gumma rakke qoltannore yaamante woshshantanno. Taalo yanna assiishshubba (suwashsho assiishshubba) yaate dandiinanni; ikkollana, insano tittirshunni dixabbino korkaatuno xurqu akati noonsahuraati.

Reqecciimo lainohunni xaphooma taje

Ledaanchu assiishshi giddo jawiidi kiiro LibreOffice Calc 16 ledo amadisiisantino: mitte qolantino hornyonna jawunni 15 assiishshi giddo ledi eishshubbaati.

Daatu borro aananno garinni tirantino:

Daatu borruwa

Tiro

CALLTYPE

Xullaallote hundaanni: FAR PASCAL (_far _pascal)

Wole: gade (assootu amuraate baxxitino gade)

USHORT

2 Byte malaatisantinokki intigere

DOUBLE

8 byte shae-irkiraancho suudishsha

Paramtype

Shaete-irkiraanchi law int

PTR_DOUBLE =0 lamu kulaancho

PTR_STRING =1 zeero-agurtino naanni fikiimi kulaancho

PTR_DOUBLE_ARR =2 lamu diri kulaancho

PTR_STRING_ARR =3 naanni fikiimu diri kulaancho

PTR_CELL_ARR =4 bisiccote diri kulaancho

NONE =5


functions

Following you will find a description of those functions, which are called at the .

For all functions, the following applies:

void CALLTYPE fn(out, in1, in2, ...)

Output: Resulting value

Input: Any number of types (double&, char*, double*, char**, Cell area), where the Cell area is an array of types double array, string array, or cell array.

GetFunctionCount()

Maqishshu eishshira gashootu assiishshi nookkiha assiishuwate kiiro qolanno. Mittu mittunku assiishshi baxxitino kiiro 0 nna nCount-1 mereerooti . Tini kiiroGetFunctionData nna GetParameterDescription assiishshubba gedenoonni hasantanno.

Ganallo

void CALLTYPE GetFunctionCount(USHORT& nCount)

Eishsha

USHORT &nCount:

Output: Reference to a variable, which is supposed to contain the number of Add-In functions. For example: If the Add-In provides 5 functions for LibreOffice Calc, then nCount=5.

GetFunctionData()

Ledaanchunniha baala hasiissanno taje gumulanno.

Ganallo

void CALLTYPE GetFunctionData(USHORT& nNo, char* pFuncName, USHORT& nParamCount, Paramtype* peType, char* pInternalName)

Eishsha

USHORT& nNo:

Input: Function number between 0 and nCount-1, inclusively.

char* pFuncName:

Output: Function name as seen by the programmer, as it is named in the . This name does not determine the name used in the Function Wizard.

USHORT& nParamCount:

Output: Number of parameters in AddIn function. This number must be greater than 0, because there is always a result value; the maximum value is 16.

Paramtype* peType:

Output: Pointer to an array of exactly 16 variables of type Paramtype. The first nParamCount entries are filled with the suitable type of parameter.

char* pInternalName:

Output: Function name as seen by the user, as it appears in the Function Wizard. May contain umlauts.

pFuncName nna pInternalName eishshubba fikiimu dirubbati, insano 256 bikkanni LibreOffice Calcgiddo loosu aana hossanno.

GetParameterDescription()

Ledaanchu assiishshihanna eishshuwasiha harancho xawishsha aanno. Doorshu gede, Kuni assiishshi Assiishshu Kaa'laanchigiddo assiishshanna eishshu xawishsha leellishate kaa'lanno.

Ganallo

void CALLTYPE GetParameterDescription(USHORT& nNo, USHORT& nParam, char* pName, char* pDesc)

Eishsha

USHORT& nNo:

Input: Number of the function in the library; between 0 and nCount-1.

USHORT& nParam:

Input: Indicates, for which parameter the description is provided; parameters start at 1. If nParam is 0, the description itself is supposed to be provided in pDesc; in this case, pName does not have any meaning.

char* pName:

Output: Takes up the parameter name or type, for example, the word "Number" or "String" or "Date", and so on. Implemented in LibreOffice Calc as char[256].

char* pDesc:

Output: Takes up the description of the parameter, for example, "Value, at which the universe is to be calculated." Implemented in LibreOffice Calc as char[256].

pName nna pDesc fikiimu dirubbaati; LibreOffice Calc giddo fikiimu 256 bikka ledo loosu aana hosino. Balloe Assiishshu Kaa'laanchi giddo shiqino fooqi is boodehonna 256 fikiimooti wo'mino garinni dikaa'lanno.

Bisiccote qarqarra

Aantanno shaubba daatu gano gobayiidi pirogiraame mojule bisiccote qarqarra sa"ate aamama noosi taje amaddino. LibreOffice Calc daatu dani kaiminni sase babbaxxitino dirra mereero badanno.

Lame dirubba

Eishshu gede, bisiccote qarqari hornyuwate Kiiro/lame dani sa"a dandiitanno. Lamu diri LibreOffice Calc giddo aananno garinni tiramino:

Offset

Name

Description

0

Caccafo1

Aliidi guraayiidi bisiccote qarqari waaco giddo caccafote kiiro. Kiiramme 0 nni hanaffanno.

2

Haawiittimma1

Aliidi guraayiidi bisiccote qarqari waaco giddo haawiittimmate kiiro; kiiramme 0 nni hanaffanno.

4

Shae1

Aliidi guraayiidi bisiccote qarqari waaco giddo shaete kiiro; kiiramme 0 nni hanaffanno.

6

Caccafo2

Woriidi qiniiti bisiccote qarqari waaco giddo caccafote kiiro. Kiiramme 0 nni hanaffanno.

8

Hawiittimma2

Woriidi qiniiti bisiccote qarqari waaco giddo haawiittimmate kiiro; kiiramme 0 nni hanaffanno.

10

Shae2

Woriidi qiniiti bisiccote qarqari waaco giddo shaete kiirooti; kiiramme 0 nni hanaffanno.

12

Kiiri

Aantanno miilla kiirooti. Mulla bisiccuwa dikiirantino woy sa'ino.

14

Caccafo

Miilaho caccafote kiirooti. Kiiramme 0 nni hanaffanno.

16

Hawiittimma

Miilaho haawiittimmate kiirooti; kiiramme 0 nni hanaffanno.

18

Shae

Miilaho shaete kiirooti; kiiramme 0 nni hanaffanno.

20

So'ro

So'rote kiirooti, hornho 0 ikkituro "so'ro nookki gede tirantino." Miilu afirimalu bisicco so'rote hornyinni dayiiro hornyo afirimalunni gumulantanno.

22

Hornyo

8 byte IEEE lame/duhantanno bixxille dani soorramaanchooti

30

...

Antanno miila


Naanni fikiimu dira

Bisiccote qarqari, hornyote daatu dani borro nnanaanni fikiimu diri gede sainoha amadino. Naanni fikiimu diri LibreOffice Calc giddo aananno garinni tiramino:

Offset

Name

Description

0

Caccafo1

Aliidi guraayiidi bisiccote qarqari waaco giddo caccafote kiiro. Kiiramme 0 nni hanaffanno.

2

Haawiittimma1

Aliidi guraayiidi bisiccote qarqari waaco giddo haawiittimmate kiiro; kiiramme 0 nni hanaffanno.

4

Shae1

Aliidi guraayiidi bisiccote qarqari waaco giddo shaete kiiro; kiiramme 0 nni hanaffanno.

6

Caccafo2

Woriidi qiniiti bisiccote qarqari waaco giddo caccafote kiiro. Kiiramme 0 nni hanaffanno.

8

Hawiittimma2

Woriidi qiniiti bisiccote qarqari waaco giddo haawiittimmate kiiro; kiiramme 0 nni hanaffanno.

10

Shae2

Woriidi qiniiti bisiccote qarqari waaco giddo shaete kiirooti; kiiramme 0 nni hanaffanno.

12

Kiiri

Aantanno miilla kiirooti. Mulla bisiccuwa dikiirantino woy sa'ino.

14

Caccafo

Miilaho caccafote kiirooti. Kiiramme 0 nni hanaffanno.

16

Hawiittimma

Miilaho haawiittimmate kiirooti; kiiramme 0 nni hanaffanno.

18

Shae

Miilaho shaete kiirooti; kiiramme 0 nni hanaffanno.

20

So'ro

So'rote kiirooti, hornho 0 ikkituro "so'ro nookki gede tirantino." Miilu afirimalu bisicco so'rote hornyinni dayiiro hornyo afirimalunni gumulantanno.

22

Hojja

Aananno naanni fikiimi hojja, cufammete zeero bayite amaddino. Hojja cufammete zeero bayite xea hornyo layinki zeero bayite naanni fikiimaho ledantannonna xea hornyo ledo taalturo konni daafira wo'mu hornyi afamanno. Ikkinohura, Hojja ((StrLen+2)&~1)horoonsi'ne shallanganni.

24

Naanni fikiima

Zeero bayite ledo cufamme naanni fikiima

24+Len

...

Antanno miila


Bisiccote Dira

Bisiccote dirubba borronna kiirra amaddino bisiccote qarqarra woshshate kaa'litanno. Bisiccote dirra LibreOffice Calc giddo aananno garinni tirantanno:

Offset

Name

Description

0

Caccafo1

Aliidi guraayiidi bisiccote qarqari waaco giddo caccafote kiiro. Kiiramme 0 nni hanaffanno.

2

Haawiittimma1

Aliidi guraayiidi bisiccote qarqari waaco giddo haawiittimmate kiiro; kiiramme 0 nni hanaffanno.

4

Shae1

Aliidi guraayiidi bisiccote qarqari waaco giddo shaete kiiro; kiiramme 0 nni hanaffanno.

6

Caccafo2

Woriidi qiniiti bisiccote qarqari waaco giddo caccafote kiiro. Kiiramme 0 nni hanaffanno.

8

Hawiittimma2

Woriidi qiniiti bisiccote qarqari waaco giddo haawiittimmate kiiro; kiiramme 0 nni hanaffanno.

10

Shae2

Woriidi qiniiti bisiccote qarqari waaco giddo shaete kiirooti; kiiramme 0 nni hanaffanno.

12

Kiiri

Aantanno miilla kiirooti. Mulla bisiccuwa dikiirantino woy sa'ino.

14

Caccafo

Miilaho caccafote kiirooti. Kiiramme 0 nni hanaffanno.

16

Hawiittimma

Miilaho haawiittimmate kiirooti; kiiramme 0 nni hanaffanno.

18

Shae

Miilaho shaete kiirooti; kiiramme 0 nni hanaffanno.

20

So'ro

So'rote kiirooti, hornho 0 ikkituro "so'ro nookki gede tirantino." Miilu afirimalu bisicco so'rote hornyinni dayiiro hornyo afirimalunni gumulantanno.

22

Dana

Bisiccote amado dana, 0 == Lame, 1 == Naanni fikiima

24

Hornyo woy Hojja

Danu == 0: 8 byte IEEE lame/duhantanno bixxille dani soorramaanchooti

Danu == 1: Aananno naanni fikiimi hojja, cufammete zeero bayite amaddino. Hojja cufammete zeero bayite xea hornyo layinki zeero bayite naanni fikiimaho ledantannonna xea hornyo ledo taalturo konni daafira wo'mu hornyi afamanno. Ikkinohura, Hojja ((StrLen+2)&~1)horoonsi'ne shallanganni.

26 danu == 1

Naanni fikiima

Danu == 1: naanni fikiimi cufammete zeero bayite ledo

32 woy 26+Hojja

...

Antanno miila


Please support us!