Re: behavior of new functions XLOOKUP and XMATCH

Hi *, Mike Kaganski wrote: > Emitting error is the only sane way here. No error message means doing > something different than user requested, without user knowing that, with no > practical benefit (the wildcards / regexes won't be used, so the task is not > done anyway). > My understanding is, th

core.git: android/source

android/source/AndroidManifest.xml|1 android/source/src/java/org/libreoffice/FormattingController.java | 38 +++--- 2 files changed, 13 insertions(+), 26 deletions(-) New commits: commit e1216e47751b80238825aaeb21702d46dc34 Author: Michael Wegh

core.git: 3 commits - android/source

android/source/AndroidManifest.xml|2 android/source/build.gradle |4 - android/source/gradle/wrapper/gradle-wrapper.properties |4 - android/source/lint-baseline.xml | 2

Re: behavior of new functions XLOOKUP and XMATCH

Correct me but =XLOOKUP(C3;A$1:A$3;B$1:B$3;"INV";_3_;1) returns #VALUE! (Excel) or Err:504 (LO) =_Y_LOOKUP(C4;A$1:A$3;B$1:B$3;"INV";0;1) returns #NAME? (both) What exactly will change? PS: ux-advice@ is the forward mailing list from Bugzilla and I'm not sure how many people have registered. Ra

core.git: Branch 'libreoffice-24-2' - download.lst

download.lst |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit 2041013fd9759fdd7fc242ee4ae870175bab4801 Author: Xisco Fauli AuthorDate: Wed May 8 12:15:59 2024 +0200 Commit: Adolfo Jayme Barrientos CommitDate: Tue May 14 08:06:50 2024 +0200 Update lan

core.git: Branch 'libreoffice-24-2' - vcl/osx

vcl/osx/salinst.cxx | 17 - 1 file changed, 16 insertions(+), 1 deletion(-) New commits: commit 812c3cf069b068b75d01662c241b52bec2dd2928 Author: Patrick Luby AuthorDate: Tue May 7 17:41:10 2024 -0400 Commit: Adolfo Jayme Barrientos CommitDate: Tue May 14 07:34:24 2024

core.git: vcl/source

vcl/source/control/spinfld.cxx | 13 +++-- 1 file changed, 11 insertions(+), 2 deletions(-) New commits: commit 869b88488ac443cc64943254064da20b0f361c56 Author: Michael Weghorn AuthorDate: Mon May 13 16:37:45 2024 +0200 Commit: Michael Weghorn CommitDate: Tue May 14 07:25:44 2

core.git: sw/qa xmloff/source

sw/qa/core/text/data/number-portion-format.odt |binary sw/qa/extras/odfimport/data/empty_line_in_text_box.fodt | 31 sw/qa/extras/odfimport/odfimport.cxx| 53 + xmloff/source/text/txtparai.cxx | 62 4

Re: behavior of new functions XLOOKUP and XMATCH

On 14.05.2024 3:23, Regina Henschel wrote: Combining parameter values for wildcard mode and binary search is possible. But there exist no way to actually do it. Excel gives an error messages in such cases. LibreOffice silently switches to linear search. ... Some arguments so far: * No error m

core.git: svx/qa svx/source

svx/qa/unit/data/tdf128433_rectanglecontourtext_CJK.fodg | 418 +++ svx/qa/unit/data/tdf84507_polygoncontourtext.fodg| 396 ++ svx/qa/unit/svdraw.cxx | 33 + svx/source/svdraw/svdotextdecomposition.cxx | 66 ++ 4

behavior of new functions XLOOKUP and XMATCH

Hi UX-experts, the new function XLOOKUP and XMATCH have a Match_mode with values 0, 1, -1, 2 and a Search_mode with values 1, -1, 2, -2. The Match_mode 2 means wildcard mode, that is ? * search or regular expressions search. The Search_modes 2 and -2 mean binary search in a sorted array. Com

core.git: download.lst external/poppler

download.lst |4 +- external/poppler/UnpackedTarball_poppler.mk |1 external/poppler/char_traits.patch | 11 - external/poppler/disable-freetype.patch.1|4 +- external/poppler/disable-nss-and-gpgmepp.patch.1 | 45 +

core.git: sd/source

sd/source/ui/dlg/tpoption.cxx |6 -- sd/source/ui/view/drviewsg.cxx |5 - sd/source/ui/view/frmview.cxx |3 ++- 3 files changed, 10 insertions(+), 4 deletions(-) New commits: commit 25e53d411097849ae9a00af40c6d786fa1daf2b6 Author: Gabor Kelemen AuthorDate: Tue May 7 09:

core.git: Branch 'libreoffice-24-2' - download.lst

download.lst |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit a4c2c23cbb77a2d821e71e6a51f8e6d1779f1e3e Author: Xisco Fauli AuthorDate: Mon May 13 12:45:05 2024 +0200 Commit: Caolán McNamara CommitDate: Mon May 13 20:26:35 2024 +0200 libxml2: upgrade

core.git: sfx2/source

sfx2/source/bastyp/fltfnc.cxx |3 +++ sfx2/source/view/lokhelper.cxx |1 + 2 files changed, 4 insertions(+) New commits: commit 5e6d9c38a7ef4027734064b83ca328df258a575c Author: Caolán McNamara AuthorDate: Mon May 13 14:18:25 2024 +0100 Commit: Caolán McNamara CommitDate: Mon Ma

core.git: 2 commits - sot/qa sot/source stoc/source stoc/test

sot/qa/cppunit/test_sot.cxx |2 sot/source/base/exchange.cxx | 250 +- sot/source/sdstor/stgelem.cxx |2 sot/source/sdstor/stgole.cxx

core.git: svtools/qa svtools/source

svtools/qa/unit/testHtmlReader.cxx |4 svtools/source/brwbox/brwbox1.cxx | 10 - svtools/source/brwbox/datwin.cxx|2 svtools/source/brwbox/ebbcontrols.cxx | 40 ++-- svtools/source/brwbox/recorditemwindow.cxx

core.git: 2 commits - svx/source

svx/source/form/fmcontrollayout.cxx |7 +-- svx/source/form/fmsrccfg.cxx| 65 ++-- 2 files changed, 29 insertions(+), 43 deletions(-) New commits: commit 5f739e1f35a600984a4f99d6394e821a71b69712 Author: Noel Grandin AuthorDate: Fri May 10 11:51:3

core.git: download.lst

download.lst |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit 4133e187c99b19bd5986d0c8af923e9f1400f82b Author: Xisco Fauli AuthorDate: Mon May 13 17:49:48 2024 +0200 Commit: Xisco Fauli CommitDate: Mon May 13 18:12:26 2024 +0200 lxml: fix --enable-py

core.git: Branch 'distro/collabora/co-23.05' - sc/source

sc/source/ui/undo/undobase.cxx | 23 --- 1 file changed, 16 insertions(+), 7 deletions(-) New commits: commit 6d2f14936040a60909ec0815f39b2622411bd4ee Author: Pranam Lashkari AuthorDate: Fri May 10 02:02:18 2024 +0300 Commit: Pranam Lashkari CommitDate: Mon May 13

core.git: external/skia

external/skia/help-msvc-analyzer.patch |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit d8467a1123fd101bf1209ce19a7bb33a5da9d3ce Author: Caolán McNamara AuthorDate: Mon May 13 13:32:33 2024 +0100 Commit: Caolán McNamara CommitDate: Mon May 13 17:38:28 2024 +0

core.git: offapi/com oovbaapi/ooo sc/inc sc/source sc/uiconfig test/source

offapi/com/sun/star/sheet/TableValidation.idl |7 oovbaapi/ooo/vba/excel/XValidation.idl |1 sc/inc/conditio.hxx|6 +++ sc/inc/fmtuno.hxx |1 sc/inc/sc.hrc | 19 +--

core.git: download.lst

download.lst |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit 96f74d85983fd693d349d593c4389a8f990fdaaa Author: Xisco Fauli AuthorDate: Mon May 13 09:44:02 2024 +0200 Commit: Xisco Fauli CommitDate: Mon May 13 17:01:33 2024 +0200 lxml: Upgrade to 5.2.

core.git: configure.ac download.lst external/icu include/svx svx/source

configure.ac|4 ++-- download.lst|8 external/icu/icu4c-khmerbreakengine.patch.1 |1 - include/svx/strings.hrc |1 + svx/source/dialog/charmap.cxx |5 + 5 files change

core.git: download.lst

download.lst |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit b6f9caeb081da2004f067ad9216875c86eead8b1 Author: Xisco Fauli AuthorDate: Mon May 13 13:27:33 2024 +0200 Commit: Xisco Fauli CommitDate: Mon May 13 16:42:41 2024 +0200 postgresql: Upgrade t

core.git: download.lst

download.lst |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit 96698d3a72d8496358786ffedc7b6eb22af3648c Author: Xisco Fauli AuthorDate: Wed May 8 12:15:59 2024 +0200 Commit: Eike Rathke CommitDate: Mon May 13 16:40:18 2024 +0200 Update language-subtag

core.git: download.lst

download.lst |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit 02dc762466c655e9ca6fb7cef92b1495915b34ed Author: Xisco Fauli AuthorDate: Mon May 13 12:45:05 2024 +0200 Commit: Xisco Fauli CommitDate: Mon May 13 15:46:05 2024 +0200 libxml2: upgrade to 2

core.git: odk/examples

odk/examples/DevelopersGuide/Components/Addons/JobsAddon/AsyncJob.java |4 ++-- odk/examples/DevelopersGuide/Forms/ControlValidator.java |2 +- odk/examples/DevelopersGuide/Forms/RowSet.java |2 +- odk/examples/D

core.git: 2 commits - include/tools svx/source sw/source tools/source

include/tools/datetimeutils.hxx |6 +++-- svx/source/tbxctrls/StylesPreviewToolBoxControl.cxx | 11 + sw/source/core/doc/docbm.cxx|2 - sw/source/core/doc/doclay.cxx |2 - sw/source/core/doc/docnum.cxx

core.git: 3 commits - sccomp/qa sccomp/source scripting/source slideshow/qa slideshow/source

sccomp/qa/unit/SwarmSolverTest.cxx | 14 +- sccomp/qa/unit/solver.cxx |6 sccomp/source/solver/CoinMPSolver.cxx |2 sccomp/source/solver/LpsolveSolver.cxx |

core.git: 2 commits - helpcontent2 sc/source sc/uiconfig

helpcontent2 |2 +- sc/source/ui/app/inputhdl.cxx |3 +++ sc/source/ui/inc/viewdata.hxx |4 sc/source/ui/view/gridwin4.cxx | 21 +++-- sc/source/ui/view/tabvwsh4.cxx |1 + sc/source/ui/view/viewdata.cxx |1 + sc

help.git: source/text

source/text/scalc/01/02120100.xhp |6 +- 1 file changed, 5 insertions(+), 1 deletion(-) New commits: commit 71a04be1be73ec7cd27e14e152c01521b3c4b33e Author: Olivier Hallot AuthorDate: Fri May 10 11:59:26 2024 -0300 Commit: Olivier Hallot CommitDate: Mon May 13 13:24:16 2024 +020

core.git: sfx2/uiconfig

sfx2/uiconfig/ui/descriptioninfopage.ui | 14 +++--- 1 file changed, 7 insertions(+), 7 deletions(-) New commits: commit 37929d4be4623e1060a7b913e1693e92d823f135 Author: Dione Maddern AuthorDate: Wed May 8 13:55:30 2024 -0400 Commit: Olivier Hallot CommitDate: Mon May 13 13:22

core.git: tools/source

tools/source/fsys/urlobj.cxx | 62 +-- 1 file changed, 31 insertions(+), 31 deletions(-) New commits: commit 05d4420c5e3c87dc458dd775039b58fc2baa0489 Author: Noel Grandin AuthorDate: Fri May 10 10:26:27 2024 +0200 Commit: Noel Grandin CommitDate

core.git: vcl/win

vcl/win/dtrans/MtaOleClipb.cxx |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 1942d4c6f9b48554d0dc7ea95c8ec38624f40045 Author: Caolán McNamara AuthorDate: Mon May 13 08:34:47 2024 +0100 Commit: Caolán McNamara CommitDate: Mon May 13 12:44:23 2024 +0200

core.git: sw/qa

sw/qa/extras/layout/layout3.cxx |6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) New commits: commit 9c7acbc937b3b341c10187b837e09cc20399f04e Author: Miklos Vajna AuthorDate: Mon May 13 08:37:22 2024 +0200 Commit: Miklos Vajna CommitDate: Mon May 13 12:15:08 2024 +0200

core.git: Branch 'distro/collabora/co-24.04' - sw/qa

sw/qa/core/layout/layout.cxx |4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) New commits: commit b6f42a6006dd0b0e4234ed5e0f536b7f4d8a Author: Miklos Vajna AuthorDate: Fri May 10 08:07:41 2024 +0200 Commit: Caolán McNamara CommitDate: Mon May 13 12:06:55 2024 +0200

core.git: vcl/ios

vcl/ios/clipboard.cxx | 77 +- vcl/ios/clipboard.hxx | 15 + 2 files changed, 91 insertions(+), 1 deletion(-) New commits: commit 4e5040dc44024f8313ca51627b6871675865cdf6 Author: Patrick Luby AuthorDate: Sat Apr 13 19:46:48 2024 -04

core.git: Branch 'libreoffice-24-2' - sw/qa sw/source

sw/qa/extras/uiwriter/data/tdf160842.fodt | 75 ++ sw/qa/extras/uiwriter/uiwriter6.cxx | 41 sw/source/core/frmedt/feshview.cxx| 22 3 files changed, 138 insertions(+) New commits: commit 5ad48954250b9235f4381a756445c318d2d

core.git: Branch 'libreoffice-24-2' - sw/qa sw/source

sw/qa/extras/uiwriter/uiwriter6.cxx | 66 sw/source/uibase/uiview/viewtab.cxx |2 - 2 files changed, 67 insertions(+), 1 deletion(-) New commits: commit 5b3037e2caa5dc857f51dd0dd7f38646535ee232 Author: László Németh AuthorDate: Tue Apr 23 16:04:47 2

core.git: Branch 'distro/collabora/co-24.04' - sw/qa sw/source writerfilter/source

sw/qa/extras/ooxmlexport/ooxmlexport17.cxx |4 - sw/source/core/fields/reffld.cxx| 66 +++- writerfilter/source/dmapper/StyleSheetTable.cxx | 14 + 3 files changed, 58 insertions(+), 26 deletions(-) New commits: commit ec1c8270dd25fee7035e3fec5

core.git: Branch 'distro/collabora/co-24.04' - sw/source

sw/source/uibase/uiview/viewtab.cxx |8 1 file changed, 8 insertions(+) New commits: commit c6c1c7afc18f32453c06a3af25f389ccb9074a1b Author: Jaume Pujantell AuthorDate: Fri May 10 10:04:47 2024 +0200 Commit: Tomaž Vajngerl CommitDate: Mon May 13 10:47:31 2024 +0200 sw:

core.git: sc/source

sc/source/ui/view/prevwsh.cxx | 19 --- 1 file changed, 8 insertions(+), 11 deletions(-) New commits: commit 78e0626bc7bf37d1eda2e3151dd1a44056f92032 Author: Rafał Dobrakowski AuthorDate: Thu May 9 18:18:43 2024 +0200 Commit: Ilmari Lauhakangas CommitDate: Mon May 13 1

core.git: include/svx svx/source

include/svx/svdundo.hxx | 10 +++ svx/source/svdraw/svdundo.cxx | 56 +- 2 files changed, 33 insertions(+), 33 deletions(-) New commits: commit 74bd51629eed7eb34aef9acbb93c110525f8ef7d Author: Miklos Vajna AuthorDate: Mon May 13 08:33:27

Re: Windows build broken.

On 13.5.2024 11.09, Regis Perdreau wrote: Hi, I follow carefully again windows build instruction wiki, but the windows build does not work again. Could you we expect that it will work for everybody not only on developper's computer ? (i know it's sometimes difficult, but if we could have som

Windows build broken.

Hi, I follow carefully again windows build instruction wiki, but the windows build does not work again. Could you we expect that it will work for everybody not only on developper's computer ? (i know it's sometimes difficult, but if we could have some news, it's better) Regards, Régis Perdreau

Re: OSS-fuzzing

On Sun, 2024-05-12 at 21:00 +0300, Даблус wrote: > Hello. I want to try to run oss-fuzz tests by myself, but i found no > info about it. I found some scripts in the "bin" folder, like oss- > fuzz-setup.sh and oss-fuzz-build.sh, and found that I should use > clang, but I found nothing about the envi

core.git: include/unotools unotools/source

include/unotools/fontdefs.hxx|2 - unotools/source/misc/fontcvt.cxx | 47 +++ 2 files changed, 24 insertions(+), 25 deletions(-) New commits: commit daf7e7dc3ee1a8ab0d519c1537b9bd83379b98ed Author: Noel Grandin AuthorDate: Fri May 10 10:21:30 202

core.git: 3 commits - unoxml/source xmloff/inc xmloff/source

unoxml/source/rdf/CURI.cxx| 266 ++ xmloff/inc/animations.hxx |2 xmloff/source/draw/animationexport.cxx| 48 ++--- xmloff/source/draw/animationimport.cxx|4 xmloff/source/text/XMLIndexTOCContext.cxx | 20 +- 5 file

core.git: sd/source

sd/source/ui/dlg/tpoption.cxx |6 -- sd/source/ui/view/drviewsg.cxx |5 - sd/source/ui/view/frmview.cxx |3 ++- 3 files changed, 10 insertions(+), 4 deletions(-) New commits: commit d9d699756125db28bd45d7c92d4c9c2dc243f418 Author: Gabor Kelemen AuthorDate: Fri May 3 11: