notebookbar: added freeze pan buttons in calc

added icons too

Change-Id: I913f315c2e5bfcfbf6f82677ecffe76eaf86ea2a

5 files changed, 63 insertions, 0 deletions

diff --git a/loleaflet/images/lc_freezepanes.svg b/loleaflet/images/lc_freezepanes.svg
new file mode 100644
index 000000000..4db353960
--- /dev/null
+++ b/loleaflet/images/lc_freezepanes.svg
@@ -0,0 +1 @@
+<svg viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path d="m3 3v16h18v-16zm6 4h6c.554 0 1 .446 1 1v3c0 .554-.446 1-1 1h-6c-.554 0-1-.446-1-1v-3c0-.554.446-1 1-1z" fill="#fff"/><path d="m2 3v1 15c0 .554.446 1 1 1h18c.554 0 1-.446 1-1v-15-1h-1-5-1-6-1-5zm1 1h5v3h-5zm6 0h6v3c.554 0 1 .446 1 1h5v3h-5c0 .554-.446 1-1 1v3h-6v-3c-.554 0-1-.446-1-1h-5v-3h5c0-.554.446-1 1-1zm7 0h5v3h-5zm-13 8h5v3h-5zm13 0h5v3h-5zm-13 4h5v3h-5zm6 0h6v3h-6zm7 0h5v3h-5z" fill="#808080"/><g fill="#eac282"><g fill-rule="evenodd"><path d="m7.0253906 4-4.0253906 2.4160156v.5839844h.9746094l4.0253906-2.4160156v-.5839844z"/><path d="m7.0253906 8-4.0253906 2.416016v.583984h.9746094l4.0253906-2.416016v-.583984z"/><path d="m7.0253906 12-4.0253906 2.416016v.583984h.9746094l4.0253906-2.416016v-.583984z"/><path d="m7.0253906 16-4.0253906 2.416016v.583984h.9746094l4.0253906-2.416016v-.583984z"/><path d="m13.882812 4-4.882812 2.4414062v.5585938h1.117188l4.882812-2.4414062v-.5585938z"/><path d="m20.02539 4-4.02539 2.4160156v.5839844h.97461l4.02539-2.4160156v-.5839844z"/></g><path d="m2 3h20v1h-20z"/><path d="m2 7v1h6c0-.554.446-1 1-1zm13 0c.554 0 1 .446 1 1h6v-1z"/><path d="m2 3h1v16h-1z"/><path d="m8 4v4c0-.554.446-1 1-1v-3zm0 7v9h1v-8c-.554 0-1-.446-1-1z"/><path d="m15 4v3h1v-3z"/><path d="m21 4h1v3h-1z"/><path d="m3 15h5v1h-5z"/><path d="m3 11h5v1h-5z"/><path d="m3 19h5v1h-5z"/><path d="m2 19a1 1 0 0 0 1 1v-1z"/></g><path d="m9 8h6v3h-6z" fill="#4d82b8"/></svg>
\ No newline at end of file
diff --git a/loleaflet/images/lc_freezepanescolumn.svg b/loleaflet/images/lc_freezepanescolumn.svg
new file mode 100644
index 000000000..417f4bf32
--- /dev/null
+++ b/loleaflet/images/lc_freezepanescolumn.svg
@@ -0,0 +1 @@
+<svg viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path d="m3 4v15h5v-15zm7 0v15h11v-15z" fill="#fff"/><path d="m10 3v1h5v3h-5v1h5v3h-5v1h5v3h-5v1h5v3h-5v1h11c.554 0 1-.446 1-1v-15c0-.554-.446-1-1-1zm6 1h5v3h-5zm0 4h5v3h-5zm0 4h5v3h-5zm0 4h5v3h-5z" fill="#808080"/><path d="m3 3c-.554 0-1 .446-1 1v15c0 .554.446 1 1 1h5 1v-1-15-1h-1zm0 1h4.0253906l-4.0253906 2.4160156zm5 .5839844v2.4160156h-4.0253906zm-5 3.4160156h4.0253906l-4.0253906 2.416016zm5 .5839844v2.4160156h-4.0253906zm-5 3.4160156h4.0253906l-4.0253906 2.416016zm5 .583984v2.416016h-4.0253906zm-5 3.416016h4.0253906l-4.0253906 2.416016zm5 .583984v2.416016h-4.0253906z" fill="#eac282"/></svg>
\ No newline at end of file
diff --git a/loleaflet/images/lc_freezepanesrow.svg b/loleaflet/images/lc_freezepanesrow.svg
new file mode 100644
index 000000000..78ce359e1
--- /dev/null
+++ b/loleaflet/images/lc_freezepanesrow.svg
@@ -0,0 +1 @@
+<svg viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path d="m3 4v4h18v-4zm0 5v10h18v-10z" fill="#fff"/><path d="m2 9v10c0 .554.446 1 1 1h18c.554 0 1-.446 1-1v-10h-1v2h-5v-2h-1v2h-6v-2h-1v2h-5v-2zm1 3h5v3h-5zm6 0h6v3h-6zm7 0h5v3h-5zm-13 4h5v3h-5zm6 0h6v3h-6zm7 0h5v3h-5z" fill="#808080"/><path d="m3 3c-.554 0-1 .446-1 1v3 1h1 18 1v-1-3c0-.554-.446-1-1-1zm0 1h4.0253906l-4.0253906 2.4160156zm6 0h4.882812l-4.882812 2.4414062zm7 0h4.025391l-4.025391 2.4160156zm-1 .5585938v2.4414062h-4.882812zm-7 .0253906v2.4160156h-4.0253906zm13 0v2.4160156h-4.025391z" fill="#eac282"/></svg>
\ No newline at end of file
diff --git a/loleaflet/src/control/Control.NotebookbarCalc.js b/loleaflet/src/control/Control.NotebookbarCalc.js
index f21959f7b..6fe096450 100644
--- a/loleaflet/src/control/Control.NotebookbarCalc.js
+++ b/loleaflet/src/control/Control.NotebookbarCalc.js
@@ -2060,6 +2060,63 @@ L.Control.NotebookbarCalc = L.Control.NotebookbarWriter.extend({
 																						}
 																					]
 																				},
+																				{
+																					'id': 'freeze-section1',
+																					'type': 'container',
+																					'text': '',
+																					'enabled': 'true',
+																					'vertical': 'true',
+																					'children': [
+																						{
+																							'id': 'Section7',
+																							'type': 'toolbox',
+																							'text': '',
+																							'enabled': 'true',
+																							'children': [
+																								{
+																									'type': 'toolitem',
+																									'text': _UNO('.uno:FreezePanes', 'spreadsheet', true),
+																									'command': '.uno:FreezePanes'
+																								}
+																							]
+																						}
+																					]
+																				},
+																				{
+																					'id': 'freeze-section2',
+																					'type': 'container',
+																					'text': '',
+																					'enabled': 'true',
+																					'vertical': 'true',
+																					'children': [
+																						{
+																							'id': 'Section7',
+																							'type': 'toolbox',
+																							'text': '',
+																							'enabled': 'true',
+																							'children': [
+																								{
+																									'type': 'toolitem',
+																									'text':_UNO('.uno:FreezePanesColumn', 'spreadsheet', true),
+																									'command': '.uno:FreezePanesColumn'
+																								}
+																							]
+																						},
+																						{
+																							'id': 'Section10',
+																							'type': 'toolbox',
+																							'text': '',
+																							'enabled': 'true',
+																							'children': [
+																								{
+																									'type': 'toolitem',
+																									'text': _UNO('.uno:FreezePanesRow', 'spreadsheet', true),
+																									'command': '.uno:FreezePanesRow'
+																								}
+																							]
+																						}
+																					]
+																				}
 																			]
 																		}
 																	]
diff --git a/loleaflet/src/unocommands.js b/loleaflet/src/unocommands.js
index 655424700..1c28a39d4 100644
--- a/loleaflet/src/unocommands.js
+++ b/loleaflet/src/unocommands.js
@@ -122,6 +122,9 @@ var unoCommandsArray = {
 	FormatXErrorBars:{global:{menu:_('Format X Error Bars...'),},},
 	FormatYErrorBars:{global:{menu:_('Format Y Error Bars...'),},},
 	FormattingMarkMenu:{global:{menu:_('Formatting Mark'),},},
+	FreezePanes:{spreadsheet:{menu:_('Freeze ~Rows and Columns'),},},
+	FreezePanesColumn:{spreadsheet:{menu:_('Freeze First Column'),},},
+	FreezePanesRow:{spreadsheet:{menu:_('Freeze First Row'),},},
 	FullScreen:{global:{menu:_('F~ull Screen'),},},
 	GoalSeekDialog:{spreadsheet:{menu:_('~Goal Seek...'),},},
 	Group:{global:{menu:_('~Group...'),},},