AllLangHelp_scalc.mk | 3 -
source/text/scalc/01/sparklines.xhp | 91 ++++++++++++++++++++++++++++++++++++
source/text/scalc/main0104.xhp | 1
3 files changed, 94 insertions(+), 1 deletion(-)
New commits:
commit 396d82a4d705d7b473f767816f970bffec74d33e
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu Jun 2 14:56:48 2022 -0300
Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com>
CommitDate: Mon Jun 6 03:45:28 2022 +0200
tdf#148817 Sparklines Help page.
+ add bookmark entry
+ update Calc Insert menu help page
Change-Id: I76315d7c35a2a98731ef92d9090ebcba41f9e004
Co-authored-by: Tomaž Vajngerl <qui...@gmail.com>
Co-authored-by: Roman Kuznetsov <antilibreoff...@gmail.com>
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135324
Tested-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 63116c9a0..a40e388d9 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -278,10 +278,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_yearfrac \
helpcontent2/source/text/scalc/01/live_data_stream \
helpcontent2/source/text/scalc/01/recalculate_hard \
- helpcontent2/source/text/scalc/01/solver \
helpcontent2/source/text/scalc/01/shared_spreadsheet \
+ helpcontent2/source/text/scalc/01/solver \
helpcontent2/source/text/scalc/01/solver_options \
helpcontent2/source/text/scalc/01/solver_options_algo \
+ helpcontent2/source/text/scalc/01/sparklines \
helpcontent2/source/text/scalc/01/statistics \
helpcontent2/source/text/scalc/01/statistics_anova \
helpcontent2/source/text/scalc/01/statistics_correlation \
diff --git a/source/text/scalc/01/sparklines.xhp
b/source/text/scalc/01/sparklines.xhp
new file mode 100644
index 000000000..05acb1c61
--- /dev/null
+++ b/source/text/scalc/01/sparklines.xhp
@@ -0,0 +1,91 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="textscalc01sparklines.xhp" indexer="include"
status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Sparklines</title>
+ <filename>/text/scalc/01/sparklines.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sparklinedialog/SparklineDialog"
id="bm_id551654173649481" localize="false"/>
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sparklinedialog/@@nowidget@@"
id="bm_id561654173649481" localize="false"/>
+
+ <bookmark xml-lang="en-US" branch="index" id="bm_id901654173679276">
+<bookmark_value>sparklines</bookmark_value>
+ </bookmark>
+ <section id="sparklinesh1">
+ <h1 id="hd_id721654173263812"><variable id="sparklines"><link
href="text/scalc/01/sparklines.xhp"
name="Sparklines">Sparklines</link></variable></h1>
+ <paragraph id="par_id981654173263817" role="paragraph"
xml-lang="en-US">Sparklines are small data charts displayed inside a
cell.</paragraph>
+ </section>
+ <paragraph role="paragraph" id="par_id341654174064080">Sparklines are
defined for one cell, but multiple sparklines can be joined together into a
group. The group shares the same properties for rendering the sparkline. The
unique data that is defined only for one sparkline is the data range, that a
sparkline will use for rendering.</paragraph>
+ <section id="howtoget">
+ <paragraph role="paragraph" id="par_id761654173486733">Choose
<menuitem>Insert – Sparklines</menuitem></paragraph>
+ </section>
+ <h2 id="hd_id391654173530650">Data</h2>
+ <paragraph role="paragraph" id="par_id751654174462868"><emph>Input
range</emph>: enter the cell range of the data. Use the <emph>shrink</emph>
button to select the data range with the mouse.</paragraph>
+ <paragraph role="paragraph" id="par_id701654174578218"><emph>Output
range</emph>: select the cell range to receive the sparkline. Use the
<emph>shrink</emph> button to select the cell range with the mouse.</paragraph>
+ <h2 id="hd_id651654174597644">Properties</h2>
+ <paragraph role="paragraph" id="par_id961654174732293"><emph>Type</emph>:
select the sparkline type in the drop-down list. Choices are:</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id481654191793887"
role="listitem"><emph>Line</emph>: draws a line between data values.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id391654191798913"
role="listitem"><emph>Column</emph>: draws a bar for each data
value.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id481654191804474"
role="listitem"><emph>Stacked</emph>: also known as win/loss. Displays equally
sized bars indicating positive and negative values.</paragraph>
+ </listitem>
+ </list>
+ <paragraph role="paragraph" id="par_id701654174850309"><emph>Line
width</emph>: enter the line width number manually or use the spin
button.</paragraph>
+ <paragraph role="paragraph" id="par_id761654176569576"><emph>Display empty
cells as</emph>: choices are available in the drop-down list:</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id171654176533173"
role="listitem"><emph>Gap</emph>: the missing data is not displayed. The line
type discontinues in the gap and the column is not displayed.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id81654176538165"
role="listitem"><emph>Zero</emph>: the missing data is displayed as value
zero.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id801654176544375"
role="listitem"><emph>Span</emph>: for line type only, draws a continuous line
connecting the previous value to the next value.</paragraph>
+ </listitem>
+ </list>
+ <paragraph role="paragraph" id="par_id431654176711837"><emph>Display
hidden</emph>: check to show all columns or stacks in the range even when the
data is in hidden cells. If unchecked, the hidden data is ignored.</paragraph>
+ <paragraph role="paragraph"
id="par_id21654177035348"><emph>Right-to-left</emph>: check to display the
sparklines reverse order of the data.</paragraph>
+ <h2 id="hd_id911654177186844">Colors</h2>
+ <paragraph role="paragraph" id="par_id11654177765370"><emph>Series</emph>:
select the main color for the sparklines.</paragraph>
+ <paragraph role="paragraph" id="par_id421654177770032"><emph>Negative
points</emph>: check and select the color for negative points.</paragraph>
+ <paragraph role="paragraph" id="par_id231654177773798"><emph>High
points</emph>: check and select the color for high points.</paragraph>
+ <paragraph role="paragraph" id="par_id371654177777479"><emph>Low
points</emph>: check and select the color for low points.</paragraph>
+ <paragraph role="paragraph"
id="par_id521654177784536"><emph>Marker</emph>: check and select the color for
data points (line type only).</paragraph>
+ <paragraph role="paragraph" id="par_id181654177788533"><emph>First
point</emph>: check and select the color for first point.</paragraph>
+ <paragraph role="paragraph" id="par_id241654177793144"><emph>Last
point</emph>: check and select the color for last point.</paragraph>
+
+ <h2 id="hd_id251654180880861">Axes</h2>
+ <paragraph role="paragraph" id="par_id871654181525722"><emph>Display X
axis</emph>: check to show the X axis for sparklines.</paragraph>
+ <paragraph role="paragraph" id="par_id891654181533521"><emph>Vertical
minimum, Vertical maximum:</emph> check to set the minimum (maximum) value for
the Y axis. Select one of following:</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id521654181404234"
role="listitem"><emph>Individual</emph>: sets automatically the minimum
(maximum) value for each sparkline based on the sparkline data range
values.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id821654181425448"
role="listitem"><emph>Group</emph>: sets the minimum (maximum) value based on
the lower and higher values found in the group of sparklines.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id51654181442414"
role="listitem"><emph>Custom:</emph> enter the minimum (maximum) value for the
sparkline group.</paragraph>
+ </listitem>
+ </list>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id801654192214865"><link
href="https://tomazvajngerl.blogspot.com/2022/03/sparklines-in-calc.html";
name="developer info">Developer blog post on sparklines</link></paragraph>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0104.xhp b/source/text/scalc/main0104.xhp
index aa95eb67d..48df92e44 100644
--- a/source/text/scalc/main0104.xhp
+++ b/source/text/scalc/main0104.xhp
@@ -36,6 +36,7 @@
<h2 id="hd_id3146918"><link href="text/schart/01/wiz_chart_type.xhp"
name="Chart">Chart</link></h2>
<paragraph id="par_id0302200904002496" role="paragraph"
xml-lang="en-US">Inserts a chart.</paragraph>
+<embed href="text/scalc/01/sparklines.xhp#sparklinesh1"/>
<embed href="text/scalc/01/12090100.xhp#pivot_table_h1"/>
<embed href="text/shared/01/04990000.xhp#media_submenu"/>
