summaryrefslogtreecommitdiff
path: root/sc/uiconfig
AgeCommit message (Collapse)Author
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>
2018-05-18weld ScSelEntryDlgCaolán McNamara
Change-Id: I1bc78b61a50f909ceb4c79e9dc9425306d41e617 Reviewed-on: https://gerrit.libreoffice.org/54534 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-18weld ScDataPilotSourceTypeDlg and ScDataPilotServiceDlgCaolán McNamara
Change-Id: I03ef6f1994e8e1a801e4515586a6a73d3748f13b Reviewed-on: https://gerrit.libreoffice.org/54528 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-18weld DataStreamDlgCaolán McNamara
Change-Id: I8da7228de5a1a9b7637c8c43ffd79f5f044bc788 Reviewed-on: https://gerrit.libreoffice.org/54521 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-18weld ScInsertTableDlgCaolán McNamara
Change-Id: Ia3e00ccdc89aaf7b5546a0b346d174814fcea97d Reviewed-on: https://gerrit.libreoffice.org/54518 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-17weld ScInsertContentsDlgCaolán McNamara
Change-Id: I432048f086e4aa49ebac6a6cdafd1e11c3832ab0 Reviewed-on: https://gerrit.libreoffice.org/54445 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-16tdf#117630 wrong accelerator character for update commandandreas kainz
Change-Id: I36888ddda9ca5cfd9f5e9d344d0656917637f348 Reviewed-on: https://gerrit.libreoffice.org/54404 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-05-15NB Implementation: update Menu drop down menuandreas kainz
Change-Id: If4b5ba6579e06a3f179de032919bdf7335b39a7b Reviewed-on: https://gerrit.libreoffice.org/54389 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: andreas_kainz <kainz.a@gmail.com>
2018-05-15NB Implementations: update for better maintenance and syncandreas kainz
Change-Id: I024d597f218824d8618d113a5aaae2fd314ec807 Reviewed-on: https://gerrit.libreoffice.org/54367 Reviewed-by: andreas_kainz <kainz.a@gmail.com> Tested-by: andreas_kainz <kainz.a@gmail.com>
2018-05-15weld ScSolverNoSolutionDialogCaolán McNamara
Change-Id: I403e39e0f5cd642c5996a49f50cc7ee7bbdfbd02 Reviewed-on: https://gerrit.libreoffice.org/54354 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-15weld ScSolverSuccessDialogCaolán McNamara
Change-Id: I29bf7b59fbac8f969e5a61963d65b626ac03b0fa Reviewed-on: https://gerrit.libreoffice.org/54355 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-15weld ScSolverIntegerDialogCaolán McNamara
Change-Id: I4d7196ead0dd60fe4b40af72a1c7ec64c5a2315a Reviewed-on: https://gerrit.libreoffice.org/54352 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-15weld ScColOrRowDlgCaolán McNamara
Change-Id: I475974fc54910da88064779ceae6586bd71a3865 Reviewed-on: https://gerrit.libreoffice.org/54356 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-15weld ScSolverValueDialogCaolán McNamara
Change-Id: I1c55d184052482fc472d66069ea8722cd27d1543 Reviewed-on: https://gerrit.libreoffice.org/54353 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-15weld ScFillSeriesDlgCaolán McNamara
Change-Id: I1b4c6777d3334813c6bfe47efbb67f065efa555c Reviewed-on: https://gerrit.libreoffice.org/54338 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2018-05-15weld ScRetypePassInputDlgCaolán McNamara
Change-Id: Ie57f3fdaeed5b15f2ce7a1825debdc92788b4e94 Reviewed-on: https://gerrit.libreoffice.org/54343 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>