summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
2019-08-05Add missing error codeMike Kaganski
... leftover from commit 4dcfe928580c1492bb265eb6070f66459a4c03db Error 515 is also published. Change-Id: I0aacf748df88ab329a6d4d8ea4d84f890fb1745d Reviewed-on: https://gerrit.libreoffice.org/76509 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2019-07-15Clarify example for SWITCHOlivier Hallot
...But the function need a date in A3 instead of a number. So in my opinion the string should be: <input>=SWITCH(MONTH(A3),1,"January",2,"February",3,"March","No match")</input> returns "January" when A3 contains a date in January, "February" when A3 contains a date in February , etc... Change-Id: I2702d569f1c43080cd4c137a4d100111edc55863 Reviewed-on: https://gerrit.libreoffice.org/75499 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-07-13Add missing Calc error codesMike Kaganski
See include/formula/errorcodes.hxx; added those that return true from isPublishedFormulaError. Change-Id: I64595a9dd2c7770ba48f4e4a514f07179a8125fe Reviewed-on: https://gerrit.libreoffice.org/73744 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2019-07-05Insert sys=MAC in some menu pathsOlivier Hallot
MAC often forgotten in menu path descriptions. Change-Id: Ib6e9062b06389063d6f8293a95cd3e07e1919161 Reviewed-on: https://gerrit.libreoffice.org/75040 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-07-02Fix typoAndrea Gelmini
Change-Id: Ia277377ea5329d26717c80a0aeb8c393ba87cff3 Reviewed-on: https://gerrit.libreoffice.org/74998 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2019-07-02Add Help for FOURIER calc function and analysisOlivier Hallot
Refactor sample tables, Mute l10n for numbers FOURIER function Fourier analysis Sample file Change-Id: If5361fe009ec380e9cdd6f3e24184471c1451421 Reviewed-on: https://gerrit.libreoffice.org/74914 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-06-26tdf#122753 Calc AutoFormat Styles updateOlivier Hallot
Change-Id: I7b099f3b94f901af1885b942ce71c5815c1a4918 Reviewed-on: https://gerrit.libreoffice.org/74711 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-06-25Remove duplicated HID bookmarks in scalcGabor Kelemen
Also remove a few obsolete bookmarks and fix ahelps Duplicates found with: for i in $(find source/text/scalc -name "*xhp") ; do grep branch=\"hid/.uno: "$i" | cut -d ":" -f2 | cut -d \" -f 1 | uniq -c | grep -v "1 " ; if [ $? -eq 0 ] ; then echo "Above HID branches are redundant in: $i" ; fi done Change-Id: I5a6a817065257ebffe7d0ed88f37c67ede86fb41 Reviewed-on: https://gerrit.libreoffice.org/74656 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-06-10Clarify HLOOKUP/VLOOKUPMike Kaganski
Change-Id: I8093a173547850ff0a145a2985a25f46e3ae0297 Reviewed-on: https://gerrit.libreoffice.org/73746 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-06-02tdf#125645 Fix reference in SWITCH function help pageOlivier Hallot
Change-Id: I34cd365829187ea29fd45c43aa08d0b6a3cfdd4d Reviewed-on: https://gerrit.libreoffice.org/73352 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-05-14Fix typosAndrea Gelmini
Change-Id: I79db4363c15786f3829faf24621f073cf481191a Reviewed-on: https://gerrit.libreoffice.org/72257 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2019-05-13More detailed help of Calc's Sheet > Link to external dataKatarina Behrens
Make it more clear there has to be at least 1 named range in Excel of Calc documents Change-Id: I782c4d2c10ee52320bfdf147652883f5e7b4751a Reviewed-on: https://gerrit.libreoffice.org/72076 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-04-27tdf#99517 help for CONCAT, TEXTJOIN, IFS, SWITCHOlivier Hallot
CONCAT, TEXTJOIN, IFS, SWITCH Change-Id: Ic1d74ac8b810bd0c0d4b4f570baab1d1e270f912 Reviewed-on: https://gerrit.libreoffice.org/71339 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-04-27tdf#123803 Add release info in Calc functionsOlivier Hallot
Change-Id: I0476c79fe5407c3e7252ef16da4110a026b29fa8 Note: some Calc functions still lack help pages. Reviewed-on: https://gerrit.libreoffice.org/71331 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-04-27tdf#124198 Impress & Draw ImageMap menu entry was moved to ToolsIlmari Lauhakangas
Also renamed the file describing Edit Menu to edit_menu.xhp. Most of the files are touched to update the links due to rename. There is no context menu entry for ImageMap, so removed mention of it. Note that in Writer and Calc, ImageMap remains under Edit, because it is only enabled when an image is selected. Change-Id: Ic57ee11dd2ab9c637f00e5328f1575c323fb8c43 Reviewed-on: https://gerrit.libreoffice.org/71397 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-04-23tdf#105848 Change EFFECTIVE function name to EFFECTRoman Kuznetsov
Change-Id: Id2bd603a0330f1d85e665c0524635e0369061a18 Reviewed-on: https://gerrit.libreoffice.org/71079 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-04-11tdf#118093 Fix ANOVA help pageOlivier Hallot
Add last column in table (F-critical) Change-Id: I988127a6adfc0890770c4eb3922ba2c162113310 Reviewed-on: https://gerrit.libreoffice.org/70580 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-03-16VLOOKUP's Array parameter may take 1-column arraysMike Kaganski
It only depends on Index value; so for Index=1, 1-column array input is OK. Change-Id: I80d5655ffcb9374fcdce570f56606d5ff594002c Reviewed-on: https://gerrit.libreoffice.org/67716 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-03-04tdf#123803 Add relelase info in Calc functionsOlivier Hallot
Patch is for REGEX function available since release 6.2 To add release information to other functions look at the diff in func_regex.xhp and adjust the release. It should be straightforward: <embed href="text/scalc/00/avail_release.xhp#M.N"/> where M is version and N is release. Patch tweaked to minimize translation effort (only one string) Change-Id: I4f5f826c936e65c1050a4d3b71379b53d50e0984 Reviewed-on: https://gerrit.libreoffice.org/68688 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-02-25tdf#123192 - Improve help for function ATAN2Mark
updated text in ATAN2 section of 04060106.xhp added coordinates-to-polar-01.svg changed example and image removed 'Important!', added 'radians' changed 'LibreOffice' to '%PRODUCTNAME' created new folder 'scalc' under 'media/helpimg/' moved coordinates-to-polar-01.svg to new folder and added the path/image name to Package_html_media.mk droped xml-lang="en-US" tag, removed 'Note', removed '<pre>' tag, did not add <embed> as Jenkins rejects it. Change-Id: I5cff6289e8ab25f511e7d31ba2d4ad733dea184a Reviewed-on: https://gerrit.libreoffice.org/67619 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-02-22Default Add value for Optimal Column Width is 2 mm, not 0.1 inMike Kaganski
See ScCellShell::Execute implementation [1] which passes STD_EXTRA_WIDTH (defined as 113 twips = 2 mm) to the dialog as the default value. The text here (that was 0.1 in) is translated to other languages (incl. those using metric units) verbatim (e.g. Russian translation); or if a translation team would want to convert to metric, there is no indication that the 0.1 in is just an approximation of an exact metric value. [1] sc/source/ui/view/cellsh3.cxx:693 Change-Id: I1710588ee40840d85eeb89aaeee135a8aa0a942f Reviewed-on: https://gerrit.libreoffice.org/67936 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2019-02-18HELP: Add new internal error codes for CalcRoman Kuznetsov
Source - /core/include/formula/errorcodes.hxx Change-Id: I64fcef138cf9ec89d4501ea71aa4bab54d9d04fd Reviewed-on: https://gerrit.libreoffice.org/67620 Tested-by: Jenkins Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-02-16Document some Calc shortcutsIlmari Lauhakangas
Shift+Space, Ctrl+Space and Ctrl+Shift+Space were undocumented. Change-Id: I133bd7e92f43d53f0d6ab22bdf249ff5528dc777 Reviewed-on: https://gerrit.libreoffice.org/67899 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-02-08Fix "Error: Duplicated entry. ID = par_id3146919"Stephan Bergmann
...after 00c5a418955574905aed5137c43ce2219b50e6f9 "Minor color and padding tweaks; some styling for TOC" Change-Id: I4340e2e52a5cbd7627364157aeb9eec17bc96cb4
2019-02-07tdf#107930 - Help needs to be corrected and amended for RecalculationMark
changed test in 06080000.xhp Change-Id: I4cc8a0a04517306e5196aa79c607e624b488a56f Reviewed-on: https://gerrit.libreoffice.org/67518 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2019-02-02Bug 107930 - Help needs to be corrected and amended for RecalculationMark
add 'recalculate' bookmark_value to 06080000.xhp and 06070000.xhp, created 'exnbr' section in 00000406.xhp for 'Tools -> Options -> LibreOffice Calc -> Formula' and added 'embed' tag to 01060900.xhp changed 00000406.xhp LibreOffice text to %PRODUCTNAME Change-Id: Id3c6dffd31b1b72a854a5bd11902d2c22109900a Reviewed-on: https://gerrit.libreoffice.org/67237 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-01-28A couple of articles and tag vomit cleanupAdolfo Jayme Barrientos
Change-Id: I5e3d9c7f9ce78807d1acfa190a740f41ddd8a378
2019-01-25Fix typoAndrea Gelmini
Change-Id: I7603a2f8eb144bf243cbf5b5d4812e7aa3a1649a Reviewed-on: https://gerrit.libreoffice.org/66907 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-01-25Related: tdf#121173 double spaces in sentencesSophia Schröder
Change-Id: I4cdde42510bdf0cf50a91caf208133666a412b27 Reviewed-on: https://gerrit.libreoffice.org/64893 Tested-by: Jenkins Reviewed-by: Sophie Gautier <gautier.sophie@gmail.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-01-18tdf#121781 Clarify TZ info in Calc functionsOlivier Hallot
Notify user that TZ are not considered in date & time functions and in date & time formatted cells. Change-Id: I684039ebcc095fe4eefc2bf573df18679dd7f9f3 Reviewed-on: https://gerrit.libreoffice.org/66468 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-19Fix code formatting in validity help pagesOlivier Hallot
Change-Id: I9b0558bb805512c98223eaf2305d37861e10c82c Reviewed-on: https://gerrit.libreoffice.org/65458 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-19http -> httpsEike Rathke
Turns out the https://www.oasis-open.org/standards#opendocumentv1.2 page has linked them badly with http ... Change-Id: I64d26f79f4503a6b795c4990cf92327d20fbb08a Reviewed-on: https://gerrit.libreoffice.org/65459 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2018-12-19Point to the correct ODFF 1.2 specification download linkEike Rathke
The previously pointed to office-formula page is the collection of working drafts. Change-Id: Id8bc75e2192ce8da26ca1af1d8779560ace14b6b Reviewed-on: https://gerrit.libreoffice.org/65454 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2018-12-13Help files: http -> httpsSophia Schröder
+ some more conservative changes Change-Id: I328505b05838c3f3ce40759096ca77d30c874c57 Reviewed-on: https://gerrit.libreoffice.org/63196 Tested-by: Jenkins Reviewed-by: Sophie Gautier <gautier.sophie@gmail.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-11Correct some Format - Row/Column/Cell pathsSabri Unal
Some Format - Row/Column/Cell paths are corrected as Format - Rows/Columns/Cells Change-Id: If9795322ca50f3f5646b9195de69eb1e348662cf Reviewed-on: https://gerrit.libreoffice.org/64985 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-11Fix contents after translators reviewOlivier Hallot
Change-Id: I674796639284397c019240c4cd2ee79adb5b6ec0 Reviewed-on: https://gerrit.libreoffice.org/64960 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-08Fixes in Help page after translators reviewOlivier Hallot
Change-Id: I8ad08be0881d10bbe3ca8eac4647118cf5d4fa18 Reviewed-on: https://gerrit.libreoffice.org/64806 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-12-01REGEX: correct ICU URL to use http, not https (which seems unavailable)Mike Kaganski
Change-Id: Iaeed0d81dc88418c2bffab730fd682ca8cb3b101 Reviewed-on: https://gerrit.libreoffice.org/64313 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2018-11-29Occurrence number as REGEX() 4th argument, tdf#113977 tdf#121084Eike Rathke
Change-Id: I42be8bbc4e7c11e09cb66bf12f164c4fc565b54b Reviewed-on: https://gerrit.libreoffice.org/64276 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2018-11-26tdf#120927 Webservice functions needs linking toOlivier Hallot
Change-Id: I8d96025238fc2005dab37c1050a0c7915210d73a Reviewed-on: https://gerrit.libreoffice.org/64055 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-19update menu command to protect spreadsheet structureStanislav Horacek
Change-Id: I14e424aea344ffeab47bc68d99b98dd56492dcbc Reviewed-on: https://gerrit.libreoffice.org/63521 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-19update commands to insert column before/after active columnStanislav Horacek
Change-Id: Ie633d63e70103f2eda88a677e72c7e91482e5ac0 Reviewed-on: https://gerrit.libreoffice.org/63523 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-16tdf#121084 Help page for Calc REGEX functionOlivier Hallot
* honor DTD * follow erAck advise Change-Id: Ib911888fbc5aae9c4a749c9343218081df9f6783 Reviewed-on: https://gerrit.libreoffice.org/63430 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2018-11-12Fix Contents, after translators review (2)Olivier Hallot
Change-Id: Ia1038fbfc054efa457fae5d28d1a2e737dba1d45 Reviewed-on: https://gerrit.libreoffice.org/63308 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-12Fix contents, after translators review.Olivier Hallot
Change-Id: I142b6ec74d06d1153675c50079ebda6273e44414 Reviewed-on: https://gerrit.libreoffice.org/63305 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-06related: tdf#121173: double space cleanupsSophia Schröder
..and some more improvements (hopefully) Change-Id: I17e6656ff0f0274c342b62e72405d396437c8964 Reviewed-on: https://gerrit.libreoffice.org/62923 Tested-by: Jenkins Reviewed-by: Bartosz Kosiorek <gang65@poczta.onet.pl>
2018-10-28GrammarAdolfo Jayme Barrientos
Change-Id: I3d3bc317afd35bce5c941144417b7222e9063ae8
2018-10-25tdf#120221 Add experimental noteIlmari Lauhakangas
Change-Id: I591c7ef34a84059060a7eeeff15ad2f7b6cc58ae Reviewed-on: https://gerrit.libreoffice.org/62365 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-10-15Related: tdf#102257 adjust Help, RANDBETWEEN() volatile like RAND()Eike Rathke
Change-Id: Id200bd4886ccc6e5f932d2872d5969f0196b7332
2018-10-05Update help on Help in module pagesOlivier Hallot
fix DTD issue Change-Id: I178683b7352e2eff3de111bbb726d2ab60a31063 Reviewed-on: https://gerrit.libreoffice.org/61429 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2025-03-13 11:07:02 +0000