fdo#72645: Allow GETPIVOTDATA to get result from leaf node of result tree.

Change-Id: I0fc1fd069440ed6fee378fc2dfd2ed761afbdeab
fdo#72645: Case-insensitive string comparison in GETPIVOTDATA.

Change-Id: Ibdb2b7ab2bae03875a3462816e860f58d9076457
fdo#72774: Ensure that all the group fields are in cache upon file load.

This resolves the originally reported issue in that bug (in Comment 1).

Change-Id: I6fb85cff1eafb78d784605aa08e7d992a1ac36e0
(cherry picked from commit 256e4ccba8a331f2d30c6b5da9dca70206deadae)
fdo#72774: Generate correct group items for the year group.

This changes bring it back to the same algorithm used in 3.5.

Change-Id: I16855cef1de133a1f886baa823d5b0d2b148e781
(cherry picked from commit c2e88a32314012afb799e321ec1d658f99f71781)