summaryrefslogtreecommitdiff
path: root/sc/uiconfig/scalc
AgeCommit message (Collapse)Author
2018-09-17NB sync draw shapes between appsandreas kainz
Change-Id: Ibb1e11eb438607d26ebd06e7fb160cf850915d5b Reviewed-on: https://gerrit.libreoffice.org/60555 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-09-13tdf#119671 - UI: Add "Calculate All" to menu "Data\Calculate"heiko tietze
.uno:CalculateHard added to the main menu Change-Id: I6deff5892d13bc7b4f6a8e63e20e07aaf7e8a6ac Reviewed-on: https://gerrit.libreoffice.org/60422 Tested-by: Jenkins Reviewed-by: Heiko Tietze <tietze.heiko@gmail.com>
2018-09-10a11y: Fix multiple instances of duplicate mnemonicsKatarina Behrens
Change-Id: I0ffe2a7c6b8102aa977af16232ce930541a8b816 Reviewed-on: https://gerrit.libreoffice.org/60246 Tested-by: Jenkins Reviewed-by: Katarina Behrens <Katarina.Behrens@cib.de>
2018-09-06sc [tz]test dlg: fix duplicate mnemonic labelKatarina Behrens
Change-Id: Ibf2780a2eb658f7210cb5e80cf2b8e2e65fe1bda Reviewed-on: https://gerrit.libreoffice.org/59979 Tested-by: Jenkins Reviewed-by: Katarina Behrens <Katarina.Behrens@cib.de>
2018-09-06sc random number gen dlg: fix some a11y issuesKatarina Behrens
Change-Id: I04c31c96538cb7da07e6bf2e43e6150f04f9d247 Reviewed-on: https://gerrit.libreoffice.org/59978 Tested-by: Jenkins Reviewed-by: Katarina Behrens <Katarina.Behrens@cib.de>
2018-09-05Added Replace Null Transformation in data provider dlgManuj Vashist
Change-Id: I5e1541e87f1eabd1bf564c7a8c6721377b51cffe Reviewed-on: https://gerrit.libreoffice.org/58911 Tested-by: Jenkins Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2018-09-05sc header-footer dlg: fix some a11y issuesKatarina Behrens
Change-Id: Ibeb5f38315668aa83e5f8d92ad955b75d592102d Reviewed-on: https://gerrit.libreoffice.org/59977 Tested-by: Jenkins Reviewed-by: Katarina Behrens <Katarina.Behrens@cib.de>
2018-09-05sc formula options dlg: fix some a11y issuesKatarina Behrens
Change-Id: Ibffcd694e92b25bd26a6d479418a660b77edc11b Reviewed-on: https://gerrit.libreoffice.org/59922 Tested-by: Jenkins Reviewed-by: Katarina Behrens <Katarina.Behrens@cib.de>
2018-09-05tdf#119532 Contextmenu Form updateandreas kainz
Change-Id: If273abd9b65dc3b4bab143de02567bd3cb157e7b Reviewed-on: https://gerrit.libreoffice.org/59957 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-09-05Revert "Menubar Calc: update sheet menuentry according to table in writer"Maxim Monastirsky
This reverts commit 94787b2f8457156c4c9a906717a2b48709ecea91. This reverts commit a96351eda8b18168a7dd1ae4824e4364f2938e5b. This reverts commit e68783344a88b827c5fe6a0fd1174b36d75d4d3c. Change-Id: I726ec48d996ad13f209ce1d139d88401d4d27ddb Reviewed-on: https://gerrit.libreoffice.org/59930 Tested-by: Jenkins Reviewed-by: Maxim Monastirsky <momonasmon@gmail.com>
2018-09-03sc dataprovider/databar dialogs: fix some a11y issuesKatarina Behrens
Change-Id: Id57c11e6e41d5b940e4c48519a198885a593f2ef Reviewed-on: https://gerrit.libreoffice.org/59921 Tested-by: Jenkins Reviewed-by: Katarina Behrens <Katarina.Behrens@cib.de>
2018-08-24tdf#118993 - Missing new Insert Special Character in Calcheiko tietze
Added also to Impress and Draw for consistency Fix for tdf#116355 included and SID_CHARMAP_CONTROL disabled in Impress like SID_CHARMAP Change-Id: I8b9925f6124527dfc27c7a27f6c8832c7e9c88e2 Reviewed-on: https://gerrit.libreoffice.org/58323 Tested-by: Jenkins Reviewed-by: Maxim Monastirsky <momonasmon@gmail.com>
2018-08-23calc menubar move back print range to formatandreas kainz
Change-Id: I289d0dba45a31d26c8eabaf93d60c1d0640b143b Reviewed-on: https://gerrit.libreoffice.org/59482 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-08-23tdf#119420 move conditional and style section back from sheet to formatandreas kainz
Change-Id: I11131e2f1ebe2449c7bdddc2ee739078d98acaf8 Reviewed-on: https://gerrit.libreoffice.org/59481 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-08-19Menubar Calc: update sheet menuentry according to table in writerandreas kainz
Calc sheet menubar entry First section was use the same items than writer so the WriterCategories were moved to GenericCategorie Main benefit is that app specific items are centralized in sheets - Format -> Row, Columns and Merge items are in Sheet on the same subsection than writer - Format -> Print Range was moved from Format to Sheet where SplitTable is in writer - Format -> Conditional and Style stuff was moved to Sheet where the Style stuff is located in writer. In writer there are NO Style items in Format - Tools -> Protect and View -> Protect is centralized in Sheet like in Writer -> Table - Sheet -> Comments are now in Edit -> Comments like i writer open point: Sheet -> Size -> The entries has to be renamed to be more clear (like already in writer) Change-Id: Ic014ccc260dd3264ef6e79a2b71d268e40f22088 Reviewed-on: https://gerrit.libreoffice.org/56912 Tested-by: Jenkins Reviewed-by: Heiko Tietze <tietze.heiko@gmail.com> Tested-by: Heiko Tietze <tietze.heiko@gmail.com>
2018-08-03Allow forcing of intercept to zero in regression dialogDennis Francis
Change-Id: I3958c139141a9e717256a638d319e0bb5879e6a4 Reviewed-on: https://gerrit.libreoffice.org/58565 Tested-by: Jenkins Reviewed-by: Dennis Francis <dennis.francis@collabora.co.uk>
2018-08-01NB calc: add tabbed compact layout to calcandreas kainz
similar to writer Change-Id: Id8e6e2f658228a86a8460e879f1e2942a8209664 Reviewed-on: https://gerrit.libreoffice.org/58284 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-07-26tdf#117647 - Conditional formatting of "Top 10..." misleadingheiko tietze
"Top 10..." misses the option to enter different values; changed top "Top N..." Change-Id: I919fe48cce08ddd52a5f7246b77853c1b8c14253 Reviewed-on: https://gerrit.libreoffice.org/58052 Tested-by: Jenkins Reviewed-by: Heiko Tietze <tietze.heiko@gmail.com>
2018-07-23tdf#118764 Add missing tab stops in sidebar panelsJim Raykowski
Change-Id: I09d5df8d7f07eb4b6c4341d9cd281131fc2df23b Reviewed-on: https://gerrit.libreoffice.org/57535 Tested-by: Jenkins Reviewed-by: Katarina Behrens <Katarina.Behrens@cib.de>
2018-07-18Resolves: tdf#118520 insert sheet list not horizontally expandedCaolán McNamara
Change-Id: I0004602631fb82ed13d925a1911ea4ada544462d Reviewed-on: https://gerrit.libreoffice.org/57632 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-07-17Added option to remove applied transformation.Manuj Vashist
Change-Id: I67634d74151f61441fc618db90687660d6d81d33 Reviewed-on: https://gerrit.libreoffice.org/57536 Tested-by: Jenkins Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2018-07-12Added Number transformation in Data Provider DlgManuj Vashist
Change-Id: I9a2e1e16d7683d790826fdc772fbcfbcf8af9881 Reviewed-on: https://gerrit.libreoffice.org/57149 Tested-by: Jenkins Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2018-07-12Added Aggregate functions to data provider dlgManuj Vashist
Change-Id: Ic6de5319f936095fa1d165fc5901f13d0e7776f5 Reviewed-on: https://gerrit.libreoffice.org/57027 Tested-by: Jenkins Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2018-07-12Added Sort Transformation in Data Provider dlgManuj Vashist
Change-Id: I68ea3d2fc40163d0f3a67bb3723341f8e382db27 Reviewed-on: https://gerrit.libreoffice.org/56914 Tested-by: Jenkins Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2018-07-11NB Implementation: fix Underline command and add CharmapControlandreas kainz
The new CharmapControl action will be used instead of InsertSymbol Change-Id: I9a2e519fb7b8b773763b4c58f8aaa40e6af810b6 Reviewed-on: https://gerrit.libreoffice.org/57283 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-07-10tdf#118645 NB grouped calc: styles drop down menu will work nowandreas kainz
Change-Id: Ie5838d4b36dc95ff234724ec924b78740a15b664 Reviewed-on: https://gerrit.libreoffice.org/57205 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-07-09rename UI element to prevent duplicate IDs in same dialogMarkus Mohrhard
Small improvement for the UI testing. Change-Id: I49fa6a7566a492930532719271b6c83005bc85a8 Reviewed-on: https://gerrit.libreoffice.org/57163 Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com> Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2018-07-09added Text transformation in data provider dlgManuj Vashist
Change-Id: I69d8aae9289ad6d1cbdf92307c16299a533fcd56 Reviewed-on: https://gerrit.libreoffice.org/56807 Tested-by: Jenkins Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2018-07-08tdf#118556 : Respect locale specific decimal separator...Dennis Francis
in Regression dialog box's confidence-level entry. Do not write floating-point numbers to cells as strings using OUString::number() converter if the cell is supposed to be a numeric one. This also amends the uitest document such that the "expected" confidence level cell is numeric and not string. Thanks to Julien Nabet <serval2412@yahoo.fr> for pointing me to the specific issue. Change-Id: I7d12674bf69fc53348366a03b7e6ff0af9588511 Reviewed-on: https://gerrit.libreoffice.org/57151 Tested-by: Jenkins Reviewed-by: Dennis Francis <dennis.francis@collabora.co.uk>
2018-07-06tdf#117903 Add signature line feature to calcSamuel Mehrbrodt
Change-Id: I4e9121803a26cba1f40f8f1c673c7809543ef2ec Reviewed-on: https://gerrit.libreoffice.org/57015 Tested-by: Jenkins Reviewed-by: Samuel Mehrbrodt <Samuel.Mehrbrodt@cib.de>
2018-07-06add a selection for the DB range to Dataprovider dlgMarkus Mohrhard
Change-Id: I02c63b46e21cd8d04e6b515e2cbbee08743d5657 Reviewed-on: https://gerrit.libreoffice.org/49459 Tested-by: Jenkins Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
2018-07-04Menubar Calc: move document compare features to track changes groupandreas kainz
same layout than in writer Change-Id: I9fd0e745b6376c3047c4fa8408543fe11a4852ce Reviewed-on: https://gerrit.libreoffice.org/56899 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-07-02tdf#109042 : Add support for multivariate regression...Dennis Francis
to regression tool. This means we now support more than one X variable(independent variable). One caveat is that all X variable observations needs to be present adjacent to each other in the same table. For example if data is grouped by columns, a valid organization of X variables look like :- X Variables ----> A B C ... XVar1 XVar2 XVar3 ... XVarN | 0.1 0.45 0.32 ... Observations 0.34 0.23 0.54 ... | 0.23 0.56 0.90 ... | 0.32 0.11 0.78 ... V This patch also makes our regression tool output to have similar structure to what Excel and Gnumeric does. This means more statistical measures are added including confidence intervals for all parmeter estimates. We already have support for Logarithmic and Power regression in addition to plain Linear regression. This patch's multivariate support extends to all of these types of regressions. Earlier all regression statistics were computed separately from scratch, which mostly compute the same regression multiple times. This would slow things down if the data-set being analysed is big. This is not true anymore as we use LINEST() formula. LINEST() formula provides all the necessary statistics needed in regression analysis, so here it is called just once and its output components are referenced to compute other statistics(derived). Following are the UI changes for the regression dialog box :- 1. Changed the regression-type selectors from check-boxes to radio-buttons. So only one type of regression can be done at a time. This is because the output of a single regression type itself shows a lot of information and if do all types of regression, it is hard to read and interpret especially for bigger data-sets with lots of X variables. 2. Allow the variable's ranges to have label in them, via a checkbox. If labels are provided, they are used to annotate the variable specific statistics and the user can easily identify the stats corresponding to each variable. 3. More robust input validity checks, with error messages at the bottom of the dialog to let the user know which of their entry is invalid. 4. User can enter the confidence level (default = 95%) for computing the confidence intervals of each estimate. 5. Make residual computations optional via a check-box, as this involves writing a table with all X's and Y with predicted Y and residual for each observation. If the data-set is big, or the user just care about the estimates and confidence intervals, they can avoid this. Finally the patch includes a uitest that tests all 3 types of regressions with a small dataset. The ground truths for the tests were obtained by running regression tool in Gnumeric. Change-Id: I9762b716eae14b9fbd16e2c7228edf9e1930dc93 Reviewed-on: https://gerrit.libreoffice.org/56809 Tested-by: Jenkins Reviewed-by: Michael Meeks <michael.meeks@collabora.com> Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2018-06-28tdf#86612: statusbar: hide some elements if width is not sufficientVasily Melenchuk
new statusbar element property mandatory=true/false to determine if this element can be hidden if total statusbar width is not enough to fit all elements. marked some calc and draw statusbar elements as not mandatory. Change-Id: I20e26d3c4bd865e94ea48632a1e97d55f3fa712f Reviewed-on: https://gerrit.libreoffice.org/56443 Tested-by: Jenkins Reviewed-by: Thorsten Behrens <Thorsten.Behrens@CIB.de>
2018-06-27tdf#114425 add Page Settings to writer and calc NBandreas kainz
add to NB grouped (full and compact) in Edit group cause Format is only Format selected text but not Format page. Edit group is most generic group that fit's for page selection Change-Id: I49af8ff5b560655d43c55818da391a768d26ef04 Reviewed-on: https://gerrit.libreoffice.org/56430 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-06-25NB calc: add initial chart items to object tabandreas kainz
Change-Id: I398c4dd384d021c3e70165968b9fadaf34039959 Reviewed-on: https://gerrit.libreoffice.org/56212 Tested-by: Jenkins Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-06-20menubar scalc: sync with swriter layoutandreas kainz
Change-Id: Iac8cd198b85f83fbd7fa71a228df13f150ef04fc Reviewed-on: https://gerrit.libreoffice.org/56071 Tested-by: Jenkins Reviewed-by: Heiko Tietze <tietze.heiko@gmail.com> Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-06-05Fixes svg vs. png issue for some iconsheiko tietze
Change-Id: Ia2c4a6a2888ef223655a61cf8ace11276739615f Reviewed-on: https://gerrit.libreoffice.org/55312 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Heiko Tietze <tietze.heiko@gmail.com>
2018-05-31tdf#96698 - calc: add support for custom validation (through a formula)Marco Cecchetti
Now it is possible to select a `custom` validation in the validation dialog: this type of validation let's the user to define a formula, the cell content is valid when the formula is evaluted to true, and not valid when evaluated to false. The `cutom` validation is correctly saved and restored for ods documents, and is correctly imported and exported to xlsx documents This patch contains an adaptation of a preliminary work of Justin Luth for importing custom validation from xlsx documents. Thanks Justin! Change-Id: Idc26654ba69a6f73d1b208d63acdad4b880c776d Reviewed-on: https://gerrit.libreoffice.org/49084 Reviewed-by: Michael Meeks <michael.meeks@collabora.com> Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Eike Rathke <erack@redhat.com>
2018-05-28weld ScTabBgColorDlgCaolán McNamara
Change-Id: I864382bc55dead850c13faae9958fb660fd4f156 Reviewed-on: https://gerrit.libreoffice.org/54809 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-23toolbar:id is not valid attribute of toolbar:toolbarChristian Lohmaier
according to framework/dtd/toolbar.dtd – and having the same ID everywhere also is kinda pointless.. Change-Id: Ia7768be2f951886e39e24d78fc6d69b4f3c84235 Reviewed-on: https://gerrit.libreoffice.org/54665 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2018-05-21weld ScSortDlg, ScTabPageSortOptions and ScTabPageSortFieldsCaolán McNamara
Change-Id: I103e5e3670f8c95c1f480ce0c36e08c3de74e900 Reviewed-on: https://gerrit.libreoffice.org/54541 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-20weld ScDataPilotDatabaseDlgCaolán McNamara
Change-Id: Ie8e9914bb8042e33a2ab2a1e07bb0203a54d5422 Reviewed-on: https://gerrit.libreoffice.org/54584 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-20weld ScCalcOptionsDialogCaolán McNamara
Change-Id: I391e26bd95cb3dc6cfa983502aa960a5c54cc800 Reviewed-on: https://gerrit.libreoffice.org/54580 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-20weld ScDPShowDetailDlgCaolán McNamara
Change-Id: Ifbb93a71ac891f4a5621edcd1c3f004a278a088d Reviewed-on: https://gerrit.libreoffice.org/54577 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-20NB calc: update IDsandreas kainz
Change-Id: I0209fe6992d603cac47f1a8f0dd58fd52b9b3a2c Reviewed-on: https://gerrit.libreoffice.org/54592 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-05-19weld ScSortWarningDlgCaolán McNamara
Change-Id: I9462906fbe77a8463d7b283942c5280fdd71239e Reviewed-on: https://gerrit.libreoffice.org/54565 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-19weld ScColRowLabelDlgCaolán McNamara
Change-Id: If706a86b4aa55f2678b3ad9a96e81679eca0faea Reviewed-on: https://gerrit.libreoffice.org/54566 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-19NB Calc update IDsandreas kainz
Change-Id: Ia117cf44d0a7be5798be1fb51c63003b8c64bc86 Reviewed-on: https://gerrit.libreoffice.org/54561 Reviewed-by: andreas_kainz <kainz.a@gmail.com> Tested-by: andreas_kainz <kainz.a@gmail.com>
2018-05-19NB: update IDsandreas kainz
Change-Id: I41e16c68709a85c4d06a6a0de737b5eb59d2a5d9 Reviewed-on: https://gerrit.libreoffice.org/54558 Reviewed-by: andreas_kainz <kainz.a@gmail.com> Tested-by: andreas_kainz <kainz.a@gmail.com>
generated by cgit (git 2.34.1) at 2025-02-15 17:24:58 +0000