AllLangHelp_sbasic.mk |2
source/auxiliary/sbasic.tree |2
source/text/sbasic/shared/03140010.xhp |6 +-
source/text/sbasic/shared/03140011.xhp | 72
source/text/sbasic/shared/03140012.xhp | 74 +
source/text/sbasic/shared/special_vba_func.xhp | 13
6 files changed, 155 insertions(+), 14 deletions(-)
New commits:
commit aef2d0a3117abf45df98b11342799097ec36d796
Author: Olivier Hallot
Date: Mon Jul 24 01:48:32 2017 -0300
tdf#108680 Help page for VBA function SYD
Change-Id: Icec5d785a73b31313aaacd86252cae9cc9013043
Reviewed-on: https://gerrit.libreoffice.org/40354
Reviewed-by: Olivier Hallot
Tested-by: Olivier Hallot
diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk
index 10f5ad4e9..f1c388e8e 100644
--- a/AllLangHelp_sbasic.mk
+++ b/AllLangHelp_sbasic.mk
@@ -336,6 +336,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\
helpcontent2/source/text/sbasic/shared/03140009 \
helpcontent2/source/text/sbasic/shared/03140010 \
helpcontent2/source/text/sbasic/shared/03140011 \
+helpcontent2/source/text/sbasic/shared/03140012 \
helpcontent2/source/text/sbasic/shared/05060700 \
helpcontent2/source/text/sbasic/shared/code-stubs \
helpcontent2/source/text/sbasic/shared/keys \
diff --git a/source/auxiliary/sbasic.tree b/source/auxiliary/sbasic.tree
index ae661528e..a0b31e2f8 100644
--- a/source/auxiliary/sbasic.tree
+++ b/source/auxiliary/sbasic.tree
@@ -246,6 +246,7 @@
String Function
[Runtime]
Sub Statement
[Runtime]
Switch Function
[Runtime]
+SYD Function [Runtime -
VBA]
Tan Function
[Runtime]
TimeSerial Function
[Runtime]
TimeValue Function
[Runtime]
diff --git a/source/text/sbasic/shared/03140012.xhp
b/source/text/sbasic/shared/03140012.xhp
new file mode 100644
index 0..a87685328
--- /dev/null
+++ b/source/text/sbasic/shared/03140012.xhp
@@ -0,0 +1,74 @@
+
+
+
+
+
+
+SYD Function [Runtime - VBA]
+/text/sbasic/shared/03140012.xhp
+
+
+
+
+
+
+
+
+ SYD function
+
+
+
+SYD
Function [Runtime - VBA]
+Returns the
arithmetic-declining depreciation rate.
+
+
+
+
+SYD (Cost as Double, Salvage as Double, Life as Double, Period
as Double)
+
+
+Double
+
+Cost is the initial cost of an asset.
+Salvage is the value of an asset at the end of
the depreciation.
+Life is the depreciation period determining the
number of periods in the depreciation of the asset.
+Period is the period number for which you want to
calculate the depreciation.
+
+
+
+
+REM * BASIC *
+Option VBASupport 1
+Sub ExampleSYD
+REM
Calculate the yearly depreciation of an asset that cost $10,000 at
+REM
the start of year 1, and has a salvage value of $1,000 after 5
years.
+Dim syd_yr1 As Double
+REM
Calculate the depreciation during year 1
+syd_yr1 = SYD( 1, 1000, 5, 1 )
+print
syd_yr1 ' syd_yr1 is now equal to 3000.
+End Sub
+
+
+
+SYD
function in CALC
+
+
+
+
+
\ No newline at end of file
diff --git a/source/text/sbasic/shared/special_vba_func.xhp
b/source/text/sbasic/shared/special_vba_func.xhp
index 730b360bb..a1d6aa105 100644
--- a/source/text/sbasic/shared/special_vba_func.xhp
+++ b/source/text/sbasic/shared/special_vba_func.xhp
@@ -66,14 +66,7 @@
-
-
-
-SYD
-
-
- VBA Functions;Date and Time Functions
-
+
Date and time functions
commit aee97f023acc483b46ed41af4f7fabd796e8b4f0
Author: Olivier Hallot
Date: Mon Jul 24 01:30:46 2017 -0300
tdf#108679 Help page for VBA function SLN
Change-Id: Ida99588e30da477d8bc280492c5e90d52d24aee0
Reviewed-on: https://gerrit.libreoffice.org/40353
Reviewed-by: Olivier Hallot
Tested-by: Olivier Hallot
diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk
index d576d7aa4..10f5ad4e9 100644
--- a/AllLangHelp_sbasic.mk
+++ b/AllLangHelp_sbasic.mk
@@ -335,6 +335,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\
helpcontent2/source/text/sbasic/shared/03140008 \
helpcontent2/source/text/sbasic/shared/03140009 \
helpcontent2/source/text/sbasic/shared/03140010 \
+helpcontent2/source/text/sbasic/shared/03140011 \
helpcontent2/source/text/sbasic/shared/05060700 \
helpcontent2/source/text/sbasic/shared/code-stubs \
helpcontent2/source/text/sbasic/shared/keys \
diff --git a/source/auxiliary/sbasic.tree b/source/auxiliary/sbasic.tree
index 26531c192..ae661528e 100644
--- a/source/auxiliary/sbasic.tree
+++ b/source/auxiliary/sbasic.tree
@@ -233,6 +233,7 @@
Sgn Function
[Runtime]
Shell Function
[Runtime]
Sin Function
[Runtime]
+SLN Function [Runtime -
VBA]
Space Function
[Runtime]
Split Function
[Runtime]
Sqr Function
[Runtime]
diff --git a/source/text/sbasic/shared/03140010.xhp