resolved fdo#67572 export add-in equivalents as internal to .xlsx

For OOXML .xlsx export the add-in functions that are equivalents of
known internal functions as those internal functions.

(cherry picked from commit da7c6092a644dc22f90fb8eef0c4f0df06ec204a)

Minus the DURATION change that was fixed on master (and 4.2) with
62e1a27dc757637223f5f18b1a340ba138e0cb82

Change-Id: Ic41f32b67902effa07c3d4db137be08dc5af7265
Reviewed-on: https://gerrit.libreoffice.org/6530
Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
resolved fdo#61946 use correct TabDelta for UpdateReference

The sheet delta was reverted resulting in the references not being
updated when conditional formats were copy-pasted between sheets. Saved
to .ods then was an identical calcext:target-range-address as for the
copied source range.

(cherry picked from commit ef8e0beba442f58abe3bc77f6f55fc6109025dd4)

Backported.

Change-Id: I038b58f20f71ff1393dccafa3021dac02cd69e4b
Reviewed-on: https://gerrit.libreoffice.org/6768
Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
resolved fdo#53103 actually use the external data filter options

ScDocShell::ConvertFrom() queries the filter options from the SfxItemSet
at SfxMedium, which is fine when loading the data into the table
selector first, but the final load via ScAreaLink created a bare
SfxMedium without options set. Do so.

Additionally it may now even work that ScDocShell sets options at
SfxMedium, which the ScAreaLink code prepared for but previously the
SfxMedium did not have an SfxItemSet.

Change-Id: I45d6a24906dc3ba41654b8c0951dd84939d8af5e
(cherry picked from commit 513eadd422ff6a41cfe9a16f82cf32872d729652)
Reviewed-on: https://gerrit.libreoffice.org/6823
Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
resolved fdo#67536 export internal equivalents as add-in to .xls

For BIFF .xls export the internal functions that are equivalents of
known add-in functions as those add-in functions.

(cherry picked from commit 06a5b1ecc39bb50dadc0bcb7378455500943ece3)

Conflicts:
	sc/source/filter/inc/xlformula.hxx

Change-Id: If37f616a34fdabb3fa971fddad01da3dc1f28ee9
Reviewed-on: https://gerrit.libreoffice.org/6525
Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Tested-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Resolves: fdo#72174 convert_add from "at" or "atm" to "Pa" gives same answer

Change-Id: I76c1a0bd7cc93cf60ffa8da08200969a7315a8c3
Reviewed-on: https://gerrit.libreoffice.org/6870
Reviewed-by: Andras Timar <andras.timar@collabora.com>
Tested-by: Andras Timar <andras.timar@collabora.com>
fix 2D vs 3D coordinatesystem regression, fdo#67300

regression from 088e86b865062dd4cc5ba0c85c6068dea62238db

Change-Id: Ifc8d5a1da328278175bbc97b4f2aad8e6d200751
Reviewed-on: https://gerrit.libreoffice.org/6880
Reviewed-by: Andras Timar <andras.timar@collabora.com>
Tested-by: Andras Timar <andras.timar@collabora.com>
fix validation error for OOXML chart export, related fdo#67300

Change-Id: I7d74439bba3b912fe9b81ebeca865298bc32d71e
Reviewed-on: https://gerrit.libreoffice.org/6879
Reviewed-by: Andras Timar <andras.timar@collabora.com>
Tested-by: Andras Timar <andras.timar@collabora.com>
fdo#72078 make status bar text localizable

2nd try to get it right on libreoffice-4-1

Change-Id: I66ebc292231069cca708eb56ad876f56829e78f5
Reviewed-on: https://gerrit.libreoffice.org/6894
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>
don't use fixed size icon sets, fdo#62652

actually we should switch to svg as soon as it becomes possible

Change-Id: Ifbbe5befab94441f04fadb90b779e0bc8c15eda4
Reviewed-on: https://gerrit.libreoffice.org/6890
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>
flat text DB: fix move by bookmark

To test whether the range [a,b( is *before* e,
compare e to b, not to a.

This makes a difference when a==b, which happens for row 0 (header)
when there is no header.

Conflicts:
	connectivity/source/drivers/flat/ETable.cxx

Change-Id: I629b71936f82a468febe0360909264dd80304437
Reviewed-on: https://gerrit.libreoffice.org/6864
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>
fdo#72148 if expecting table at begin, explicitly set it so

Change-Id: Ic876603e5860b987280b73726fd79a071a9c833c
Reviewed-on: https://gerrit.libreoffice.org/6863
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>