Skip to content

Instantly share code, notes, and snippets.

@smozgur
smozgur / Excel Custom Function.EXCEL.yaml
Last active February 5, 2023 13:25
Generates a list of sequential numbers with transpose option
name: Excel Custom Function
description: Generates a list of sequential numbers with transpose option
host: EXCEL
api_set: {}
script:
content: >
/**
* Excel Custom SEQUENCE function
* Generates a list of sequential numbers
* with transpose option
@smozgur
smozgur / Excel Custom Function - GETARTICLE().EXCEL.yaml
Last active March 2, 2023 14:48
Excel custom function that returns a custom data type.
name: Excel Custom Function - GETARTICLE()
description: Excel custom function that returns a custom data type.
host: EXCEL
api_set: {}
script:
content: |
/**
* @customfunction
* @returns {any}
*/
@smozgur
smozgur / Excel Custom Data Type Add-in Demo.EXCEL.yaml
Created December 13, 2021 16:19
How to create your own data type and set the cell values by using Range.valuesAsJson property. ScriptLab demo.
name: Excel Custom Data Type Add-in Demo
description: >-
How to create your own data type and set the cell values by using
Range.valuesAsJson property. ScriptLab demo.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
@smozgur
smozgur / Excel Custom Data Type Custom Function Demo.EXCEL.yaml
Created December 13, 2021 16:19
How to create your own data type and return as an entity through a custom function. ScriptLab demo.
name: Excel Custom Data Type Custom Function Demo
description: >-
How to create your own data type and return as an entity through a custom
function. ScriptLab demo.
host: EXCEL
api_set: {}
script:
content: |
/**
* @customfunction
@smozgur
smozgur / global.php
Last active July 3, 2016 23:36
ZF3 - Failure with multiple db Adapters and Zend Developer Tools.
<?php
/**
* global.php
*/
return [
'db' => [
'driver' => 'Pdo', // I added this line to make Developer Tools happy, now it works without problem
'adapters' => [
'Application\Db\LocalDb' => [
'driver' => 'Pdo',
@smozgur
smozgur / zf3-failure-controller-plugin.php
Last active July 4, 2016 11:14
ZF3 - Solved - Failure to get Controller Plugin worked globally.
<?php
/**
* config/global.php to keep application settings.
*/
return [
/* ... */
'application' => [
'settings' => [
'secretkey' => '84bew58h37a07t50e09v79eb98fre843',