summaryrefslogtreecommitdiff
path: root/sc/uiconfig/scalc
AgeCommit message (Collapse)Author
2022-07-30tdf#150045 Set secondary/explanatory labels apartAdolfo Jayme Barrientos
Rationale in commit 0ebbe1f0080f474fd583e5912c9605e6fb2e13d5, of which this is a follow-up. Change-Id: If75aa32bf02aeb8761f5b7f4ddbbeaa3bdcaab3f Reviewed-on: https://gerrit.libreoffice.org/c/core/+/137618 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-07-22tdf#150093 add scrollbar to calc general options for the case it doesn't fitCaolán McNamara
Change-Id: I5099244153f38fc8393aaa6a09e74dcbd0a995bd Reviewed-on: https://gerrit.libreoffice.org/c/core/+/137341 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-07-22tdf#117276 sc: Show hidden filter elements as inactive elementsBalazs Varga
Showing hidden values in the autofilter dropdown (as inactive when it was hidden by another row) - without changing the behaviour of autofilter. First those which belongs to non-hidden rows, then those which belongs to hidden rows. TODO: maybe we can add a global option where the user can switch on/off this feature. Change-Id: Iafeb43176efe7ab422b22697d399c68c95d0319d Reviewed-on: https://gerrit.libreoffice.org/c/core/+/136595 Tested-by: Jenkins Reviewed-by: Balazs Varga <balazs.varga.extern@allotropia.de>
2022-07-15tdf#148248 Text Color -> Font Color in AutoFilter/Standard FilterGabor Kelemen
Consistently with other places such as Formatting toolbar and Format Cells -> Font Effects tab page Change-Id: I7ec5733f01182b25b5d823a43a3639b21ee874e7 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/137087 Tested-by: Jenkins Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com>
2022-07-11tdf#149738: Minor inconsistencies in sparkline related UI stringsJulien Nabet
Change-Id: I5b4c31e69743ad519a8bcc99fa3a5a7512a4cc18 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/136955 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2022-07-01tdf#138748 Correct label locale group in CSV dialogPedro Pinto Silva
The second group in the dialog is about the "Locale" and it was wrongly named "Language" Signed-off-by: Pedro Pinto Silva <pedro.silva@collabora.com> Change-Id: Ie140c6af4560300261f816d0eb73dd451a2c5376 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/136724 Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com> Tested-by: Jenkins
2022-07-01tdf#138748 Correct group label in HTML import dialogPedro Pinto Silva
Use "Locale" as a label instead of "Language" for locale options Signed-off-by: Pedro Pinto Silva <pedro.silva@collabora.com> Change-Id: Ic7edd5108a59cf1be1062b3709cb80a84606fe82 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/136725 Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com> Tested-by: Jenkins
2022-06-21tdf#69750 Preserve last used Paste Special options for next session.Siddhant Chaudhary
This feature stores the Paste Special options for Calc in the LO registry for use across sessions, so that users don't have to set options everytime they start a new Calc session. A new group named "PasteSpecial" has been added in `officecfg/registry/schema/org/openoffice/Office/Common.xcs`. The function `ScInsertContentsDlg::storeFlagsInRegistry()` has been added, which is responsible for storing the state whenever the dialog is closed by clicking either the OK button, or one of the four shortcut buttons. Also, whenever the dialog is opened for the first time in a new session (represented by the `firstLoad` boolean flag), the options are loaded from the registry. Change-Id: Icc879b11feb5bfe32777b6e548d9c0804d93a33e Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135110 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-06-14Fix English in validationcriteriapage.uiOlivier Hallot
Change-Id: Ibfa172839f71c2b640c87edafa5d4ee1ef687915 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135770 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-14fix extended tip in sc/pastespecial.uiOlivier Hallot
Change-Id: I8e6f6c227b0be37dea4c31f17df6eb8581d4f1ca Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135764 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-09tdf#149414 change Format Object label for Calc and ImpressSeth Chaiklin
The label for Calc was Format > OLE Object (using .uno:ObjectMenu), while the label for Impress was Format > "Object and Shape" (using .uno:FormatObjectMenu). This patch (a) changes the label of .uno:FormatObjectMenu from "Object and Shape" to "Text Box and Shape" (to bring it in line with Writer). This change appears immediately in Impress, and (b) changes the .uno:ObjectMenu in Calc to .uno:FormatObjectMenu, which also gives the "Text Box and Shape" label, which is also more appropriate for its submenu. Kept the same keyboard accelerator "o", which was used both in Impress and Calc. Change-Id: Ifcf7b953b6bed262d630f7a07bf1f5000ee33aa4 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135162 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2022-06-07tdf#129674 Add GoTo Sheet commandLaurent BP
Insert command in menu Sheet > Navigate (alongs with To Previous/Next Sheet) Use .uno:JumpToTable command from Navigator Use its own Go To Sheet dialog Add a Search entry to type partial name of sheet Menu translation missing? Change-Id: I16b8b56a688c8396159617f04a2a7e034721ce31 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/134714 Tested-by: Jenkins Reviewed-by: Laurent Balland-Poirier <laurent.balland@mailo.fr>
2022-06-05restore %PRODUCTNAME to accessible descriptions that need themCaolán McNamara
The original problem was that %PRODUCTNAME wasn't replaced for accessibility descriptions (which are reused for extended tips) under gtk. Universally querying all a11y descs on load to potentially replace %PRODUCTNAME in a11y descs at runtime led to tdf146971 which was a huge startup slowdown. The half way 7.3 fix was to leave a11y descs alone, but do the replacement when querying for the extended tip case. So the extended tooltips were ok, but screen readers would still say a raw "%PRODUCTNAME" text, hence the rewording effort to remove %PRODUCTNAME from the a11y descs entirely for 7.4. But there is now a few cases where some options paths exists in the a11y descs which is not exactly correct wrt to the text shown in the options dialog. Reworking the options dialog to not have %PRODUCTNAME there at all and updating everything to fit that sort of change would not be popular. So move the cases where a11y descs really should have %PRODUCTNAME in them out of the .ui files and into .hrc files and use specific set_accessibility_description calls for them via ResID which will do the %PRODUCTNAME replacement automatically. Hopefully the a11y runtime cost for just this handful of cases is negligible in the overall scheme of things. Change-Id: Ieb17d26fd581cd5804a52b371b3bb5ea43023aa3 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135432 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-06-05drop stray space before full stopCaolán McNamara
Change-Id: I50013a672cc953822845a2e02d038e75f51ef457 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135431 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-05-25tdf#148467 Move sparklines items to Insert/Format main menuRoman Kuznetsov
Change-Id: I2606fdd6301e5d1cb1e855d79a971762ed2d835d Reviewed-on: https://gerrit.libreoffice.org/c/core/+/133608 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-05-23Resolves tdf#131155 - Keep frequently used options on sort criteria tabHeiko Tietze
* Row/Column header moved * Sort by row/column moved * Extra variables removed * UI tests adjusted to read/set sort direction and header from first tab Change-Id: I9fc0406806256f289d52e45b096e392067768eaa Reviewed-on: https://gerrit.libreoffice.org/c/core/+/130843 Tested-by: Heiko Tietze <heiko.tietze@documentfoundation.org> Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-05-16de-lint the .ui file for auto gtk3->gtk4 conversionCaolán McNamara
Change-Id: Icb288ae13e75784e7b560101f33b8a96935bda36 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/134389 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-05-03Resolves tdf#148568 - Rework the Sparklines dialogHeiko Tietze
* controls rearranged and variables renamed * radiobuttons changed into comboboxes Change-Id: Ifda426b5fa9596c2b23c335165785c0cb341433f Reviewed-on: https://gerrit.libreoffice.org/c/core/+/133636 Tested-by: Jenkins Reviewed-by: Roman Kuznetsov <antilibreoffice@gmail.com>
2022-04-26Translatable string improvements I push so they don’t rot in my local cloneAdolfo Jayme Barrientos
Change-Id: Ic057769718790ced80daf24510d27aad49e3341b Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132975 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-04-15sc: introduce SparklineShell and Sparkline contextTomaž Vajngerl
Having a separate sparkline context is very useful, so we can add a custom UI when the user has the cursor over a sparkline. This will allow a "Sparkline" tab for NotebookBar and its own deck in Sidebar, activated only when the sparkline is present. Also the pop-up menu can be customized specifically for the sparkline, but this may be less useful. For the sparkline context we need a custom shell - SparklineShell where now all the UNO commands can be implemented (not done in this commit). Change-Id: Idca2ad946af3afdd1b494744b80c9c093eec602c Reviewed-on: https://gerrit.libreoffice.org/c/core/+/133022 Tested-by: Jenkins Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-04-10sc: add UI, undo/redo and test to change sparkline data rangeTomaž Vajngerl
This adds a "edit sparkline" action to the context menu and a dialog to change the data range of a sparkline. To change a sparkline using undo/redo, a new class UndoEditSparkline was added, which allows to change the attributes of a sparkline and revert back the old attributes when undoing. This is then used in the Dialog when setting the changed data range of a sparkline. To make sure that undo/redo works correctly, a simple unit tests was added. Change-Id: I08af1813fa288278bc0d33b0540660b325b17235 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132748 Tested-by: Jenkins Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-04-07sc: add sparklines commands to main menuTomaž Vajngerl
Change-Id: Ie69d78162fb0d845f8ffd181397569c3cd3276f1 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132593 Tested-by: Jenkins Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-04-06sc: add Group and Ungroup to context menu for sparklinesTomaž Vajngerl
This change allows to group parklines together into a sparkline group, or ungroup them, so they use their own sparkline group. This also adds the undo and redo for this actions. Change-Id: I61b604203afaf2fe8c2d47b80082739ded15d6fb Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132545 Tested-by: Tomaž Vajngerl <quikee@gmail.com> Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-04-06sc: add "Delete Sparkline Group" context menu action + Undo/RedoTomaž Vajngerl
Change-Id: I34e11a4881c564351c3e08d157fb42ac4bb8ef3c Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132544 Tested-by: Tomaž Vajngerl <quikee@gmail.com> Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-04-05sc: edit all sparkline attributes in SparklineDialogTomaž Vajngerl
Change-Id: I6ca9e3436e0dd807b30585576ae2067076c3b7ce Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132516 Tested-by: Jenkins Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-04-04sc: add "Edit Sparkline Group" context menu actionTomaž Vajngerl
This adds a context menu to edit the sparkline group for the current selected range (if it contains a sparkline group). This reuses the SparklineDialog that is used for inserting a new sparkline. The context menu was rearranged so that all actions for the sparklines are in a "Sparklines" submenu. Change-Id: Ia1a025b7c0bf1849c72fdca77ea2f8dc8860c6ab Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132503 Tested-by: Tomaž Vajngerl <quikee@gmail.com> Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-04-03sc: add "Delete Sparkline" context menu commandTomaž Vajngerl
Change-Id: I0e2bf2172da3cbba391ca64c93fad6bccd82f3ac Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132468 Tested-by: Jenkins Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-04-03sc: SparklineDialog add type, colors and propertiesTomaž Vajngerl
Change-Id: Ie8243985d61cc719fd0444b0e1aaf18f43489d5c Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132466 Tested-by: Tomaž Vajngerl <quikee@gmail.com> Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-04-03sc: SparklineDialog and "Insert Sparkline" to context menuTomaž Vajngerl
This adds a SparklineDialog, which is used to add/edit the Sparkline input/output ranges. The command for the context menu "Insert Sparkline" calls the SparklineDialog for inserting a new sparkline into cells. Currently the SparklineDialog include the properties for the SparklineGroup, which will be added in a later commit. Change-Id: I9036d788fdf2a035f1ce10fc7413327a92144137 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132465 Tested-by: Tomaž Vajngerl <quikee@gmail.com> Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2022-03-08remove some member-of a11y relationsCaolán McNamara
In some cases the widgets are in frames now so that hierarchical relationship is captured already. In others labelled-by is a better match and/or is already labelled by the widget. Change-Id: Ifecd0eb96afecadbd66fcfdf843ce1590f5c5ff4 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/131185 Tested-by: Caolán McNamara <caolanm@redhat.com> Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-03-08resave with latest gladeCaolán McNamara
Change-Id: Ie0e04a86d8aa8a2425fddb74089721f69d3bbe87 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/131184 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-03-02Bump Glade version to 3.38Heiko Tietze
Change-Id: Ibd8ffc90efaed9f8a5ced558f22ec53da7f31cb9 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/130822 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-02-28tdf#147667 - Remove hard-coded underscore from UIHeiko Tietze
Duplicate underscores make the hotkey unusable. While the path removes it from the UI it's neccessary to also clean-up the translations. Change-Id: Id8a216c7c928eccebabbac79744cb802c07ae3f4 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/130688 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-02-15tdf#145745 Create uno:DuplicateSheet commandrafaelhlima
Change-Id: Ic8d37f02d45c6f958bf6133c27997adea9bc8c7c Reviewed-on: https://gerrit.libreoffice.org/c/core/+/129541 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-02-11Resolves tdf#140290 - Make sort keys accessibleHeiko Tietze
Inline string is plain now in favor of the caption Column/Row before the dopdown control Change-Id: I7f012d38c360113b7207f19fa32437d28d90d049 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/129366 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org> Reviewed-by: Eike Rathke <erack@redhat.com>
2022-02-09Resolves tdf#147301 - Disable Hidden Row/Col indicatorHeiko Tietze
Off by default now Entry in View menu added to easily switch on/off Change-Id: I138ce90f1d2e3c2337368870803d5aa959116c3f Reviewed-on: https://gerrit.libreoffice.org/c/core/+/129712 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-02-02Bump Glade version to 3.38Heiko Tietze
Change-Id: I05ee4ba0a3bc85d1fef1e381ead4c9c32360dcb9 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/129352 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-01-29gtk4: remove stray xalignCaolán McNamara
Change-Id: I6a54b1547dbf78ec285dee59893ed3a899285997 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/129152 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-01-27toggle no-show-all on so the widgets don't appear despite visible offCaolán McNamara
Change-Id: I9426c8d9e0149072c2318aff31b01227edd8149c Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128989 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-01-26warning is a dialog not a popupCaolán McNamara
with the wrong setting it appears misplaced on a multi-monitor setup Change-Id: I43faeb72f6678a653feef82e0f0deaf87c039e9c Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128994 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2022-01-26split two paragraph warning into primary and secondary messagesCaolán McNamara
Change-Id: Ie3bd9205a549ac55a0e5c7b9a444928b0fd80174 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128935 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-01-25tdf#146970 use a textview to show the proposed replacement formulaCaolán McNamara
so it can scroll and keep the text area to some finite size no strings changes or new translations, so this is a backportable change. Change-Id: Ibc36812c6aa7fff8e035c06d0dad885909f057ff Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128933 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-01-25Related: tdf#146971 remove %PRODUCTNAME from accessible-descriptionCaolán McNamara
Change-Id: I83ff18c8b5e95fa172de950eb351cbfd855c9d5d Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128919 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-01-24remove explicit can-focus of False from GtkToolButtonsCaolán McNamara
Change-Id: I60ce3a7c1e83e99f396ff61166a6ba4912b9f82e Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128861 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-01-21gtk4: set homogeneous to true to get two equal width buttonsCaolán McNamara
Change-Id: Iff8c9579bbb4758c2bb13b946fafcaf3b9433a84 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128735 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2022-01-21tdf#141591 Add DevTools to the Tabbed interfacerafaelhlima
This patch adds the DevTools command to the Tabbed interface. It is located in the cotnext menu in the Tools tab. Change-Id: I5f323b1b5ffc6707fc4f8b3c6eca2db7b8b97adc Reviewed-on: https://gerrit.libreoffice.org/c/core/+/127973 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-01-18Resolve gtk3 crash of If1ffb50743292f3cc0c3271646d0538337977762Heiko Tietze
Change-Id: Id1080b71d1252bdcef804a4f8398a3c42073ee0a Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128522 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-01-17tdf#136362 Remove unnecessary blank area and option in some image toolbarJeff Huang
Only in Calc, Draw and Impress. Change-Id: I944aad875fedd1dd19657c49b059e33fd6e9d3f9 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/127984 Tested-by: Jenkins Reviewed-by: Heiko Tietze <heiko.tietze@documentfoundation.org>
2022-01-16tdf#146421 Calc Sidebar Alignment Section follow arrangement guidelineandreas kainz
Change-Id: If1ffb50743292f3cc0c3271646d0538337977762 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/126688 Tested-by: Jenkins Reviewed-by: Andreas Kainz <kainz.a@gmail.com>
2022-01-15Change cursor -> pointer in spreadsheet option tipOlivier Hallot
Change-Id: I4fe40f321849846daaddd1c9374a0271689b5823 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128425 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>