XlsFormat - fix pivots

XlsFormat - fix custom shape with connectors

ASCOfficeDocxFile2/Mac/ASCOfficeDocxFile2Lib.xcodeproj/project.pbxproj

@@ -49,8 +49,8 @@
 		6967917D1D9E8AEE002CA4BA /* BinReaderWriterDefines.h in Headers */ = {isa = PBXBuildFile; fileRef = 696791791D9E8AEE002CA4BA /* BinReaderWriterDefines.h */; };
 		6967917E1D9E8AEE002CA4BA /* BinWriters.cpp in Sources */ = {isa = PBXBuildFile; fileRef = 6967917A1D9E8AEE002CA4BA /* BinWriters.cpp */; };
 		6967917F1D9E8AEE002CA4BA /* BinWriters.h in Headers */ = {isa = PBXBuildFile; fileRef = 6967917B1D9E8AEE002CA4BA /* BinWriters.h */; };
+		69BBDF251F0B8AAC00EB1BF7 /* FileDownloader_mac.mm in Sources */ = {isa = PBXBuildFile; fileRef = 69BBDF241F0B8AAC00EB1BF7 /* FileDownloader_mac.mm */; };
 		69F181AF1C77274E00B2952B /* FileDownloader.h in Headers */ = {isa = PBXBuildFile; fileRef = 69F181AD1C77274E00B2952B /* FileDownloader.h */; };
-		69F181B51C77276D00B2952B /* FileDownloader_curl.cpp in Sources */ = {isa = PBXBuildFile; fileRef = 69F181B31C77276D00B2952B /* FileDownloader_curl.cpp */; };
 /* End PBXBuildFile section */
 
 /* Begin PBXFileReference section */
@@ -97,8 +97,8 @@
 		696791791D9E8AEE002CA4BA /* BinReaderWriterDefines.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; name = BinReaderWriterDefines.h; path = ../../BinWriter/BinReaderWriterDefines.h; sourceTree = "<group>"; };
 		6967917A1D9E8AEE002CA4BA /* BinWriters.cpp */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.cpp.cpp; name = BinWriters.cpp; path = ../../BinWriter/BinWriters.cpp; sourceTree = "<group>"; };
 		6967917B1D9E8AEE002CA4BA /* BinWriters.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; name = BinWriters.h; path = ../../BinWriter/BinWriters.h; sourceTree = "<group>"; };
+		69BBDF241F0B8AAC00EB1BF7 /* FileDownloader_mac.mm */ = {isa = PBXFileReference; explicitFileType = sourcecode.cpp.objcpp.preprocessed; fileEncoding = 4; name = FileDownloader_mac.mm; path = ../../../Common/FileDownloader/FileDownloader_mac.mm; sourceTree = "<group>"; };
 		69F181AD1C77274E00B2952B /* FileDownloader.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; name = FileDownloader.h; path = ../../../Common/FileDownloader/FileDownloader.h; sourceTree = "<group>"; };
-		69F181B31C77276D00B2952B /* FileDownloader_curl.cpp */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.cpp.cpp; name = FileDownloader_curl.cpp; path = ../../../Common/FileDownloader/FileDownloader_curl.cpp; sourceTree = "<group>"; };
 /* End PBXFileReference section */
 
 /* Begin PBXFrameworksBuildPhase section */
@@ -230,7 +230,7 @@
 			isa = PBXGroup;
 			children = (
 				69F181AD1C77274E00B2952B /* FileDownloader.h */,
-				69F181B31C77276D00B2952B /* FileDownloader_curl.cpp */,
+				69BBDF241F0B8AAC00EB1BF7 /* FileDownloader_mac.mm */,
 			);
 			name = Common;
 			sourceTree = "<group>";
@@ -339,7 +339,6 @@
 			isa = PBXSourcesBuildPhase;
 			buildActionMask = 2147483647;
 			files = (
-				69F181B51C77276D00B2952B /* FileDownloader_curl.cpp in Sources */,
 				17C1FE961ACC42C4006B99B3 /* Common.cpp in Sources */,
 				17C1FE971ACC42C4006B99B3 /* ChartFromToBinary.cpp in Sources */,
 				17C1FE981ACC42C4006B99B3 /* CSVReader.cpp in Sources */,
@@ -348,6 +347,7 @@
 				17C1FE9B1ACC42C4006B99B3 /* CSVWriter.cpp in Sources */,
 				69414A301CB51666003E771B /* ChartWriter.cpp in Sources */,
 				6967917E1D9E8AEE002CA4BA /* BinWriters.cpp in Sources */,
+				69BBDF251F0B8AAC00EB1BF7 /* FileDownloader_mac.mm in Sources */,
 				17C1FE9C1ACC42C4006B99B3 /* XlsxSerializer.cpp in Sources */,
 				690FE0851E9BBD68004B26D0 /* Readers.cpp in Sources */,
 				17C1FE9D1ACC42C4006B99B3 /* FontProcessor.cpp in Sources */,
@@ -379,6 +379,7 @@
 					unix,
 					_IOS,
 					DONT_WRITE_EMBEDDED_FONTS,
+					_XCODE,
 				);
 				GCC_SYMBOLS_PRIVATE_EXTERN = NO;
 				HEADER_SEARCH_PATHS = (
@@ -416,6 +417,7 @@
 					unix,
 					_IOS,
 					DONT_WRITE_EMBEDDED_FONTS,
+					_XCODE,
 				);
 				GCC_SYMBOLS_PRIVATE_EXTERN = NO;
 				HEADER_SEARCH_PATHS = (

ASCOfficeOdfFile/src/docx/xlsx_output_xml.cpp

@@ -189,14 +189,14 @@ void xlsx_xml_worksheet::write_to(std::wostream & strm)
                     CP_XML_STREAM() << impl_->hyperlinks_.str();
                 }
             }
-
-			CP_XML_STREAM() << impl_->drawing_.str();
 			
 			if (!impl_->page_props_.str().empty())
             {
 				CP_XML_STREAM() << impl_->page_props_.str();
 			}//props выше legacyDrawing !!
 			
+			CP_XML_STREAM() << impl_->drawing_.str();
+			
 			if (impl_->commentsId_.length()>0)
 			{
 				CP_XML_NODE(L"legacyDrawing")

ASCOfficePPTFile/PPTFormatLib/Reader/PPTDocumentInfoOneUser.cpp

@@ -601,12 +601,14 @@ void CPPTUserInfo::LoadNotes(DWORD dwNoteID, CSlide* pNotes)
 	
 	CSlideInfo* pNotesWrapper = &m_arNotesWrapper.back();
 
-	int indexUser						= pRecordSlide->m_IndexUser;
+	int indexUser = pRecordSlide->m_IndexUser;
+
+	if (m_pDocumentInfo->m_arUsers[indexUser]->m_arOffsetPictures.empty())
+		pNotesWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[0]->m_arOffsetPictures;
+	else
+		pNotesWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[indexUser]->m_arOffsetPictures;
 
-	pNotesWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[indexUser]->m_arOffsetPictures;
 	pNotesWrapper->m_mapFilePictures	= &m_pDocumentInfo->m_mapStoreImageFile;
-
-	//грузим placeholder
 	pNotesWrapper->m_arTextPlaceHolders = pRecordSlide->m_oPersist.m_arTextAttrs;
 
 	std::vector<CRecordNotesAtom*> oArrayNotesAtoms;
@@ -627,6 +629,9 @@ void CPPTUserInfo::LoadNotes(DWORD dwNoteID, CSlide* pNotes)
 		//????? у заметок нет слайда !!!
 	}
 //-----------------------------------------------------
+	size_t index = pPairSlide->second->m_Index;
+	if (index >= m_arSlides.size())
+		return;
 	CSlide* pSlide		= m_arSlides[pPairSlide->second->m_Index];
 
 	pNotes->m_lSlideID	= pPairSlide->second->m_Index;
@@ -796,12 +801,14 @@ void CPPTUserInfo::LoadSlide(DWORD dwSlideID, CSlide* pSlide)
 	
 	CSlideInfo* pSlideWrapper = &m_arSlideWrapper.back();
 
-	int indexUser						= pRecordSlide->m_IndexUser;
+	int indexUser = pRecordSlide->m_IndexUser;
 
-	pSlideWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[indexUser]->m_arOffsetPictures;
+	if (m_pDocumentInfo->m_arUsers[indexUser]->m_arOffsetPictures.empty())
+		pSlideWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[0]->m_arOffsetPictures;
+	else
+		pSlideWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[indexUser]->m_arOffsetPictures;
+	
 	pSlideWrapper->m_mapFilePictures	= &m_pDocumentInfo->m_mapStoreImageFile;
-
-	// вот, грузим placeholder
 	pSlideWrapper->m_arTextPlaceHolders = pRecordSlide->m_oPersist.m_arTextAttrs;
 
 	// записываем шрифты
@@ -1402,7 +1409,11 @@ void CPPTUserInfo::LoadMainMaster(DWORD dwMasterID, const LONG& lOriginWidth, co
 		indexUser = pPairMaster1->second->m_IndexUser;
 		pMasterWrapper->m_arTextPlaceHolders = pPairMaster1->second->m_oPersist.m_arTextAttrs;
 	}
-	pMasterWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[indexUser]->m_arOffsetPictures;
+	if (m_pDocumentInfo->m_arUsers[indexUser]->m_arOffsetPictures.empty() == false)
+		pMasterWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[indexUser]->m_arOffsetPictures;
+	else
+		pMasterWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[0]->m_arOffsetPictures;
+
 	pMasterWrapper->m_mapFilePictures	= &m_pDocumentInfo->m_mapStoreImageFile;
 
 	// читаем настройки текстовых стилей -----------------------------------------------
@@ -1784,11 +1795,13 @@ void CPPTUserInfo::LoadNoMainMaster(DWORD dwMasterID, const LONG& lOriginWidth,
 
 	CSlideInfo* pMasterWrapper	= &m_arMasterWrapper[m_arMasterWrapper.size() - 1];
 
-	// вот, грузим placeholder
-	pMasterWrapper->m_arTextPlaceHolders	= pCurMaster->m_oPersist.m_arTextAttrs;	
-	
-	pMasterWrapper->m_parEmptyPictures		= &m_pDocumentInfo->m_arUsers[pCurMaster->m_IndexUser]->m_arOffsetPictures;
+	pMasterWrapper->m_arTextPlaceHolders	= pCurMaster->m_oPersist.m_arTextAttrs;		
 	pMasterWrapper->m_mapFilePictures		= &m_pDocumentInfo->m_mapStoreImageFile;
+	
+	if (m_pDocumentInfo->m_arUsers[pCurMaster->m_IndexUser]->m_arOffsetPictures.empty() == false)
+		pMasterWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[pCurMaster->m_IndexUser]->m_arOffsetPictures;
+	else
+		pMasterWrapper->m_parEmptyPictures	= &m_pDocumentInfo->m_arUsers[0]->m_arOffsetPictures;
 
 	std::map<DWORD, LONG>::iterator pPairTheme = m_mapMasterToTheme.find(dwID);
 	

ASCOfficePPTFile/PPTFormatLib/Reader/PPTFileReader.cpp

@@ -232,10 +232,12 @@ void CPPTFileReader::ReadPictures()
 
 	while (true)
 	{
-		if (pStream->isEOF())
-			break;
+		//if (pStream->isEOF()) случаются неверно записанные стримы 
+		//	break;
 
 		int pos = pStream->getStreamPointer();	
+		if (pos >= pStream->getStreamSize())
+			break;
 
 		SRecordHeader oHeader;
 		if (pDecryptor)
@@ -256,6 +258,9 @@ void CPPTFileReader::ReadPictures()
 		else
 			oHeader.ReadFromStream(pStream->stream_);
 
+		if (oHeader.RecType == 0 && oHeader.RecLen == 0 )
+			break;// окончание стрима забито нулями (выравнивание)
+
 		CRecordOfficeArtBlip art_blip;
 		art_blip.m_strTmpDirectory	= m_strTmpDirectory;
 		art_blip.m_oDocumentInfo	= &m_oDocumentInfo;

ASCOfficePPTXFile/PPTXFormat/Logic/GraphicFrame.cpp

@@ -250,12 +250,26 @@ namespace PPTX
 					}
 					else if (L"oleObj" == strName)
 					{
-						olePic = oNode.ReadNode(L"p:pic");
+						olePic = oNode.ReadNode(L"p:pic"); //нормальный вариант объекта
 						if (olePic.IsInit())
 						{
 							olePic->fromXMLOle(oNode);
 							result = true;
 						}
+						else
+						{
+							olePic.Init();  //старый вариант описания объекта через spid в VmlDrawing
+							olePic->spPr.xfrm;
+
+							Logic::PrstGeom* geom = new Logic::PrstGeom();
+							geom->prst = L"rect";
+							olePic->spPr.Geometry.m_geometry.reset(geom);							
+			
+							olePic->fromXMLOle(oNode);
+							result = true;
+						}
+						if (olePic->spPr.xfrm.IsInit() == false)
+							olePic->spPr.xfrm = xfrm;
 					}
 					else if (L"AlternateContent" == strName)
 					{

ASCOfficePPTXFile/PPTXFormat/Logic/Pic.cpp

@@ -619,6 +619,45 @@ namespace PPTX
 			if(oleObject.IsInit())
 			{
 				pWriter->StartRecord(SPTREE_TYPE_OLE);
+				
+				if (oleObject->m_sShapeId.IsInit() && (!blipFill.blip->embed.IsInit() && blipFill.blip->oleFilepathImage.empty())  &&
+						parentFileIs<PPTX::Slide>() && parentFileAs<PPTX::Slide>().Vml.IsInit())
+				{
+					OOX::CVmlDrawing *pVml = parentFileAs<PPTX::Slide>().Vml.operator->();
+					
+					std::map<std::wstring, OOX::CVmlDrawing::_vml_shape>::iterator pPair = pVml->m_mapShapes.find(*oleObject->m_sShapeId);
+					if (pVml->m_mapShapes.end() != pPair)
+					{
+						pPair->second.bUsed = true;
+						OOX::Vml::CShape* pShape = dynamic_cast<OOX::Vml::CShape*>(pPair->second.pElement);
+						for(size_t j = 0; (pShape) && (j < pShape->m_arrItems.size()); ++j)
+						{
+							OOX::WritingElement* pChildElemShape = pShape->m_arrItems[j];
+							if(OOX::et_v_imagedata == pChildElemShape->getType())
+							{
+								OOX::Vml::CImageData* pImageData = static_cast<OOX::Vml::CImageData*>(pChildElemShape);									
+													
+								std::wstring sIdImageFileCache;
+
+								if (pImageData->m_oRelId.IsInit())		sIdImageFileCache = pImageData->m_oRelId->GetValue();
+								else if (pImageData->m_rId.IsInit())	sIdImageFileCache = pImageData->m_rId->GetValue();
+																	
+								if (!sIdImageFileCache.empty())
+								{
+									//ищем физический файл ( rId относительно vml_drawing)									
+									smart_ptr<OOX::File> pFile = pVml->Find(sIdImageFileCache);
+									
+									if (pFile.IsInit() && (	OOX::FileTypes::Image == pFile->type()))
+									{
+										OOX::Image*	pImageFileCache = static_cast<OOX::Image*>(pFile.operator->());
+										
+										blipFill.blip->oleFilepathImage = pImageFileCache->filename().GetPath();
+									}
+								}
+							}
+						}
+					}
+				}
 			}
 			else if (nvPicPr.nvPr.media.is_init())
 			{
@@ -630,10 +669,17 @@ namespace PPTX
 					blipFill.blip->mediaFilepath = mediaFile->filename().GetPath();
 				}
 
-				if (nvPicPr.nvPr.media.as<MediaFile>().name == L"audioFile")
+				if (nvPicPr.nvPr.media.is<MediaFile>())
+				{
+					if (nvPicPr.nvPr.media.as<MediaFile>().name == L"audioFile")
+						pWriter->StartRecord(SPTREE_TYPE_AUDIO);
+					else if (nvPicPr.nvPr.media.as<MediaFile>().name == L"videoFile")
+						pWriter->StartRecord(SPTREE_TYPE_VIDEO);
+				}
+				else if (nvPicPr.nvPr.media.is<WavAudioFile>() || nvPicPr.nvPr.media.is<AudioCD>())
+				{
 					pWriter->StartRecord(SPTREE_TYPE_AUDIO);
-				else if (nvPicPr.nvPr.media.as<MediaFile>().name == L"videoFile")
-					pWriter->StartRecord(SPTREE_TYPE_VIDEO);
+				}
 				else
 					pWriter->StartRecord(SPTREE_TYPE_PIC);
 			}
@@ -1338,6 +1384,7 @@ namespace PPTX
 					blipFill.blip.Init();
 				blipFill.blip->oleRid = oleObject->m_oId->get();
 			}
+			node.ReadAttributeBase(L"spid",	oleObject->m_sShapeId);
 		}
 	} // namespace Logic
 } // namespace PPTX

ASCOfficePPTXFile/PPTXFormat/Logic/Pic.h

@@ -259,7 +259,7 @@ namespace PPTX
 			void toXmlWriterVML(NSBinPptxRW::CXmlWriter* pWriter, smart_ptr<PPTX::Theme>& oTheme, smart_ptr<PPTX::Logic::ClrMap>& oClrMap, bool in_group = false);
 //----------------------------------------------------------------------
 			NvPicPr					nvPicPr;
-			BlipFill				blipFill;
+			mutable BlipFill		blipFill;
 			SpPr					spPr;
 			nullable<ShapeStyle>	style;
 		//internal

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXDBB.cpp

@@ -52,24 +52,13 @@ BaseObjectPtr SXDBB::clone()
 
 void SXDBB::readFields(CFRecord& record)
 {
-	unsigned int sz = record.getDataSize() - record.getRdPtr();
+	size = record.getDataSize() - record.getRdPtr();
 
-	//std::list<CFRecordPtr>& recs = continue_records[rt_Continue];
+	blob = boost::shared_array<unsigned char>(new unsigned char[size]);
 
-	//while (record.getRdPtr() + lcb > record.getDataSize() && !recs.empty())
-	//{
-	//	record.appendRawData(recs.front());
-	//	recs.pop_front();
-	//}
+	memcpy(blob.get(), record.getCurData<unsigned char>(), size);
 
-	if (record.checkFitReadSafe(sz))
-	{
-		blob = boost::shared_array<char>(new char[sz]);
-
-		memcpy(blob.get(), record.getCurData<char>(), sz);
-
-		record.skipNunBytes(sz);
-	}
+	record.skipNunBytes(size);
 }
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXDBB.h

@@ -50,7 +50,8 @@ public:
 
 	static const ElementType type = typeSXDBB;
 
-	boost::shared_array<char> blob;
+	boost::shared_array<unsigned char>	blob;
+	unsigned int						size;
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXDI.cpp

@@ -39,12 +39,10 @@ SXDI::SXDI()
 {
 }
 
-
 SXDI::~SXDI()
 {
 }
 
-
 BaseObjectPtr SXDI::clone()
 {
 	return BaseObjectPtr(new SXDI(*this));
@@ -61,5 +59,22 @@ void SXDI::readFields(CFRecord& record)
 	}
 }
 
+int SXDI::serialize(std::wostream & strm)
+{
+	CP_XML_WRITER(strm)
+	{
+		CP_XML_NODE(L"dataField")
+		{
+			if (stName.value().empty() == false)
+				CP_XML_ATTR(L"name", stName.value()); 
+			
+			CP_XML_ATTR(L"fld",			isxvdData); 
+			CP_XML_ATTR(L"baseField",	df); 
+			CP_XML_ATTR(L"baseItem",	isxvi); 
+			CP_XML_ATTR(L"numFmtId",	ifmt); 
+		}
+	}
+	return 0;
+}
 } // namespace XLS
 

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXDI.h

@@ -49,6 +49,8 @@ public:
 	
 	void readFields(CFRecord& record);
 
+	int serialize(std::wostream & strm);
+
 	static const ElementType type = typeSXDI;
 
 	short					isxvdData;

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXDtr.cpp

@@ -53,6 +53,15 @@ void SXDtr::readFields(CFRecord& record)
 {
 	record >> yr >> mon >> dom >> hr >> min >> sec;
 }
+	
+std::wstring SXDtr::get_string_date()
+{
+	std::wstringstream s;
+	s << yr << L"-" << (mon < 10 ? L"0" : L"") << mon << L"-" <<  (dom < 10 ? L"0" : L"") << dom << L"T"
+		 << (hr < 10 ? L"0" : L"") << hr << L":" << (min < 10 ? L"0" : L"") << min << L":" << (sec < 10 ? L"0" : L"") << sec;
+
+	return s.str();
+}
 
 int SXDtr::serialize(std::wostream & strm)
 {
@@ -60,10 +69,8 @@ int SXDtr::serialize(std::wostream & strm)
 	{
 		CP_XML_NODE(L"d")
 		{ 
-			std::wstringstream s;
-			s << yr << L"-" << mon << L"-" << dom << L"T" << hr << L":" << min << L":" << sec;
 
-			CP_XML_ATTR(L"v", s.str());
+			CP_XML_ATTR(L"v", get_string_date());
 		}
 	}
 	

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXDtr.h

@@ -59,6 +59,8 @@ public:
 	unsigned char	min;
 	unsigned char	sec;
 
+	std::wstring get_string_date();
+
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXFDB.cpp

@@ -69,6 +69,12 @@ void SXFDB::readFields(CFRecord& record)
 	fServerBased		= GETBIT(flags, 13);
 	fCantGetUniqueItems	= GETBIT(flags, 14);
 	fCalculatedField	= GETBIT(flags, 15);
+
+	if (fAllAtoms)
+	{
+		GlobalWorkbookInfoPtr global_info = record.getGlobalWorkbookInfo();
+		global_info->arCacheFieldShortSize.push_back(fShortIitms);
+	}
 }
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXFormula.cpp

@@ -51,6 +51,9 @@ BaseObjectPtr SXFormula::clone()
 
 void SXFormula::readFields(CFRecord& record)
 {
+	unsigned short reserved;
+
+	record >> reserved >> ifdb;
 }
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXFormula.h

@@ -50,7 +50,7 @@ public:
 
 	static const ElementType type = typeSXFormula;
 
-
+	short ifdb;
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXLI.cpp

@@ -50,17 +50,15 @@ BaseObjectPtr SXLI::clone()
 }
 
 void SXLI::readFields(CFRecord& record)
-{// 0 or 2 records SXLIItem
-	int size_item = (record.getDataSize() - record.getRdPtr()) / 2; 
-
-	if (size_item < 8)
+{
+	while(true)
 	{
-		//??
-		return;
-	}
+		int size_item = record.getDataSize() - record.getRdPtr(); 
 
-	for (int k = 0; k < 2; k++)
-	{
+		if (size_item < 8)
+		{
+			break;
+		}
 		SXLIItem item;
 		
 		unsigned short flags;
@@ -74,13 +72,21 @@ void SXLI::readFields(CFRecord& record)
 		item.fGrand				= GETBIT(flags, 11);
 		item.fMultiDataOnAxis	= GETBIT(flags, 12);
 
-		int count = (size_item - 8) / 2;
+		if (item.fGrand)
+			item.isxviMac = 1;
 
-		for (int i = 0; i < count; i++)
+		if (item.cSic > item.isxviMac)
+			item.cSic = item.isxviMac;
+
+		if (item.fSbt && item.itmType < 0x000D)
+			item.isxviMac++;
+
+		for (short i = 0; i < item.isxviMac; i++)
 		{
 			short val; record >> val;
 			item.rgisxvi.push_back(val);
 		}
+
 		m_arItems.push_back(item);
 	}
 }

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXVI.cpp

@@ -57,8 +57,8 @@ void SXVI::readFields(CFRecord& record)
 
 	fHidden		= GETBIT(flags, 0);
 	fHideDetail	= GETBIT(flags, 1);
-	fFormula	= GETBIT(flags, 4);
-	fMissing	= GETBIT(flags, 5);
+	fFormula	= GETBIT(flags, 3);
+	fMissing	= GETBIT(flags, 4);
 	
 	if (cchName > 0 && cchName < 0xFFFF)
 	{
@@ -67,6 +67,43 @@ void SXVI::readFields(CFRecord& record)
 
 	}
 }
+int SXVI::serialize(std::wostream & strm)
+{
+	CP_XML_WRITER(strm)
+	{
+		CP_XML_NODE(L"item")
+		{
+			if (fMissing)
+				CP_XML_ATTR(L"m", 1); 
+			if (fHidden)
+				CP_XML_ATTR(L"h", 1); 
+			if (fHideDetail)
+				CP_XML_ATTR(L"h", 1); 
+			if (fFormula)
+				CP_XML_ATTR(L"f", 1);
 
+			if (itmType == 0)
+			{
+				CP_XML_ATTR(L"x", iCache); 
+			}
+			switch(itmType)
+			{
+			case 0x0001: CP_XML_ATTR(L"t", L"default"); break;
+			case 0x0002: CP_XML_ATTR(L"t", L"sum");		break;
+			case 0x0003: CP_XML_ATTR(L"t", L"countA");	break;
+			case 0x0004: CP_XML_ATTR(L"t", L"avg");		break;
+			case 0x0005: CP_XML_ATTR(L"t", L"max");		break;
+			case 0x0006: CP_XML_ATTR(L"t", L"min");		break;
+			case 0x0007: CP_XML_ATTR(L"t", L"product"); break;
+			case 0x0008: CP_XML_ATTR(L"t", L"count");	break;
+			case 0x0009: CP_XML_ATTR(L"t", L"stdDev");	break;
+			case 0x000a: CP_XML_ATTR(L"t", L"stdDevP"); break;
+			case 0x000b: CP_XML_ATTR(L"t", L"var");		break;
+			case 0x000c: CP_XML_ATTR(L"t", L"varP");	break;
+			}
+		}
+	}
+	return 0;
+}
 } // namespace XLS
 

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SXVI.h

@@ -48,6 +48,8 @@ public:
 	
 	void readFields(CFRecord& record);
 
+	int serialize(std::wostream & strm);
+
 	static const ElementType type = typeSXVI;
 
 	unsigned short			itmType; //enum

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SxDXF.h

@@ -54,7 +54,6 @@ public:
 
 	DXFN		dxfn;
 	XFExtNoFRT	xfext;
-
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/SxIvd.h

@@ -51,7 +51,6 @@ public:
 	static const ElementType type = typeSxIvd;
 
 	std::vector<short>	rgSxivd;
-
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_records/Sxvd.cpp

@@ -45,7 +45,6 @@ Sxvd::~Sxvd()
 {
 }
 
-
 BaseObjectPtr Sxvd::clone()
 {
 	return BaseObjectPtr(new Sxvd(*this));

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_structures/ODRAW/OfficeArtFOPTE.h

@@ -750,7 +750,7 @@ class pConnectionSitesDir : public OfficeArtFOPTE
 	
 	virtual void ReadComplexData(XLS::CFRecord& record);
 
-	IMsoArray<ODRAW::FixedPoint> complex;
+	IMsoArray<OSHARED::FixedPoint> complex;
 };
 
 class pInscribe : public OfficeArtFOPTE 

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_structures/Xnum.h

@@ -57,7 +57,7 @@ public:
 			unsigned char Byte4;
 			unsigned short type;
 			unsigned short fExprO;
-		};
+		}bytes;
 		double value;
 	} data;
 };

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/DBB.cpp

@@ -38,11 +38,15 @@
 namespace XLS
 {
 
-
 DBB::DBB()
 {
-}
+	bString		= false;
+	bDate		= false;
+	bNumber		= false;
+	bEmpty		= false;
 
+	fShortIitms = false;
+}
 
 DBB::~DBB()
 {
@@ -53,7 +57,6 @@ BaseObjectPtr DBB::clone()
 	return BaseObjectPtr(new DBB(*this));
 }
 
-
 // DBB = [SXDBB] *SXOPER
 const bool DBB::loadContent(BinProcessor& proc)
 {
@@ -66,6 +69,12 @@ const bool DBB::loadContent(BinProcessor& proc)
 	while(count--)
 	{
 		m_arSXOPER.push_back(elements_.front());	elements_.pop_front();
+		SXOPER* operatr = dynamic_cast<SXOPER*>(m_arSXOPER.back().get());
+
+		bString	|= operatr->bString;
+		bDate	|= operatr->bDate;
+		bNumber	|= operatr->bNumber;
+		bEmpty	|= operatr->bEmpty;
 	}
 
 	if (!m_SXDBB && m_arSXOPER.empty())
@@ -73,6 +82,50 @@ const bool DBB::loadContent(BinProcessor& proc)
 
 	return true;
 }
+int DBB::serialize(std::wostream & strm)
+{
+	SXDBB* dbb = dynamic_cast<SXDBB*>(m_SXDBB.get());
 
+	if (!dbb && m_arSXOPER.empty()) return 0;
+
+	CP_XML_WRITER(strm)
+	{
+		CP_XML_NODE(L"r")
+		{ 		
+			if (m_arSXOPER.empty() == false)
+			{
+				for (size_t i = 0; i < m_arSXOPER.size(); i++)
+				{
+					m_arSXOPER[i]->serialize(CP_XML_STREAM());
+				}
+			}
+			else
+			{
+				if (fShortIitms == false)
+				{
+					for (size_t i = 0; i < dbb->size; i++)
+					{
+						CP_XML_NODE(L"x")
+						{		
+							CP_XML_ATTR(L"v", dbb->blob[i]);
+						}
+					}
+				}
+				else
+				{
+					unsigned short * values = (unsigned short *)dbb->blob.get();
+					for (size_t i = 0; i < dbb->size / 2; i++)
+					{
+						CP_XML_NODE(L"x")
+						{		
+							CP_XML_ATTR(L"v", values[i]);
+						}
+					}
+				}
+			}
+		}
+	}
+	return 0;
+}
 } // namespace XLS
 

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/DBB.h

@@ -47,10 +47,20 @@ public:
 
 	virtual const bool loadContent(BinProcessor& proc);
 
+	int serialize(std::wostream & strm);
+
 	static const ElementType	type = typeDBB;
 
 	BaseObjectPtr				m_SXDBB;	
 	std::vector<BaseObjectPtr>	m_arSXOPER;	
+
+//---------------------------------------------------
+	bool	fShortIitms;
+
+	bool	bString;
+	bool	bDate;
+	bool	bNumber;
+	bool	bEmpty;
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/DREF.cpp

@@ -92,9 +92,51 @@ int DREF::serialize(std::wostream & strm)
 			}
 			else if(bin)
 			{
+				switch(bin->nBuiltin)
+				{
+
+					case 0x0004:/*Database*/
+					case 0x000d:/*_FilterDatabase*/
+					{
+						CP_XML_ATTR(L"type", L"external");
+						//connectionId in connections(root)
+					}break;
+					case 0x0000:/*Consolidate_Area*/
+					//{
+					//	CP_XML_ATTR(L"type", L"consolidation");
+					//	CP_XML_NODE(L"consolidation")
+					//	{
+					//		CP_XML_ATTR(L"name", bin->stFile.value());
+					//	}
+					//}break;			
+					case 0x0001:/*Auto_Open*/
+					case 0x0002:/*Auto_Close*/
+					case 0x0003:/*Extract*/
+					case 0x0005:/*Criteria*/
+					case 0x0006:/*Print_Area*/
+					case 0x0007:/*Print_Titles*/
+					case 0x0008:/*Recorder*/
+					case 0x0009:/*Data_Form*/
+					case 0x000a:/*Auto_Activate*/
+					case 0x000b:/*Auto_Deactivate*/
+					case 0x000c:/*Sheet_Title*/
+					{
+						CP_XML_ATTR(L"type", L"scenario");
+						CP_XML_NODE(L"worksheetSource")
+						{
+							CP_XML_ATTR(L"name", bin->stFile.value());
+						}
+					}break;
+				}
 			}
 			else if(ref)
 			{
+				CP_XML_ATTR(L"type", L"worksheet");
+				CP_XML_NODE(L"worksheetSource")
+				{
+					CP_XML_ATTR(L"ref", ref->ref.toString());
+					CP_XML_ATTR(L"sheet", ref->stFile);
+				}
 			}
 		}
 	}

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/FDB.cpp

@@ -74,14 +74,17 @@ private:
 
 FDB::FDB()
 {
+	bString		= false;
+	bDate		= false;
+	bNumber		= false;
+	bEmpty		= false;
+	bInteger	= false;
 }
 
-
 FDB::~FDB()
 {
 }
 
-
 BaseObjectPtr FDB::clone()
 {
 	return BaseObjectPtr(new FDB(*this));
@@ -123,10 +126,15 @@ const bool FDB::loadContent(BinProcessor& proc)
 
 			while(count > 0)
 			{
-				SXOPER	* oper	= dynamic_cast<SXOPER*>	(elements_.front().get());
-				if (oper)
+				SXOPER	* operatr	= dynamic_cast<SXOPER*>	(elements_.front().get());
+				if (operatr)
 				{
 					m_arGRPSXOPER.push_back(elements_.front());
+
+					//bString	|= operatr->bString;
+					//bDate	|= operatr->bDate;
+					//bNumber	|= operatr->bNumber;
+					//bEmpty	|= operatr->bEmpty;
 				}
 				else
 				{
@@ -150,6 +158,14 @@ const bool FDB::loadContent(BinProcessor& proc)
 	while(count--)
 	{
 		m_arSRCSXOPER.push_back(elements_.front());	elements_.pop_front();
+		
+		SXOPER* operatr	= dynamic_cast<SXOPER*>	(m_arSRCSXOPER.back().get());
+		
+		bString	|= operatr->bString;
+		bDate	|= operatr->bDate;
+		bNumber	|= operatr->bNumber;
+		bEmpty	|= operatr->bEmpty;
+		bInteger|= operatr->bInteger;
 	}	
 
 	return true;
@@ -167,7 +183,15 @@ int FDB::serialize(std::wostream & strm)
 		CP_XML_NODE(L"cacheField")
 		{ 
 			CP_XML_ATTR(L"name", fdb->stFieldName.value());
-			CP_XML_ATTR(L"numFmtId", fdb_type->wTypeSql);	
+			
+			if (fdb_type->wTypeSql > 0)
+			{
+				CP_XML_ATTR(L"numFmtId", fdb_type->wTypeSql);	
+			}
+			if (m_arSRCSXOPER.empty() && m_arGRPSXOPER.empty() == false)
+			{
+				CP_XML_ATTR(L"databaseField", 0);	
+			}
 
 			switch(fdb_type->wTypeSql)//format code
 			{
@@ -189,32 +213,66 @@ int FDB::serialize(std::wostream & strm)
 			{
 			//{formula
 			}
-			//caption, databaseFields,  ..
 
 			if (m_arSRCSXOPER.empty() == false)
 			{
 				CP_XML_NODE(L"sharedItems")
 				{
-					//CP_XML_ATTR(L"containsSemiMixedTypes", 0);
-					CP_XML_ATTR(L"containsNonDate", fdb->fNonDates);	
-					CP_XML_ATTR(L"containsDate",	fdb->fDateInField);
-					CP_XML_ATTR(L"containsNumber",	fdb->fNumField);
-					CP_XML_ATTR(L"containsBlank",	fdb->fTextEtcField);
-					//CP_XML_ATTR(L"containsString", 0);
+					//использовать поля присутствия из xls низя - они частенько записаны неверно!!
+					//if (!fdb->fNonDates)	CP_XML_ATTR(L"containsNonDate", fdb->fNonDates);	
+					//if (fdb->fDateInField)	CP_XML_ATTR(L"containsDate",	fdb->fDateInField);
+					//if (fdb->fNumField)		CP_XML_ATTR(L"containsNumber",	fdb->fNumField);
+					////CP_XML_ATTR(L"containsBlank",	fdb->fTextEtcField);
+
+					//if (m_arSRCSXOPER.empty())
+					//{
+					//	if (!fdb->fTextEtcField)
+					//	{
+					//		CP_XML_ATTR(L"containsString", 0);
+					//	}
+					//	else if (fdb->fNumField || fdb->fDateInField)
+					//	{
+					//		CP_XML_ATTR(L"containsBlank",	1);
+					//		CP_XML_ATTR(L"containsString",	0);
+					//	}
+					//}
+					if	(bInteger)
+					{
+						if (bNumber)	bInteger = false;
+						else			bNumber = true;
+					}
+					if ((bDate & bNumber) || (bNumber & bString))
+					{
+						CP_XML_ATTR(L"containsSemiMixedTypes", 1);
+					}
+					else if ( bDate & bString) 
+					{
+						CP_XML_ATTR(L"containsMixedTypes", 1);
+					}
+					else if (!bEmpty && !bString)
+					{
+						CP_XML_ATTR(L"containsSemiMixedTypes", 0);
+					}
+					if (bNumber)	CP_XML_ATTR(L"containsNumber",	1);
+					if (bDate)		CP_XML_ATTR(L"containsDate",	1);
+					if (!bString)	CP_XML_ATTR(L"containsString",	0);
+					if (bEmpty)		CP_XML_ATTR(L"containsBlank",	1);
+					if (bInteger)	CP_XML_ATTR(L"containsInteger",	1);
+
 					if (fdb->fnumMinMaxValid)
 					{
-						if (fdb->fDateInField)
-						{
-							CP_XML_ATTR(L"minDate", 0);				 // "2007-11-18T00:00:00" 
-							CP_XML_ATTR(L"maxDate", 0);				 // "2007-12-25T00:00:00" 
-						}
-						else if (fdb->fNumField)
-						{
-							CP_XML_ATTR(L"minValue", 0);
-							CP_XML_ATTR(L"maxValue", 0);
-						}
+						//if (fdb->fDateInField)
+						//{
+						//	CP_XML_ATTR(L"minDate", 0);				 // "2007-11-18T00:00:00" 
+						//	CP_XML_ATTR(L"maxDate", 0);				 // "2007-12-25T00:00:00" 
+						//}
+						//else if (fdb->fNumField)
+						//{
+						//	CP_XML_ATTR(L"minValue", 0);
+						//	CP_XML_ATTR(L"maxValue", 0);
+						//}
 					}
-					CP_XML_ATTR(L"count", fdb->catm);	
+					CP_XML_ATTR(L"count", m_arSRCSXOPER.size());	
 
 					for (size_t i = 0; i < m_arSRCSXOPER.size(); i++)
 					{

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/FDB.h

@@ -59,6 +59,13 @@ public:
 	std::vector<BaseObjectPtr>	m_arGRPSXOPER;
 	BaseObjectPtr				m_SXRANGE;
 	std::vector<BaseObjectPtr>	m_arSxIsxoper;
+
+	bool	bString;
+	bool	bDate;
+	bool	bNumber;
+	bool	bEmpty;
+	bool	bInteger;
+
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTCACHE.cpp

@@ -60,6 +60,8 @@ BaseObjectPtr PIVOTCACHE::clone()
 // PIVOTCACHE = SXDB SXDBEx *SXFORMULA *FDB *DBB EOF
 const bool PIVOTCACHE::loadContent(BinProcessor& proc)
 {
+	GlobalWorkbookInfoPtr global_info = proc.getGlobalWorkbookInfo();
+	
 	if(!proc.mandatory<SXDB>())
 	{
 		return false;
@@ -90,6 +92,17 @@ const bool PIVOTCACHE::loadContent(BinProcessor& proc)
 	while(count--)
 	{
 		m_arDBB.push_back(elements_.front());	elements_.pop_front();
+		
+		DBB* dbb = dynamic_cast<DBB*>(m_arDBB.back().get());
+		
+		if (global_info->arCacheFieldShortSize.size() >= m_arDBB.size())
+		{
+			dbb->fShortIitms = global_info->arCacheFieldShortSize[m_arDBB.size() - 1];		
+		}
+		else
+		{
+			//???? группы??
+		}
 	}
 	if (proc.optional<EOF_T>())
 	{

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTCACHEDEFINITION.cpp

@@ -116,9 +116,10 @@ int PIVOTCACHEDEFINITION::serialize_definitions(std::wostream & strm)
 			{
 				CP_XML_ATTR(L"r:id", L"rId1" );
 			}
-			CP_XML_ATTR(L"recordCount", db->crdbUsed);
-			CP_XML_ATTR(L"refreshedBy", db->rgb.value());
-			CP_XML_ATTR(L"refreshedDate", db_ex->numDate.data.value);
+			CP_XML_ATTR(L"enableRefresh",	1);
+			CP_XML_ATTR(L"refreshedBy",		db->rgb.value());
+			CP_XML_ATTR(L"refreshedDate",	db_ex->numDate.data.value);
+			CP_XML_ATTR(L"recordCount",		db->crdbUsed);
 			//createdVersion="1" 
 			//refreshedVersion="2" 
 			//upgradeOnRefresh="1">

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTCORE.cpp

@@ -31,34 +31,31 @@
  */
 
 #include "PIVOTCORE.h"
-#include <Logic/Biff_records/SxView.h>
-#include <Logic/Biff_unions/PIVOTVD.h>
-#include <Logic/Biff_unions/PIVOTIVD.h>
-#include <Logic/Biff_unions/PIVOTPI.h>
-#include <Logic/Biff_records/SXDI.h>
-#include <Logic/Biff_unions/PIVOTLI.h>
-#include <Logic/Biff_unions/PIVOTEX.h>
+#include "PIVOTVD.h"
+#include "PIVOTIVD.h"
+#include "PIVOTPI.h"
+#include "PIVOTLI.h"
+#include "PIVOTEX.h"
+
+#include "../Biff_records/SXDI.h"
+#include "../Biff_records/SxView.h"
 
 namespace XLS
 {
 
-
 PIVOTCORE::PIVOTCORE()
 {
 }
 
-
 PIVOTCORE::~PIVOTCORE()
 {
 }
 
-
 BaseObjectPtr PIVOTCORE::clone()
 {
 	return BaseObjectPtr(new PIVOTCORE(*this));
 }
 
-
 // PIVOTCORE = SxView *PIVOTVD *2PIVOTIVD [PIVOTPI] *SXDI *PIVOTLI PIVOTEX
 const bool PIVOTCORE::loadContent(BinProcessor& proc)
 {

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTFRT9.cpp

@@ -55,7 +55,6 @@ BaseObjectPtr PIVOTFRT9::clone()
 	return BaseObjectPtr(new PIVOTFRT9(*this));
 }
 
-
 // PIVOTFRT9 = QsiSXTag [DBQUERYEXT] [PIVOTVIEWEX] SXViewEx9
 const bool PIVOTFRT9::loadContent(BinProcessor& proc)
 {

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTIVD.cpp

@@ -31,13 +31,12 @@
  */
 
 #include "PIVOTIVD.h"
-#include <Logic/Biff_records/SxIvd.h>
-#include <Logic/Biff_records/Continue.h>
+#include "../Biff_records/SxIvd.h"
+#include "../Biff_records/Continue.h"
 
 namespace XLS
 {
 
-
 PIVOTIVD::PIVOTIVD()
 {
 }
@@ -53,7 +52,6 @@ BaseObjectPtr PIVOTIVD::clone()
 	return BaseObjectPtr(new PIVOTIVD(*this));
 }
 
-
 // PIVOTIVD = SxIvd *Continue
 const bool PIVOTIVD::loadContent(BinProcessor& proc)
 {
@@ -68,6 +66,21 @@ const bool PIVOTIVD::loadContent(BinProcessor& proc)
 
 	return true;
 }
+int PIVOTIVD::serialize(std::wostream & strm)
+{
+	SxIvd* vd = dynamic_cast<SxIvd*>(m_SxIvd.get());
 
+	CP_XML_WRITER(strm)
+	{
+		for (size_t i = 0; i < vd->rgSxivd.size(); i++)
+		{
+			CP_XML_NODE(L"field")
+			{ 
+				CP_XML_ATTR(L"x", vd->rgSxivd[i]); 
+			}
+		}
+	}
+	return 0;
+}
 } // namespace XLS
 

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTIVD.h

@@ -47,6 +47,8 @@ public:
 
 	virtual const bool loadContent(BinProcessor& proc);
 
+	int serialize(std::wostream & strm);
+
 	static const ElementType type = typePIVOTIVD;
 
 	BaseObjectPtr	m_SxIvd;

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTLI.cpp

@@ -31,29 +31,26 @@
  */
 
 #include "PIVOTLI.h"
-#include <Logic/Biff_records/SXLI.h>
-#include <Logic/Biff_records/Continue.h>
+
+#include "../Biff_records/SXLI.h"
+#include "../Biff_records/Continue.h"
 
 namespace XLS
 {
 
-
 PIVOTLI::PIVOTLI()
 {
 }
 
-
 PIVOTLI::~PIVOTLI()
 {
 }
 
-
 BaseObjectPtr PIVOTLI::clone()
 {
 	return BaseObjectPtr(new PIVOTLI(*this));
 }
 
-
 // PIVOTLI = SXLI *Continue
 const bool PIVOTLI::loadContent(BinProcessor& proc)
 {
@@ -61,10 +58,58 @@ const bool PIVOTLI::loadContent(BinProcessor& proc)
 	{
 		return false;
 	}
+	m_SXLI = elements_.back();
+	elements_.pop_back();
+
 	proc.repeated<Continue>(0, 0);
 
 	return true;
 }
 
+int PIVOTLI::serialize(std::wostream & strm)
+{
+	SXLI* line_items = dynamic_cast<SXLI*>(m_SXLI.get());
+	if (!line_items) return 0;
+
+	CP_XML_WRITER(strm)
+	{
+ 		for (size_t i = 0; i < line_items->m_arItems.size(); i++)
+		{
+			CP_XML_NODE(L"i")
+			{
+				switch(line_items->m_arItems[i].itmType)
+				{
+					case 0x0001:	CP_XML_ATTR(L"t", L"default");	break;
+					case 0x0002:	CP_XML_ATTR(L"t", L"sum");		break;
+					case 0x0003:	CP_XML_ATTR(L"t", L"countA");	break;
+					case 0x0004:	CP_XML_ATTR(L"t", L"count");	break;
+					case 0x0005:	CP_XML_ATTR(L"t", L"avg");		break;
+					case 0x0006:	CP_XML_ATTR(L"t", L"max");		break;
+					case 0x0007:	CP_XML_ATTR(L"t", L"min");		break;
+					case 0x0008:	CP_XML_ATTR(L"t", L"product");	break;
+					case 0x0009:	CP_XML_ATTR(L"t", L"stdDev");	break;
+					case 0x000A:	CP_XML_ATTR(L"t", L"stdDevP");	break;
+					case 0x000B:	CP_XML_ATTR(L"t", L"var");		break;
+					case 0x000C:	CP_XML_ATTR(L"t", L"varP");		break;
+					case 0x000D:	CP_XML_ATTR(L"t", L"grand");	break;
+					case 0x000E:	CP_XML_ATTR(L"t", L"blank");	break;
+				}
+
+				if (line_items->m_arItems[i].cSic > 0 && line_items->m_arItems[i].itmType == 0)//??
+				{
+					CP_XML_ATTR(L"r", line_items->m_arItems[i].cSic);
+				}
+
+ 				for (size_t j = line_items->m_arItems[i].cSic; j < line_items->m_arItems[i].rgisxvi.size(); j++)
+				{
+					CP_XML_NODE(L"x")
+					{
+						CP_XML_ATTR(L"v", line_items->m_arItems[i].rgisxvi[j]); 
+					}
+				}
+			}
+		}
+	}
+}
 } // namespace XLS
 

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTLI.h

@@ -36,8 +36,6 @@
 namespace XLS
 {
 
-
-// Logical representation of PIVOTLI union of records 
 class PIVOTLI: public CompositeObject
 {
 	BASE_OBJECT_DEFINE_CLASS_NAME(PIVOTLI)
@@ -49,7 +47,11 @@ public:
 
 	virtual const bool loadContent(BinProcessor& proc);
 
-	static const ElementType	type = typePIVOTLI;
+	int serialize(std::wostream & strm);
+
+	static const ElementType type = typePIVOTLI;
+	
+	BaseObjectPtr m_SXLI;
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTPI.cpp

@@ -31,13 +31,12 @@
  */
 
 #include "PIVOTPI.h"
-#include <Logic/Biff_records/SXPI.h>
-#include <Logic/Biff_records/Continue.h>
+#include "../Biff_records/SXPI.h"
+#include "../Biff_records/Continue.h"
 
 namespace XLS
 {
 
-
 PIVOTPI::PIVOTPI()
 {
 }
@@ -53,7 +52,6 @@ BaseObjectPtr PIVOTPI::clone()
 	return BaseObjectPtr(new PIVOTPI(*this));
 }
 
-
 // PIVOTPI = SXPI *Continue
 const bool PIVOTPI::loadContent(BinProcessor& proc)
 {
@@ -69,5 +67,22 @@ const bool PIVOTPI::loadContent(BinProcessor& proc)
 	return true;
 }
 
+int PIVOTPI::serialize(std::wostream & strm)
+{
+	SXPI* page_items = dynamic_cast<SXPI*>(m_SXPI.get());
+	if (!page_items) return 0;
+
+	CP_XML_WRITER(strm)
+	{
+ 		for (size_t i = 0; i < page_items->m_arItems.size(); i++)
+		{
+			CP_XML_NODE(L"pageField")
+			{
+				CP_XML_ATTR(L"fld",	page_items->m_arItems[i].isxvd); 
+				CP_XML_ATTR(L"hier",0); 
+			}
+		}
+	}
+}
 } // namespace XLS
 

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTPI.h

@@ -47,6 +47,8 @@ public:
 
 	virtual const bool loadContent(BinProcessor& proc);
 
+	int serialize(std::wostream & strm);
+	
 	static const ElementType type = typePIVOTPI;
 
 	BaseObjectPtr m_SXPI;

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTVD.cpp

@@ -31,30 +31,26 @@
  */
 
 #include "PIVOTVD.h"
-#include <Logic/Biff_records/Sxvd.h>
-#include <Logic/Biff_records/SXVI.h>
-#include <Logic/Biff_records/SXVDEx.h>
+#include "../Biff_records/Sxvd.h"
+#include "../Biff_records/SXVI.h"
+#include "../Biff_records/SXVDEx.h"
 
 namespace XLS
 {
 
-
 PIVOTVD::PIVOTVD()
 {
 }
 
-
 PIVOTVD::~PIVOTVD()
 {
 }
 
-
 BaseObjectPtr PIVOTVD::clone()
 {
 	return BaseObjectPtr(new PIVOTVD(*this));
 }
 
-
 // PIVOTVD = Sxvd *SXVI SXVDEx
 const bool PIVOTVD::loadContent(BinProcessor& proc)
 {
@@ -79,6 +75,92 @@ const bool PIVOTVD::loadContent(BinProcessor& proc)
 
 	return true;
 }
+int PIVOTVD::serialize(std::wostream & strm)
+{
+	Sxvd*	vd		= dynamic_cast<Sxvd*>(m_Sxvd.get());
+	SXVDEx* vd_ex	= dynamic_cast<SXVDEx*>(m_SXVDEx.get());
 
+	if (!vd || !vd_ex) return 0;
+
+	CP_XML_WRITER(strm)
+	{
+		CP_XML_NODE(L"pivotField")
+		{ 
+			if		(vd->sxaxis.bRw)	CP_XML_ATTR(L"axis", L"axisRow"); 
+			else if (vd->sxaxis.bCol)	CP_XML_ATTR(L"axis", L"axisCol"); 
+			else if (vd->sxaxis.bPage)	CP_XML_ATTR(L"axis", L"axisPage"); 
+			else if (vd->sxaxis.bData)
+			{
+				CP_XML_ATTR(L"dataField", 1); 
+			}
+			
+			CP_XML_ATTR(L"compact",	0); 
+			
+			if (vd_ex->ifmt > 0)	
+			{
+				CP_XML_ATTR(L"numFmtId", vd_ex->ifmt);
+			}
+
+			if (vd->stName.value().empty() == false)
+				CP_XML_ATTR(L"name", vd->stName.value()); 
+
+			if (vd->fCounta)	CP_XML_ATTR(L"countASubtotal",	1);
+			if (vd->fCount)		CP_XML_ATTR(L"countSubtotal",	1);
+			if (vd->fSum)		CP_XML_ATTR(L"sumSubtotal",		1);
+			if (vd->fAverage)	CP_XML_ATTR(L"avgSubtotal",		1);
+			if (vd->fMax)		CP_XML_ATTR(L"maxSubtotal",		1);
+			if (vd->fMin)		CP_XML_ATTR(L"minSubtotal",		1);
+			if (vd->fProduct)	CP_XML_ATTR(L"productSubtotal", 1);
+			if (vd->fStdev)		CP_XML_ATTR(L"stdSubtotal",		1);
+			if (vd->fStdevp)	CP_XML_ATTR(L"stdDevSubtotal",	1);
+			if (vd->fVariance)	CP_XML_ATTR(L"varSubtotal",		1);
+			if (vd->fVariancep)	CP_XML_ATTR(L"varPSubtotal",	1);
+
+			CP_XML_ATTR(L"outline",			vd_ex->fOutline);
+			CP_XML_ATTR(L"subtotalTop",		vd_ex->fSubtotalAtTop);
+			CP_XML_ATTR(L"showAll",			vd_ex->fShowAllItems);
+			
+			if (vd_ex->fNotDragToData)		CP_XML_ATTR(L"dragToData",	0);
+			if (!vd_ex->fDragToRow)			CP_XML_ATTR(L"dragToRow",	0);
+			if (!vd_ex->fDragToColumn)		CP_XML_ATTR(L"dragToCol",	0);
+			if (!vd_ex->fDragToPage)		CP_XML_ATTR(L"dragToPage",	0);
+			
+			if (vd_ex->fHideNewItems)		CP_XML_ATTR(L"hideNewItems",	1);
+			if (vd_ex->fInsertBlankRow)		CP_XML_ATTR(L"insertBlankRow",	1);
+			if (vd_ex->fPageBreaksBetweenItems)	CP_XML_ATTR(L"insertPageBreak", 1);
+			if (!vd_ex->fTopAutoShow)		CP_XML_ATTR(L"topAutoShow",		0);
+			//if (!vd_ex->fDragToHide)		CP_XML_ATTR(L"dragOff",	0);	//??
+			if (vd_ex->fServerBased)		CP_XML_ATTR(L"serverField",		1);
+			
+			//CP_XML_ATTR(L"",				vd_ex->fCalculatedField);
+			CP_XML_ATTR(L"includeNewItemsInFilter", 1); 
+
+			//CP_XML_ATTR(L"nonAutoSortDefault", !vd_ex->fAutoSort);
+			if (vd_ex->fAutoSort)
+			{
+			//	vd_ex->isxdiAutoSort
+			
+				if (vd_ex->fAscendSort)	CP_XML_ATTR(L"sortType", L"ascending"); 
+			}
+			if (vd_ex->isxdiAutoShow >= 0)
+			{
+				CP_XML_ATTR(L"rankBy", vd_ex->isxdiAutoShow);
+			}		
+			if (!vd->fDefault)	CP_XML_ATTR(L"defaultSubtotal",	0);
+			if (!m_arSXVI.empty())
+			{
+				CP_XML_NODE(L"items")
+				{
+					CP_XML_ATTR(L"count", m_arSXVI.size()); 
+					for (size_t i = 0; i < m_arSXVI.size(); i++)
+					{
+						m_arSXVI[i]->serialize(CP_XML_STREAM());
+					}
+				}
+			}
+		}
+	}
+	return 0;
+}
 } // namespace XLS
 

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTVD.h

@@ -49,6 +49,8 @@ public:
 
 	static const ElementType type = typePIVOTVD;
 
+	int serialize(std::wostream & strm);
+
 	BaseObjectPtr				m_Sxvd;
 	std::vector<BaseObjectPtr>	m_arSXVI;
 	BaseObjectPtr				m_SXVDEx;

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTVIEW.cpp

@@ -31,29 +31,34 @@
  */
 
 #include "PIVOTVIEW.h"
-#include <Logic/Biff_unions/PIVOTCORE.h>
-#include <Logic/Biff_unions/PIVOTFRT.h>
+#include "PIVOTCORE.h"
+#include "PIVOTFRT.h"
+#include "PIVOTVD.h"
+#include "PIVOTIVD.h"
+#include "PIVOTPI.h"
+#include "PIVOTLI.h"
+#include "PIVOTEX.h"
+
+#include "../Biff_records/SXDI.h"
+#include "../Biff_records/SxView.h"
 
 namespace XLS
 {
 
-
 PIVOTVIEW::PIVOTVIEW()
 {
+	indexCache = -1;
 }
 
-
 PIVOTVIEW::~PIVOTVIEW()
 {
 }
 
-
 BaseObjectPtr PIVOTVIEW::clone()
 {
 	return BaseObjectPtr(new PIVOTVIEW(*this));
 }
 
-
 // PIVOTVIEW = PIVOTCORE [PIVOTFRT]
 const bool PIVOTVIEW::loadContent(BinProcessor& proc)
 {
@@ -73,5 +78,135 @@ const bool PIVOTVIEW::loadContent(BinProcessor& proc)
 	return true;
 }
 
+int PIVOTVIEW::serialize(std::wostream & strm)
+{
+	PIVOTCORE* core = dynamic_cast<PIVOTCORE*>(m_PIVOTCORE.get());
+	if (!core) return 0;
+
+	SxView* view = dynamic_cast<SxView*>(core->m_SxView.get());
+	if (!view) return 0;
+
+	PIVOTFRT* frt = dynamic_cast<PIVOTFRT*>(m_PIVOTFRT.get());
+
+	indexCache = view->iCache;
+
+	CP_XML_WRITER(strm)
+	{
+		CP_XML_NODE(L"pivotTableDefinition")
+		{ 
+			CP_XML_ATTR(L"xmlns", L"http://schemas.openxmlformats.org/spreadsheetml/2006/main");
+			
+			CP_XML_ATTR(L"name",				view->stTable.value()); 
+			CP_XML_ATTR(L"cacheId",				view->iCache); 
+			CP_XML_ATTR(L"useAutoFormatting",	view->fAutoFormat); 
+			CP_XML_ATTR(L"dataOnRows",			view->sxaxis4Data.bRw); 
+			CP_XML_ATTR(L"autoFormatId",		view->itblAutoFmt);
+			CP_XML_ATTR(L"applyNumberFormats",	view->fAtrNum);
+			CP_XML_ATTR(L"applyBorderFormats",	view->fAtrBdr); 
+			CP_XML_ATTR(L"applyFontFormats",	view->fAtrFnt);
+			CP_XML_ATTR(L"applyPatternFormats",	view->fAtrPat);
+			CP_XML_ATTR(L"applyAlignmentFormats",	view->fAtrAlc);
+			CP_XML_ATTR(L"applyWidthHeightFormats",	view->fAtrProc);
+			if (!view->stData.value().empty())
+			{
+				CP_XML_ATTR(L"dataCaption",			view->stData.value()); 
+			}
+			//updatedVersion="2" 
+			//asteriskTotals="1" 
+			//showMemberPropertyTips="0" 
+			//itemPrintTitles="1" 
+			//createdVersion="1" 
+			//indent="0" 
+			//compact="0" 
+			//compactData="0" 
+			//gridDropZones="1"		
+			CP_XML_NODE(L"location")
+			{
+				CP_XML_ATTR(L"ref", view->ref.toString());
+				CP_XML_ATTR(L"firstHeaderRow", view->rwFirstHead - view->ref.rowFirst );
+				CP_XML_ATTR(L"firstDataRow", view->rwFirstData - view->ref.rowFirst);
+				CP_XML_ATTR(L"firstDataCol", view->colFirstData - view->ref.columnFirst); 
+				CP_XML_ATTR(L"rowPageCount", 1); 
+				CP_XML_ATTR(L"colPageCount", 1);
+			}
+			CP_XML_NODE(L"pivotFields")
+			{
+				CP_XML_ATTR(L"count", view->cDim);//Sxvd 
+				for (size_t i = 0; i <  core->m_arPIVOTVD.size(); i++)
+				{
+					core->m_arPIVOTVD[i]->serialize(CP_XML_STREAM());
+				}
+			}
+			if (core->m_arPIVOTIVD.size() >= 1)
+			{
+				CP_XML_NODE(L"rowFields")
+				{
+					CP_XML_ATTR(L"count", view->cDimRw);
+
+					PIVOTIVD* ivd = dynamic_cast<PIVOTIVD*>(core->m_arPIVOTIVD[0].get());
+					ivd->serialize(CP_XML_STREAM());
+				}
+			}
+			if (core->m_arPIVOTLI.size() >= 1)//0 or 2
+			{
+				CP_XML_NODE(L"rowItems")
+				{
+					CP_XML_ATTR(L"count", view->cRw);
+					
+					PIVOTLI* line = dynamic_cast<PIVOTLI*>(core->m_arPIVOTLI[0].get());
+					line->serialize(CP_XML_STREAM());
+				}
+			}
+			if (core->m_arPIVOTIVD.size() == 2)//0 or 2
+			{
+				CP_XML_NODE(L"colFields")
+				{
+					CP_XML_ATTR(L"count", view->cDimCol);
+					
+					PIVOTIVD* ivd = dynamic_cast<PIVOTIVD*>(core->m_arPIVOTIVD[1].get());
+					ivd->serialize(CP_XML_STREAM());
+				}
+			}
+			if (core->m_arPIVOTLI.size() == 2)//0 or 2
+			{
+				CP_XML_NODE(L"colItems")
+				{
+					CP_XML_ATTR(L"count", view->cCol);
+					
+					PIVOTLI* line = dynamic_cast<PIVOTLI*>(core->m_arPIVOTLI[1].get());
+					line->serialize(CP_XML_STREAM());
+				}
+			}
+			if (core->m_PIVOTPI)
+			{
+				CP_XML_NODE(L"pageFields")
+				{
+					CP_XML_ATTR(L"count", view->cDimPg);
+					
+					core->m_PIVOTPI->serialize(CP_XML_STREAM());
+				}
+			}
+			CP_XML_NODE(L"dataFields")
+			{
+				CP_XML_ATTR(L"count", view->cDimData);
+				for (size_t i = 0; i <  core->m_arSXDI.size(); i++)
+				{
+					core->m_arSXDI[i]->serialize(CP_XML_STREAM());
+				}
+			}
+			//CP_XML_NODE(L"pivotTableStyleInfo")
+			//{
+			//	CP_XML_ATTR(L"showRowHeaders", 1); 
+			//	CP_XML_ATTR(L"showColHeaders", 1);
+			//	CP_XML_ATTR(L"showRowStripes", 0);
+			//	CP_XML_ATTR(L"showColStripes", 0);
+			//	CP_XML_ATTR(L"showLastColumn", 1);
+			//}
+		}
+	}
+
+	return 0;
+}
+
 } // namespace XLS
 

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTVIEW.h

@@ -47,10 +47,14 @@ public:
 
 	virtual const bool loadContent(BinProcessor& proc);
 
+	int serialize(std::wostream & strm);
+
 	static const ElementType type = typePIVOTVIEW;
 
 	BaseObjectPtr	m_PIVOTCORE;
 	BaseObjectPtr	m_PIVOTFRT;
+//----------------------------------
+	int indexCache;
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/PIVOTVIEWEX.cpp

@@ -39,23 +39,19 @@
 namespace XLS
 {
 
-
 PIVOTVIEWEX::PIVOTVIEWEX()
 {
 }
 
-
 PIVOTVIEWEX::~PIVOTVIEWEX()
 {
 }
 
-
 BaseObjectPtr PIVOTVIEWEX::clone()
 {
 	return BaseObjectPtr(new PIVOTVIEWEX(*this));
 }
 
-
 // PIVOTVIEWEX = SXViewEx *PIVOTTH *SXPIEx *PIVOTVDTEX
 const bool PIVOTVIEWEX::loadContent(BinProcessor& proc)
 {

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/SXOPER.cpp

@@ -43,6 +43,11 @@ namespace XLS
 
 SXOPER::SXOPER()
 {
+	bString	= false;
+	bDate	= false;
+	bNumber	= false;
+	bEmpty	= false;
+	bInteger= false;
 }
 
 SXOPER::~SXOPER()
@@ -59,21 +64,36 @@ const bool SXOPER::loadContent(BinProcessor& proc)
 {
 	if(proc.optional<SxNil>())
 	{
+		bEmpty = true;
 	}
 	else if(proc.optional<SXNum>())
 	{
+
+		SXNum *num = dynamic_cast<SXNum*>(elements_.back().get());
+		if (num)
+		{
+			bInteger = (num->num.data.bytes.Byte1==num->num.data.bytes.Byte2 && 
+						num->num.data.bytes.Byte2==num->num.data.bytes.Byte3 && 
+						num->num.data.bytes.Byte3==num->num.data.bytes.Byte4 && 
+						num->num.data.bytes.Byte4==0);
+		}
+		bNumber = !bInteger;
 	}
 	else if(proc.optional<SxBool>())
 	{
+		bNumber = true;
 	}
 	else if(proc.optional<SxErr>())
 	{
+		bNumber = true;
 	}
 	else if(proc.optional<SXString>())
 	{
+		bString = true;
 	}
 	else if(proc.optional<SXDtr>())
 	{
+		bDate =true;
 	}
 	else 
 		return false;

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/SXOPER.h

@@ -52,6 +52,12 @@ public:
 	static const ElementType type = typeSXOPER;
 
 	BaseObjectPtr	m_element;	
+
+	bool	bString;
+	bool	bDate;
+	bool	bNumber;
+	bool	bEmpty;
+	bool	bInteger;
 };
 
 } // namespace XLS

ASCOfficeXlsFile2/source/XlsFormat/Logic/Biff_unions/SXRANGE.cpp

@@ -140,12 +140,8 @@ int SXRANGE::serialize(std::wostream & strm)
 				SXDtr* startDate = dynamic_cast<SXDtr*>(m_arSXDtr[0].get());
 				SXDtr* endDate = dynamic_cast<SXDtr*>(m_arSXDtr[1].get());
 
-				std::wstringstream s_start, s_end;
-				s_start << startDate->yr << L"-" << startDate->mon << L"-" << startDate->dom << L"T" << startDate->hr << L":" << startDate->min << L":" << startDate->sec;
-				s_end << endDate->yr << L"-" << endDate->mon << L"-" << endDate->dom << L"T" << endDate->hr << L":" << endDate->min << L":" << endDate->sec;
-				
-				CP_XML_ATTR(L"startDate", s_start.str());	
-				CP_XML_ATTR(L"endDate", s_end.str());	
+				CP_XML_ATTR(L"startDate", startDate->get_string_date());	
+				CP_XML_ATTR(L"endDate", endDate->get_string_date());	
 			}
 			if (m_arSXNum.size() == 3)
 			{

ASCOfficeXlsFile2/source/XlsFormat/Logic/GlobalWorkbookInfo.h

@@ -100,6 +100,8 @@ public:
 	const static unsigned int					initial_AXES_id = 0x2000000;
 
 	std::map<int, BaseObjectPtr>						mapPivotCache;
+	std::vector<bool>									arCacheFieldShortSize;
+
 	std::map<std::wstring, std::vector<std::wstring>>	mapDefineNames;
 	std::vector<std::wstring>							arDefineNames;
 	std::vector<std::wstring>							arExternalNames;

ASCOfficeXlsFile2/source/XlsXlsxConverter/XlsConverter.cpp

@@ -1916,6 +1916,18 @@ void XlsConverter::convert(XLS::PIVOTVIEW * pivot_view)
 {
 	if (pivot_view == NULL) return;
 
+	std::wstringstream strm;
+
+	pivot_view->serialize(strm);
+
+	int index_view = xlsx_context->get_pivots_context().add_view(strm.str(), pivot_view->indexCache);
+	
+	if (index_view > 0)
+	{
+		xlsx_context->current_sheet().sheet_rels().add(oox::relationship(L"pvId" + std::to_wstring(index_view),
+			L"http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotTable",
+			L"../pivotTables/pivotTable" + std::to_wstring(index_view) + L".xml"));
+	}
 }
 
 void XlsConverter::convert(XLS::PIVOTCACHEDEFINITION * pivot_cached)

ASCOfficeXlsFile2/source/XlsXlsxConverter/xlsx_conversion_context.cpp

@@ -272,14 +272,27 @@ void xlsx_conversion_context::end_document()
 							CP_XML_ATTR(L"r:id", rId);
 						}
 
-						xlsx_pivots_context_.dump_rels(i, content->get_rels());
-						xlsx_pivots_context_.write_definitions_to(i, content->definitions());
-						xlsx_pivots_context_.write_records_to(i, content->records());
+						xlsx_pivots_context_.dump_rels_cache(i, content->get_rels());
+						xlsx_pivots_context_.write_cache_definitions_to(i, content->definitions());
+						xlsx_pivots_context_.write_cache_records_to(i, content->records());
 
 						output_document_->get_xl_files().add_pivot_cache(content);	
 					}
 				}
 			}
+			int pivot_view_count = xlsx_pivots_context_.get_view_count();
+			if (pivot_view_count > 0)
+			{
+				for (int i = 0; i < pivot_view_count; i++)
+				{
+					package::pivot_table_content_ptr content = package::pivot_table_content::create();
+
+					xlsx_pivots_context_.dump_rels_view(i, content->get_rels());
+					xlsx_pivots_context_.write_table_view_to(i, content->content());
+
+					output_document_->get_xl_files().add_pivot_table(content);	
+				}
+			}
 		}
 
         output_document_->get_xl_files().set_workbook( package::simple_element::create(L"workbook.xml", strm_workbook.str()) );

ASCOfficeXlsFile2/source/XlsXlsxConverter/xlsx_drawing_context.cpp

@@ -2423,7 +2423,7 @@ void xlsx_drawing_context::set_custom_connection(std::vector<ODRAW::MSOPOINT>& p
 
 	current_drawing_states->back()->custom_connection = points;
 }
-void xlsx_drawing_context::set_custom_connectionDir(std::vector<ODRAW::FixedPoint>& points)
+void xlsx_drawing_context::set_custom_connectionDir(std::vector<OSHARED::FixedPoint>& points)
 {
 	if (current_drawing_states == NULL) return;	
 	if (current_drawing_states->empty()) return;

ASCOfficeXlsFile2/source/XlsXlsxConverter/xlsx_drawing_context.h

@@ -182,7 +182,7 @@ public:
 	std::vector<ODRAW::MSOPOINT>	custom_verticles;
 	std::vector<ODRAW::ADJH>		custom_adjustHandles;
 	std::vector<ODRAW::MSOPOINT>	custom_connection;
-	std::vector<ODRAW::FixedPoint>	custom_connectionDir;
+	std::vector<OSHARED::FixedPoint>custom_connectionDir;
 	std::vector<ODRAW::MSORECT>		custom_inscribe;
 
 	_rect							custom_rect;
@@ -413,7 +413,7 @@ public:
 		void set_custom_adjustValues(std::vector<_CP_OPT(int)>		& values);
 		void set_custom_path		(int type_path);
 		void set_custom_connection	(std::vector<ODRAW::MSOPOINT>	& points);
-		void set_custom_connectionDir(std::vector<ODRAW::FixedPoint>& points);
+		void set_custom_connectionDir(std::vector<OSHARED::FixedPoint>& points);
 		void set_custom_inscribe	(std::vector<ODRAW::MSORECT>	& rects);
 		void set_custom_x_limo		(int val);
 		void set_custom_y_limo		(int val);

ASCOfficeXlsFile2/source/XlsXlsxConverter/xlsx_package.cpp

@@ -89,13 +89,20 @@ _CP_PTR(pivot_cache_content) pivot_cache_content::create()
 {
     return boost::make_shared<pivot_cache_content>();
 }
+//--------------------------------------------------------------------------------------------
+pivot_table_content::pivot_table_content() : rels_file_(rels_file::create(L""))
+{      
+}
 
+_CP_PTR(pivot_table_content) pivot_table_content::create()
+{
+    return boost::make_shared<pivot_table_content>();
+}
+//--------------------------------------------------------------------------------------------
 sheet_content::sheet_content() : rels_(rels_file::create(L""))
 {
         
 }
-//--------------------------------------------------------------------------------------------
-
 _CP_PTR(sheet_content) sheet_content::create()
 {
     return boost::make_shared<sheet_content>();
@@ -169,16 +176,20 @@ void xl_files::write(const std::wstring & RootPath)
 	std::wstring path = RootPath + FILE_SEPARATOR_STR + L"xl";
     NSDirectory::CreateDirectory(path.c_str());
 
-    sheets_files_.set_rels(&rels_files_);
+    {
+		pivot_cache_files_.set_rels(&rels_files_);
+        pivot_cache_files_.set_main_document(get_main_document());
+		pivot_cache_files_.write(path);
+    }
+	{
+		pivot_table_files_.set_main_document(get_main_document());
+		pivot_table_files_.write(path);
+	}
+    
+	sheets_files_.set_rels(&rels_files_);
     sheets_files_.set_main_document( this->get_main_document() );
     sheets_files_.write(path);
 
-	int index = 1;
-    if (true)
-    {
-        //workbook_->hyperlinks->write(path);
-        rels_files_.add( relationship( L"hId1",  L"http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument", L"xl/workbook.xml" ) );
-	}
 	if (sharedStrings_)
     {
         sharedStrings_->write(path);
@@ -206,16 +217,11 @@ void xl_files::write(const std::wstring & RootPath)
         media_->set_main_document(get_main_document());
         media_->write(path);
     }
-
     {
         charts_files_.set_main_document(get_main_document());
         charts_files_.write(path);
     }
-    {
-		pivot_cache_files_.set_rels(&rels_files_);
-        pivot_cache_files_.set_main_document(get_main_document());
-        pivot_cache_files_.write(path);
-    }
+
 	if (drawings_)
     {
         drawings_->set_main_document(get_main_document());
@@ -281,6 +287,10 @@ void xl_files::add_pivot_cache(pivot_cache_content_ptr pivot_cache)
 {
     pivot_cache_files_.add_pivot_cache(pivot_cache);
 }
+void xl_files::add_pivot_table(pivot_table_content_ptr pivot_table)
+{
+    pivot_table_files_.add_pivot_table(pivot_table);
+}
 //----------------------------------------------------------------------------------------
 void xl_pivot_cache_files::add_pivot_cache(pivot_cache_content_ptr pivot_cache)
 {
@@ -326,7 +336,7 @@ void xl_pivot_cache_files::write(const std::wstring & RootPath)
 			{
 				const std::wstring fileNameR = std::wstring(L"pivotCacheRecords") + std::to_wstring(i + 1) + L".xml";
 	           
-				contentTypes.add_override(std::wstring(L"/xl/pivotCache/") + fileNameR, kWSConTypeD);
+				contentTypes.add_override(std::wstring(L"/xl/pivotCache/") + fileNameR, kWSConTypeR);
 
 				package::simple_element(fileNameR, content_records).write(path);
 			}
@@ -334,6 +344,41 @@ void xl_pivot_cache_files::write(const std::wstring & RootPath)
     }
 }
 //----------------------------------------------------------------------------------------
+void xl_pivot_table_files::add_pivot_table(pivot_table_content_ptr pivot_table)
+{
+    pivot_tables_.push_back(pivot_table);
+}
+void xl_pivot_table_files::write(const std::wstring & RootPath)
+{
+	std::wstring path = RootPath + FILE_SEPARATOR_STR + L"pivotTables";
+    NSDirectory::CreateDirectory(path.c_str());
+
+	content_type & contentTypes = this->get_main_document()->content_type().get_content_type();
+	
+	static const std::wstring kWSConType = L"application/vnd.openxmlformats-officedocument.spreadsheetml.pivotTable+xml";
+	
+	for (size_t i = 0; i < pivot_tables_.size(); i++)
+    {
+        if (pivot_tables_[i])
+        {
+            const std::wstring fileName = std::wstring(L"pivotTable") + std::to_wstring(i + 1) + L".xml";
+           
+            contentTypes.add_override(std::wstring(L"/xl/pivotTables/") + fileName, kWSConType);
+
+            package::simple_element(fileName, pivot_tables_[i]->str()).write(path);
+
+            if (pivot_tables_[i]->get_rels().empty() == false)
+			{
+				rels_files relFiles;
+				pivot_tables_[i]->rels_file_->set_file_name(fileName + L".rels");
+				
+				relFiles.add_rel_file(pivot_tables_[i]->rels_file_);
+				relFiles.write(path);
+			}
+        }
+    }
+}
+//----------------------------------------------------------------------------------------
 void xl_charts_files::add_chart(chart_content_ptr chart)
 {
     charts_.push_back(chart);

ASCOfficeXlsFile2/source/XlsXlsxConverter/xlsx_package.h

@@ -89,6 +89,26 @@ private:
 	rels_file_ptr		definitions_rels_file_;
 };
 //------------------------------------------------------------------------
+class pivot_table_content;
+typedef _CP_PTR(pivot_table_content) pivot_table_content_ptr;
+
+class pivot_table_content : boost::noncopyable
+{
+public:
+    pivot_table_content();
+    static _CP_PTR(pivot_table_content) create();
+
+    std::wostream	& content()		{ return content_; }
+	rels			& get_rels()	{ return rels_file_->get_rels(); }
+
+    std::wstring	str() { return content_.str(); }
+	
+	friend class	xl_pivot_table_files;
+private:
+    std::wstringstream	content_;
+	rels_file_ptr		rels_file_;
+};
+//------------------------------------------------------------------------
 class sheets_files  : public element
 {
 public:
@@ -119,7 +139,16 @@ public:
     std::vector<chart_content_ptr> charts_;
 
 };
-
+class xl_pivot_table_files  : public element
+{
+public:
+	xl_pivot_table_files(){}
+	 
+	void			add_pivot_table(pivot_table_content_ptr pivot_table);
+	virtual void	write(const std::wstring & RootPath);
+    
+    std::vector<pivot_table_content_ptr> pivot_tables_;
+};
 class xl_pivot_cache_files  : public element
 {
 public:
@@ -200,13 +229,14 @@ public:
 	void set_vml_drawings	(element_ptr Element);
 	void set_comments		(element_ptr Element);
     void add_charts			(chart_content_ptr chart);
-    void add_pivot_cache	(pivot_cache_content_ptr pivot);
-
+    void add_pivot_cache	(pivot_cache_content_ptr cache);
+	void add_pivot_table	(pivot_table_content_ptr table);
 private:
     rels_files				rels_files_;
     sheets_files			sheets_files_;
     xl_charts_files			charts_files_;
 	xl_pivot_cache_files	pivot_cache_files_;
+	xl_pivot_table_files	pivot_table_files_;
 
 	element_ptr				theme_;
     element_ptr				workbook_;

ASCOfficeXlsFile2/source/XlsXlsxConverter/xlsx_pivots_context.cpp

@@ -31,14 +31,11 @@
  */
 #include "xlsx_pivots_context.h"
 
-
 #include <boost/make_shared.hpp>
 #include <simple_xml_writer.h>
 
 namespace oox {
 
-
-
 class xlsx_pivots_context::Impl
 {
 public:
@@ -47,10 +44,16 @@ public:
 		std::wstring  definitionsData_;
 		std::wstring  recordsData_;
 	};
+	struct _pivot_view
+	{	
+		std::wstring	data_;
+		int				indexCache_;
+	};
 
 	Impl() {}
     
-	std::vector<_pivot_cache> caches_;
+	std::vector<_pivot_cache>	caches_;
+	std::vector<_pivot_view>	views_;
 };
 
 xlsx_pivots_context::xlsx_pivots_context() : impl_(new xlsx_pivots_context::Impl())
@@ -67,24 +70,52 @@ int xlsx_pivots_context::get_cache_count()
 {
 	return (int)impl_->caches_.size();
 }
-void xlsx_pivots_context::dump_rels(int index, rels & Rels)
+
+void xlsx_pivots_context::dump_rels_cache(int index, rels & Rels)
 {
-	if (!impl_->caches_[index].recordsData_.empty())
+	if (impl_->caches_[index].recordsData_.empty() == false)
 	{
 		Rels.add(relationship(L"rId1",							
 						L"http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotCacheRecords",
-						L"pivotCacheRecords" + std::to_wstring(index) + L".xml", L""));
+						L"pivotCacheRecords" + std::to_wstring(index + 1) + L".xml", L""));
 	}
 }
-void xlsx_pivots_context::write_definitions_to(int index, std::wostream & strm)
+void xlsx_pivots_context::dump_rels_view(int index, rels & Rels)
+{
+	if (impl_->views_[index].indexCache_ >= 0)
+	{
+		Rels.add(relationship(L"rId1",							
+						L"http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotCacheDefinition",
+						L"../pivotCache/pivotCacheDefinition" + std::to_wstring(impl_->views_[index].indexCache_ + 1) + L".xml", L""));
+	}
+}
+void xlsx_pivots_context::write_cache_definitions_to(int index, std::wostream & strm)
 {
 	strm << impl_->caches_[index].definitionsData_;
 }
 
-void xlsx_pivots_context::write_records_to(int index, std::wostream & strm)
+void xlsx_pivots_context::write_cache_records_to(int index, std::wostream & strm)
 {
 	strm << impl_->caches_[index].recordsData_;
 }
+void xlsx_pivots_context::write_table_view_to(int index, std::wostream & strm)
+{
+	strm << impl_->views_[index].data_;
+}
+int xlsx_pivots_context::add_view(std::wstring table_view, int indexCache)
+{
+	if (table_view.empty()) return 0;
+
+	Impl::_pivot_view v = {table_view, indexCache};
+	impl_->views_.push_back(v);
+
+	return (int)impl_->views_.size();
+}
+
+int xlsx_pivots_context::get_view_count()
+{
+	return (int)impl_->views_.size();
+}
 
 xlsx_pivots_context::~xlsx_pivots_context()
 {

ASCOfficeXlsFile2/source/XlsXlsxConverter/xlsx_pivots_context.h

@@ -43,13 +43,19 @@ public:
     xlsx_pivots_context();
     ~xlsx_pivots_context();
 
+	int add_view(std::wstring table_view, int indexCache);
+	int get_view_count();
+
 	void add_cache(std::wstring definitions, std::wstring records);
 	int get_cache_count();
 
-	void write_definitions_to	(int index, std::wostream & strm);
-	void write_records_to		(int index, std::wostream & strm);
+	void write_cache_definitions_to	(int index, std::wostream & strm);
+	void write_cache_records_to		(int index, std::wostream & strm);
 
-	void dump_rels(int index, rels & Rels);
+	void write_table_view_to		(int index, std::wostream & strm);
+
+	void dump_rels_cache(int index, rels & Rels);
+	void dump_rels_view	(int index, rels & Rels);
 private:
     class Impl;
     _CP_PTR(Impl) impl_;

Common/3dParty/curl/build.bat

@@ -0,0 +1,43 @@
+SET SCRIPTPATH=%~dp0
+CD /D %~dp0
+SET MACHINE=x86
+if defined ProgramFiles(x86) (
+	SET MACHINE=x64
+)
+
+if "%TARGET%" == "win-32" (
+  SET MACHINE=x86
+)
+
+if "%TARGET%" == "win-64" (
+  SET MACHINE=x64
+)
+
+if "%MACHINE%" == "x86" (
+  SET OUTPUT=win_32
+)
+
+if "%MACHINE%" == "x64" (
+  SET OUTPUT=win_64
+)
+
+SET VC=%ProgramFiles%\Microsoft Visual Studio 12.0\VC
+SET VC64=%ProgramFiles(x86)%\Microsoft Visual Studio 12.0\VC
+if exist %VC64% (
+	SET VC=%VC64%
+)
+
+call "%VC%\vcvarsall.bat" %MACHINE%
+
+cd curl
+call buildconf.bat
+cd winbuild
+nmake /f Makefile.vc mode=static ENABLE_WINSSL=yes MACHINE=%MACHINE% VC=12
+
+if not exist "%SCRIPTPATH%%OUTPUT%" (
+   md %SCRIPTPATH%%OUTPUT%\build
+   xcopy /Y /S ..\builds\libcurl-vc12-%MACHINE%-release-static-ipv6-sspi-winssl\lib\libcurl_a.lib %SCRIPTPATH%%OUTPUT%\build\
+   mv %SCRIPTPATH%%OUTPUT%\build\libcurl_a.lib %SCRIPTPATH%%OUTPUT%\build\curl.lib
+)
+
+cd ..\..

Common/3dParty/curl/fetch.bat

@@ -0,0 +1,7 @@
+CD /D %~dp0
+SET CURL_FOLDER=curl
+IF NOT EXIST %CURL_FOLDER% CALL git clone https://github.com/curl/curl.git %CURL_FOLDER%
+CD %CURL_FOLDER%
+CALL git fetch
+CALL git checkout curl-7_54_1
+CD ..

Common/3dParty/curl/fetch.sh

@@ -0,0 +1,8 @@
+CURL_FOLDER=curl
+if [ ! -d ${CURL_FOLDER} ]; then
+  git clone https://github.com/curl/curl.git ${CURL_FOLDER}
+fi
+cd ${CURL_FOLDER}
+git fetch
+git checkout curl-7_54_1
+cd ..

Common/3dParty/openssl/build.sh

@@ -1,12 +1,34 @@
 #!/bin/bash
 
-export PATH=`pwd`/depot_tools:"$PATH"
-
 SCRIPT=$(readlink -f "$0")
 SCRIPTPATH=$(dirname "$SCRIPT")
 
 cd "$SCRIPTPATH"/openssl
 
-perl ./Configure linux-64
+os=$(uname -s)
+platform=""
+
+case "$os" in
+  Linux*)   platform="linux" ;;
+  Darwin*)  platform="darwin64-x86_64-cc" ;; 
+  *)        exit ;;
+esac
+
+platformLinux=""
+
+architecture=$(uname -m)
+arch=""
+
+if [[ "$platform" == "linux" ]]
+then 
+case "$architecture" in
+  x86_64*) arch="-64" ;;
+  *) arch="-32" ;;
+esac 
+fi 
+
+echo "$platform$arch"
+
+perl ./Configure $platform$arch
 ./config
 make

Common/FileDownloader/FileDownloader_curl.cpp

@@ -40,8 +40,8 @@
 
 #include <stdio.h>
 
-#include "../3dParty/curl/include/curl/curl.h"
-#include "../3dParty/curl/include/curl/easy.h"
+#include <curl/curl.h>
+#include <curl/easy.h>
 
 
 class CFileDownloaderBaseCURL : public CFileDownloaderBase

Common/FileDownloader/FileDownloader_mac.mm

@@ -1,5 +1,10 @@
 #include "FileDownloader.h"
-#include <Cocoa/Cocoa.h>
+
+#if _IOS
+    #import <Foundation/Foundation.h>
+#else
+    #include <Cocoa/Cocoa.h>
+#endif
 
 static NSString* StringWToNSString ( const std::wstring& Str )
 {
@@ -34,21 +39,30 @@ public :
         {
             NSArray       *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
             NSString  *documentsDirectory = [paths objectAtIndex:0];
-
+            
             NSString  *filePath = StringWToNSString ( m_sFilePath );
             [urlData writeToFile:filePath atomically:YES];
-
-    #ifndef _ASC_USE_ARC_
+            
+#if defined(_IOS)
+            return 0;
+#else
+#ifndef _ASC_USE_ARC_
             [stringURL release];
             [url release];
             [urlData release];
-    #endif
+#endif
+#endif
             return 0;
         }
-    #ifndef _ASC_USE_ARC_
+        
+#if defined(_IOS)
+        return 1;
+#else
+#ifndef _ASC_USE_ARC_
         [stringURL release];
         [url release];
-    #endif
+#endif
+#endif
         return 1;
     }
 };

DesktopEditor/Word_Api/Editor_Api.h

@@ -1087,9 +1087,9 @@ namespace NSEditorApi
 	class CAscCatAxisSettings
     {
 	private:
-        js_wrapper<double>		m_dInternalBetweenTick;
+        js_wrapper<double>		m_dIntervalBetweenTick;
 		js_wrapper<int>			m_nIntervalBetweenLabelsRule;	// c_oAscBetweenLabelsRule_
-		js_wrapper<double>		m_dInternalBetweenLabels;
+		js_wrapper<double>		m_dIntervalBetweenLabels;
 
 		js_wrapper<bool>		m_bInvertCatOrder;
 		js_wrapper<double>		m_dLabelsAxisDistance;
@@ -1105,15 +1105,18 @@ namespace NSEditorApi
 		js_wrapper<int>			m_nLabelsPosition;	// c_oAscLabelsPosition_
 
 		js_wrapper<int>			m_nAxisType;		// c_oAscAxisType_
+        
+        js_wrapper<int>			m_nCrossMinVal;
+        js_wrapper<int>			m_nCrossMaxVal;
 
 	public:
 		CAscCatAxisSettings()
 		{
 		}
 
-		LINK_PROPERTY_DOUBLE_JS(InternalBetweenTick)
+		LINK_PROPERTY_DOUBLE_JS(IntervalBetweenTick)
 		LINK_PROPERTY_INT_JS(IntervalBetweenLabelsRule)
-		LINK_PROPERTY_DOUBLE_JS(InternalBetweenLabels)
+		LINK_PROPERTY_DOUBLE_JS(IntervalBetweenLabels)
 
 		LINK_PROPERTY_BOOL_JS(InvertCatOrder)
 		LINK_PROPERTY_DOUBLE_JS(LabelsAxisDistance)
@@ -1125,6 +1128,9 @@ namespace NSEditorApi
 		LINK_PROPERTY_INT_JS(Crosses)
 		LINK_PROPERTY_INT_JS(LabelsPosition)
 		LINK_PROPERTY_INT_JS(AxisType)
+        
+        LINK_PROPERTY_INT_JS(CrossMinVal)
+        LINK_PROPERTY_INT_JS(CrossMaxVal)
     };
 
 	class CAscChartProperties : public IMenuEventDataBase
@@ -1155,8 +1161,11 @@ namespace NSEditorApi
         
 		js_wrapper<std::wstring>	m_sSeparator;
 
-		js_wrapper<CAscValAxisSettings>	m_oHorAxisProps;
-		js_wrapper<CAscValAxisSettings>	m_oVertAxisProps;
+		js_wrapper<CAscValAxisSettings>	m_oHorValAxisProps;
+		js_wrapper<CAscValAxisSettings>	m_oVertValAxisProps;
+       
+        js_wrapper<CAscCatAxisSettings>	m_oHorCatAxisProps;
+        js_wrapper<CAscCatAxisSettings>	m_oVertCatAxisProps;
         
 		js_wrapper<std::wstring>	m_sRange;
 		js_wrapper<bool>			m_bInColumns;
@@ -1196,8 +1205,11 @@ namespace NSEditorApi
 
 		LINK_PROPERTY_STRING_JS(Separator)
 
-		LINK_PROPERTY_OBJECT_JS(CAscValAxisSettings, HorAxisProps)
-		LINK_PROPERTY_OBJECT_JS(CAscValAxisSettings, VertAxisProps)
+		LINK_PROPERTY_OBJECT_JS(CAscValAxisSettings, HorValAxisProps)
+		LINK_PROPERTY_OBJECT_JS(CAscValAxisSettings, VertValAxisProps)
+      
+        LINK_PROPERTY_OBJECT_JS(CAscCatAxisSettings, HorCatAxisProps)
+        LINK_PROPERTY_OBJECT_JS(CAscCatAxisSettings, VertCatAxisProps)
 
 		LINK_PROPERTY_STRING_JS(Range)
 		LINK_PROPERTY_BOOL_JS(InColumns)

DesktopEditor/ios_projects/PdfWriter/PdfWriter.xcodeproj/project.pbxproj

@@ -251,7 +251,7 @@
 		7C560F671AA71A91000E5860 /* Project object */ = {
 			isa = PBXProject;
 			attributes = {
-				LastUpgradeCheck = 0700;
+				LastUpgradeCheck = 0830;
 				ORGANIZATIONNAME = "Ascensio System";
 				TargetAttributes = {
 					7C560F6E1AA71A91000E5860 = {
@@ -346,8 +346,10 @@
 				CLANG_WARN_DIRECT_OBJC_ISA_USAGE = YES_ERROR;
 				CLANG_WARN_EMPTY_BODY = YES;
 				CLANG_WARN_ENUM_CONVERSION = YES;
+				CLANG_WARN_INFINITE_RECURSION = YES;
 				CLANG_WARN_INT_CONVERSION = YES;
 				CLANG_WARN_OBJC_ROOT_CLASS = YES_ERROR;
+				CLANG_WARN_SUSPICIOUS_MOVE = YES;
 				CLANG_WARN_UNREACHABLE_CODE = YES;
 				CLANG_WARN__DUPLICATE_METHOD_MATCH = YES;
 				COPY_PHASE_STRIP = NO;
@@ -355,6 +357,7 @@
 				ENABLE_TESTABILITY = YES;
 				GCC_C_LANGUAGE_STANDARD = gnu99;
 				GCC_DYNAMIC_NO_PIC = NO;
+				GCC_NO_COMMON_BLOCKS = YES;
 				GCC_OPTIMIZATION_LEVEL = 0;
 				GCC_PREPROCESSOR_DEFINITIONS = (
 					"DEBUG=1",
@@ -388,14 +391,17 @@
 				CLANG_WARN_DIRECT_OBJC_ISA_USAGE = YES_ERROR;
 				CLANG_WARN_EMPTY_BODY = YES;
 				CLANG_WARN_ENUM_CONVERSION = YES;
+				CLANG_WARN_INFINITE_RECURSION = YES;
 				CLANG_WARN_INT_CONVERSION = YES;
 				CLANG_WARN_OBJC_ROOT_CLASS = YES_ERROR;
+				CLANG_WARN_SUSPICIOUS_MOVE = YES;
 				CLANG_WARN_UNREACHABLE_CODE = YES;
 				CLANG_WARN__DUPLICATE_METHOD_MATCH = YES;
 				COPY_PHASE_STRIP = YES;
 				ENABLE_NS_ASSERTIONS = NO;
 				ENABLE_STRICT_OBJC_MSGSEND = YES;
 				GCC_C_LANGUAGE_STANDARD = gnu99;
+				GCC_NO_COMMON_BLOCKS = YES;
 				GCC_WARN_64_TO_32_BIT_CONVERSION = YES;
 				GCC_WARN_ABOUT_RETURN_TYPE = YES_ERROR;
 				GCC_WARN_UNDECLARED_SELECTOR = YES;

UnicodeConverter/icubuilds/mac/icu/icu.xcodeproj/project.pbxproj

@@ -1790,7 +1790,7 @@
 		173241781BBECF8400E67992 /* Project object */ = {
 			isa = PBXProject;
 			attributes = {
-				LastUpgradeCheck = 0700;
+				LastUpgradeCheck = 0830;
 				ORGANIZATIONNAME = "Ascensio System SIA";
 				TargetAttributes = {
 					1732417F1BBECF8400E67992 = {
@@ -2228,8 +2228,10 @@
 				CLANG_WARN_DIRECT_OBJC_ISA_USAGE = YES_ERROR;
 				CLANG_WARN_EMPTY_BODY = YES;
 				CLANG_WARN_ENUM_CONVERSION = YES;
+				CLANG_WARN_INFINITE_RECURSION = YES;
 				CLANG_WARN_INT_CONVERSION = YES;
 				CLANG_WARN_OBJC_ROOT_CLASS = YES_ERROR;
+				CLANG_WARN_SUSPICIOUS_MOVE = YES;
 				CLANG_WARN_UNREACHABLE_CODE = YES;
 				CLANG_WARN__DUPLICATE_METHOD_MATCH = YES;
 				COPY_PHASE_STRIP = NO;
@@ -2270,8 +2272,10 @@
 				CLANG_WARN_DIRECT_OBJC_ISA_USAGE = YES_ERROR;
 				CLANG_WARN_EMPTY_BODY = YES;
 				CLANG_WARN_ENUM_CONVERSION = YES;
+				CLANG_WARN_INFINITE_RECURSION = YES;
 				CLANG_WARN_INT_CONVERSION = YES;
 				CLANG_WARN_OBJC_ROOT_CLASS = YES_ERROR;
+				CLANG_WARN_SUSPICIOUS_MOVE = YES;
 				CLANG_WARN_UNREACHABLE_CODE = YES;
 				CLANG_WARN__DUPLICATE_METHOD_MATCH = YES;
 				COPY_PHASE_STRIP = NO;
@@ -2297,7 +2301,7 @@
 			isa = XCBuildConfiguration;
 			buildSettings = {
 				CLANG_CXX_LANGUAGE_STANDARD = "gnu++0x";
-				CLANG_CXX_LIBRARY = "libstdc++";
+				CLANG_CXX_LIBRARY = "compiler-default";
 				ENABLE_BITCODE = NO;
 				EXCLUDED_RECURSIVE_SEARCH_PATH_SUBDIRECTORIES = "*.nib *.lproj *.framework *.gch *.xcode* *.xcassets (*) .DS_Store CVS .svn .git .hg *.pbproj *.pbxproj";
 				GCC_PREPROCESSOR_DEFINITIONS = (
@@ -2327,7 +2331,7 @@
 			isa = XCBuildConfiguration;
 			buildSettings = {
 				CLANG_CXX_LANGUAGE_STANDARD = "gnu++0x";
-				CLANG_CXX_LIBRARY = "libstdc++";
+				CLANG_CXX_LIBRARY = "compiler-default";
 				ENABLE_BITCODE = NO;
 				EXCLUDED_RECURSIVE_SEARCH_PATH_SUBDIRECTORIES = "*.nib *.lproj *.framework *.gch *.xcode* *.xcassets (*) .DS_Store CVS .svn .git .hg *.pbproj *.pbxproj";
 				GCC_PREPROCESSOR_DEFINITIONS = (

X2tConverter/build/Mac/X2tConverter/X2tConverter.xcodeproj/project.pbxproj

@@ -21,7 +21,6 @@
 /* End PBXAggregateTarget section */
 
 /* Begin PBXBuildFile section */
-		177C43321AD7C0EF00055DD7 /* libcurl.a in Frameworks */ = {isa = PBXBuildFile; fileRef = 177C432F1AD7C0D100055DD7 /* libcurl.a */; };
 		17C8DEC71ACD696100902C85 /* X2tConverter.mm in Sources */ = {isa = PBXBuildFile; fileRef = 17C27A191AC2DB3D00E1D003 /* X2tConverter.mm */; };
 		17C8DECC1ACD696100902C85 /* X2tConverter.h in Headers */ = {isa = PBXBuildFile; fileRef = 17C27A171AC2DB3D00E1D003 /* X2tConverter.h */; settings = {ATTRIBUTES = (Public, ); }; };
 		691A8BD31E2FA68F00DCB54A /* liblibxml2.a in Frameworks */ = {isa = PBXBuildFile; fileRef = 691A8BD01E2FA67E00DCB54A /* liblibxml2.a */; };
@@ -59,20 +58,6 @@
 /* End PBXBuildFile section */
 
 /* Begin PBXContainerItemProxy section */
-		177C432E1AD7C0D100055DD7 /* PBXContainerItemProxy */ = {
-			isa = PBXContainerItemProxy;
-			containerPortal = 177C432A1AD7C0D000055DD7 /* libcurl.xcodeproj */;
-			proxyType = 2;
-			remoteGlobalIDString = CD8AE2B416187F770095DC1B;
-			remoteInfo = curl;
-		};
-		177C43301AD7C0E400055DD7 /* PBXContainerItemProxy */ = {
-			isa = PBXContainerItemProxy;
-			containerPortal = 177C432A1AD7C0D000055DD7 /* libcurl.xcodeproj */;
-			proxyType = 1;
-			remoteGlobalIDString = CD8AE2B316187F770095DC1B;
-			remoteInfo = curl;
-		};
 		17C8DEDB1ACD6A3900902C85 /* PBXContainerItemProxy */ = {
 			isa = PBXContainerItemProxy;
 			containerPortal = 17E17F561AC457CD00BEA2EA /* ASCOfficeDocxFile2Lib.xcodeproj */;
@@ -440,7 +425,6 @@
 /* End PBXContainerItemProxy section */
 
 /* Begin PBXFileReference section */
-		177C432A1AD7C0D000055DD7 /* libcurl.xcodeproj */ = {isa = PBXFileReference; lastKnownFileType = "wrapper.pb-project"; name = libcurl.xcodeproj; path = ../../../../Common/3dParty/curl/projects/Mac/libcurl.xcodeproj; sourceTree = "<group>"; };
 		17C27A171AC2DB3D00E1D003 /* X2tConverter.h */ = {isa = PBXFileReference; lastKnownFileType = sourcecode.c.h; path = X2tConverter.h; sourceTree = "<group>"; };
 		17C27A191AC2DB3D00E1D003 /* X2tConverter.mm */ = {isa = PBXFileReference; lastKnownFileType = sourcecode.cpp.objcpp; path = X2tConverter.mm; sourceTree = "<group>"; };
 		17C8DED01ACD696100902C85 /* libX2tConverter.a */ = {isa = PBXFileReference; explicitFileType = archive.ar; includeInIndex = 0; path = libX2tConverter.a; sourceTree = BUILT_PRODUCTS_DIR; };
@@ -509,21 +493,12 @@
 				69415F311CB51D41003E771B /* libASCOfficeDocxFile2Lib_ios.a in Frameworks */,
 				69415F271CB51C37003E771B /* libOfficeUtils.a in Frameworks */,
 				698AF4C31C0745980080D889 /* libicu.a in Frameworks */,
-				177C43321AD7C0EF00055DD7 /* libcurl.a in Frameworks */,
 			);
 			runOnlyForDeploymentPostprocessing = 0;
 		};
 /* End PBXFrameworksBuildPhase section */
 
 /* Begin PBXGroup section */
-		177C432B1AD7C0D000055DD7 /* Products */ = {
-			isa = PBXGroup;
-			children = (
-				177C432F1AD7C0D100055DD7 /* libcurl.a */,
-			);
-			name = Products;
-			sourceTree = "<group>";
-		};
 		17C27A0B1AC2DB3C00E1D003 = {
 			isa = PBXGroup;
 			children = (
@@ -548,7 +523,6 @@
 				69DA322C1CEE08DC00E10AF0 /* metafile.xcodeproj */,
 				69DA32261CEE087D00E10AF0 /* cximage.xcodeproj */,
 				698AF4BB1C0740960080D889 /* icu.xcodeproj */,
-				177C432A1AD7C0D000055DD7 /* libcurl.xcodeproj */,
 				17E17F561AC457CD00BEA2EA /* ASCOfficeDocxFile2Lib.xcodeproj */,
 				69DA32501CEE095900E10AF0 /* freetype.xcodeproj */,
 				69DA325C1CEE09BB00E10AF0 /* PPTXFormatLib.xcodeproj */,
@@ -859,7 +833,6 @@
 				69415FE21CB5245A003E771B /* PBXTargetDependency */,
 				69415FDF1CB5244D003E771B /* PBXTargetDependency */,
 				698AF4C21C0745930080D889 /* PBXTargetDependency */,
-				177C43311AD7C0E400055DD7 /* PBXTargetDependency */,
 				69DA32EE1CEE100400E10AF0 /* PBXTargetDependency */,
 				17C8DEDC1ACD6A3900902C85 /* PBXTargetDependency */,
 			);
@@ -936,10 +909,6 @@
 					ProductGroup = 69415FBE1CB5243F003E771B /* Products */;
 					ProjectRef = 69415FBD1CB5243F003E771B /* jpeg.xcodeproj */;
 				},
-				{
-					ProductGroup = 177C432B1AD7C0D000055DD7 /* Products */;
-					ProjectRef = 177C432A1AD7C0D000055DD7 /* libcurl.xcodeproj */;
-				},
 				{
 					ProductGroup = 69415FBB1CB5243F003E771B /* Products */;
 					ProjectRef = 69415FBA1CB5243F003E771B /* libpsd.xcodeproj */;
@@ -1006,13 +975,6 @@
 /* End PBXProject section */
 
 /* Begin PBXReferenceProxy section */
-		177C432F1AD7C0D100055DD7 /* libcurl.a */ = {
-			isa = PBXReferenceProxy;
-			fileType = archive.ar;
-			path = libcurl.a;
-			remoteRef = 177C432E1AD7C0D100055DD7 /* PBXContainerItemProxy */;
-			sourceTree = BUILT_PRODUCTS_DIR;
-		};
 		17E17F5B1AC457CD00BEA2EA /* libASCOfficeDocxFile2Lib_ios.a */ = {
 			isa = PBXReferenceProxy;
 			fileType = archive.ar;
@@ -1228,11 +1190,6 @@
 /* End PBXSourcesBuildPhase section */
 
 /* Begin PBXTargetDependency section */
-		177C43311AD7C0E400055DD7 /* PBXTargetDependency */ = {
-			isa = PBXTargetDependency;
-			name = curl;
-			targetProxy = 177C43301AD7C0E400055DD7 /* PBXContainerItemProxy */;
-		};
 		17C8DEDC1ACD6A3900902C85 /* PBXTargetDependency */ = {
 			isa = PBXTargetDependency;
 			name = ASCOfficeDocxFile2Lib_ios;

X2tConverter/build/Qt/X2tConverter.pri

@@ -7,7 +7,7 @@
 QT       -= core
 QT       -= gui
 
-VERSION = 2.4.467.0
+VERSION = 2.4.468.0
 DEFINES += INTVER=$$VERSION
 
 TARGET = x2t