From 7c429ddca63c09a2b656715292968000bfe86a1a Mon Sep 17 00:00:00 2001 From: Tamás Zolnai Date: Sat, 9 Sep 2017 11:06:19 +0200 Subject: tdf#112278: Pivot table: filtering of non-string fields is not exported to XLS MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit It is needed to use the right string representation of field value. During export this representation is available directly, next to the actual value. During import we can use the number format attached to the corresponding pivot field. Change-Id: Ie8f731f6c72d7f55f43c318e52d63dc4e993d9c0 Reviewed-on: https://gerrit.libreoffice.org/42069 Tested-by: Jenkins Reviewed-by: Tamás Zolnai --- sc/inc/dpobject.hxx | 2 ++ 1 file changed, 2 insertions(+) (limited to 'sc/inc') diff --git a/sc/inc/dpobject.hxx b/sc/inc/dpobject.hxx index 1f1546204e6f..39299c79ab26 100644 --- a/sc/inc/dpobject.hxx +++ b/sc/inc/dpobject.hxx @@ -179,6 +179,8 @@ public: tools::Rectangle& rPosRect, css::sheet::DataPilotFieldOrientation& rOrient, long& rDimPos ); bool IsFilterButton( const ScAddress& rPos ); + OUString GetFormattedString( const OUString& rDimName, const double fValue ); + double GetPivotData( const OUString& rDataFieldName, std::vector& rFilters); -- cgit