?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Version 5.2.6.1, tag libreoffice-5.2.6.1
[LibreOffice.git] / sc / source / filter / starcalc / scflt.cxx
blobd2ff51c845d88c4bb5a679f5abb0f18b757f59b2
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3 * This file is part of the LibreOffice project.
4 *
5 * This Source Code Form is subject to the terms of the Mozilla Public
6 * License, v. 2.0. If a copy of the MPL was not distributed with this
7 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8 *
9 * This file incorporates work covered by the following license notice:
10 *
11 * Licensed to the Apache Software Foundation (ASF) under one or more
12 * contributor license agreements. See the NOTICE file distributed
13 * with this work for additional information regarding copyright
14 * ownership. The ASF licenses this file to you under the Apache
15 * License, Version 2.0 (the "License"); you may not use this file
16 * except in compliance with the License. You may obtain a copy of
17 * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18 */
19
20 #include "scitems.hxx"
21 #include <editeng/eeitem.hxx>
22
23 #include <svx/algitem.hxx>
24 #include <editeng/boxitem.hxx>
25 #include <editeng/brushitem.hxx>
26 #include <editeng/colritem.hxx>
27 #include <editeng/crossedoutitem.hxx>
28 #include <editeng/editdata.hxx>
29 #include <editeng/editeng.hxx>
30 #include <editeng/editobj.hxx>
31 #include <editeng/fhgtitem.hxx>
32 #include <editeng/fontitem.hxx>
33 #include <editeng/lrspitem.hxx>
34 #include <svx/pageitem.hxx>
35 #include <editeng/postitem.hxx>
36 #include <editeng/sizeitem.hxx>
37 #include <editeng/udlnitem.hxx>
38 #include <editeng/ulspitem.hxx>
39 #include <editeng/wghtitem.hxx>
40 #include <editeng/justifyitem.hxx>
41 #include <svl/zforlist.hxx>
42 #include <svl/PasswordHelper.hxx>
43 #include <cassert>
44 #include <math.h>
45 #include <string.h>
46
47 #include "global.hxx"
48 #include "sc.hrc"
49 #include "attrib.hxx"
50 #include "patattr.hxx"
51 #include "docpool.hxx"
52 #include "document.hxx"
53 #include "collect.hxx"
54 #include "rangenam.hxx"
55 #include "dbdata.hxx"
56 #include "stlsheet.hxx"
57 #include "stlpool.hxx"
58 #include "filter.hxx"
59 #include "scflt.hxx"
60 #include "formulacell.hxx"
61 #include "scfobj.hxx"
62 #include "docoptio.hxx"
63 #include "viewopti.hxx"
64 #include "postit.hxx"
65 #include "globstr.hrc"
66 #include "ftools.hxx"
67 #include "tabprotection.hxx"
68
69 #include "fprogressbar.hxx"
70 #include <memory>
71
72 using namespace com::sun::star;
73
74 #define DEFCHARSET RTL_TEXTENCODING_MS_1252
75
76 #define SC10TOSTRING(p) OUString((p), strlen(p), DEFCHARSET)
77
78 const SCCOL SC10MAXCOL = 255; // #i85906# don't try to load more columns than there are in the file
79
80 /** Those strings are used with SC10TOSTRING() and strcmp() and such, hence
81 need to be 0-terminated. */
82 static void lcl_ReadFixedString( SvStream& rStream, void* pData, size_t nLen )
83 {
84 sal_Char* pBuf = static_cast<sal_Char*>(pData);
85 if (!nLen)
86 pBuf[0] = 0;
87 else
88 {
89 rStream.Read( pBuf, nLen);
90 pBuf[nLen-1] = 0;
91 }
92 }
93
94 static void lcl_ReadFileHeader(SvStream& rStream, Sc10FileHeader& rFileHeader)
95 {
96 lcl_ReadFixedString( rStream, &rFileHeader.CopyRight, sizeof(rFileHeader.CopyRight));
97 rStream.ReadUInt16( rFileHeader.Version );
98 rStream.Read(&rFileHeader.Reserved, sizeof(rFileHeader.Reserved));
99 }
100
101 static void lcl_ReadTabProtect(SvStream& rStream, Sc10TableProtect& rProtect)
102 {
103 lcl_ReadFixedString( rStream, &rProtect.PassWord, sizeof(rProtect.PassWord));
104 rStream.ReadUInt16( rProtect.Flags );
105 rStream.ReadUChar( rProtect.Protect );
106 }
107
108 static void lcl_ReadSheetProtect(SvStream& rStream, Sc10SheetProtect& rProtect)
109 {
110 lcl_ReadFixedString( rStream, &rProtect.PassWord, sizeof(rProtect.PassWord));
111 rStream.ReadUInt16( rProtect.Flags );
112 rStream.ReadUChar( rProtect.Protect );
113 }
114
115 static void lcl_ReadRGB(SvStream& rStream, Sc10Color& rColor)
116 {
117 rStream.ReadUChar( rColor.Dummy );
118 rStream.ReadUChar( rColor.Blue );
119 rStream.ReadUChar( rColor.Green );
120 rStream.ReadUChar( rColor.Red );
121 }
122
123 static void lcl_ReadPalette(SvStream& rStream, Sc10Color* pPalette)
124 {
125 for (sal_uInt16 i = 0; i < 16; i++)
126 lcl_ReadRGB(rStream, pPalette[i]);
127 }
128
129 static void lcl_ReadValueFormat(SvStream& rStream, Sc10ValueFormat& rFormat)
130 {
131 rStream.ReadUChar( rFormat.Format );
132 rStream.ReadUChar( rFormat.Info );
133 }
134
135 static void lcl_ReadLogFont(SvStream& rStream, Sc10LogFont& rFont)
136 {
137 rStream.ReadInt16( rFont.lfHeight );
138 rStream.ReadInt16( rFont.lfWidth );
139 rStream.ReadInt16( rFont.lfEscapement );
140 rStream.ReadInt16( rFont.lfOrientation );
141 rStream.ReadInt16( rFont.lfWeight );
142 rStream.ReadUChar( rFont.lfItalic );
143 rStream.ReadUChar( rFont.lfUnderline );
144 rStream.ReadUChar( rFont.lfStrikeOut );
145 rStream.ReadUChar( rFont.lfCharSet );
146 rStream.ReadUChar( rFont.lfOutPrecision );
147 rStream.ReadUChar( rFont.lfClipPrecision );
148 rStream.ReadUChar( rFont.lfQuality );
149 rStream.ReadUChar( rFont.lfPitchAndFamily );
150 lcl_ReadFixedString( rStream, &rFont.lfFaceName, sizeof(rFont.lfFaceName));
151 }
152
153 static void lcl_ReadBlockRect(SvStream& rStream, Sc10BlockRect& rBlock)
154 {
155 rStream.ReadInt16( rBlock.x1 );
156 rStream.ReadInt16( rBlock.y1 );
157 rStream.ReadInt16( rBlock.x2 );
158 rStream.ReadInt16( rBlock.y2 );
159 }
160
161 static void lcl_ReadHeadFootLine(SvStream& rStream, Sc10HeadFootLine& rLine)
162 {
163 lcl_ReadFixedString( rStream, &rLine.Title, sizeof(rLine.Title));
164 lcl_ReadLogFont(rStream, rLine.LogFont);
165 rStream.ReadUChar( rLine.HorJustify );
166 rStream.ReadUChar( rLine.VerJustify );
167 rStream.ReadUInt16( rLine.Raster );
168 rStream.ReadUInt16( rLine.Frame );
169 lcl_ReadRGB(rStream, rLine.TextColor);
170 lcl_ReadRGB(rStream, rLine.BackColor);
171 lcl_ReadRGB(rStream, rLine.RasterColor);
172 rStream.ReadUInt16( rLine.FrameColor );
173 rStream.ReadUInt16( rLine.Reserved );
174 }
175
176 static void lcl_ReadPageFormat(SvStream& rStream, Sc10PageFormat& rFormat)
177 {
178 lcl_ReadHeadFootLine(rStream, rFormat.HeadLine);
179 lcl_ReadHeadFootLine(rStream, rFormat.FootLine);
180 rStream.ReadInt16( rFormat.Orientation );
181 rStream.ReadInt16( rFormat.Width );
182 rStream.ReadInt16( rFormat.Height );
183 rStream.ReadInt16( rFormat.NonPrintableX );
184 rStream.ReadInt16( rFormat.NonPrintableY );
185 rStream.ReadInt16( rFormat.Left );
186 rStream.ReadInt16( rFormat.Top );
187 rStream.ReadInt16( rFormat.Right );
188 rStream.ReadInt16( rFormat.Bottom );
189 rStream.ReadInt16( rFormat.Head );
190 rStream.ReadInt16( rFormat.Foot );
191 rStream.ReadUChar( rFormat.HorCenter );
192 rStream.ReadUChar( rFormat.VerCenter );
193 rStream.ReadUChar( rFormat.PrintGrid );
194 rStream.ReadUChar( rFormat.PrintColRow );
195 rStream.ReadUChar( rFormat.PrintNote );
196 rStream.ReadUChar( rFormat.TopBottomDir );
197 lcl_ReadFixedString( rStream, &rFormat.PrintAreaName, sizeof(rFormat.PrintAreaName));
198 lcl_ReadBlockRect(rStream, rFormat.PrintArea);
199 rStream.Read(&rFormat.PrnZoom, sizeof(rFormat.PrnZoom));
200 rStream.ReadInt16( rFormat.FirstPageNo );
201 rStream.ReadInt16( rFormat.RowRepeatStart );
202 rStream.ReadInt16( rFormat.RowRepeatEnd );
203 rStream.ReadInt16( rFormat.ColRepeatStart );
204 rStream.ReadInt16( rFormat.ColRepeatEnd );
205 rStream.Read(&rFormat.Reserved, sizeof(rFormat.Reserved));
206 }
207
208 static void lcl_ReadGraphHeader(SvStream& rStream, Sc10GraphHeader& rHeader)
209 {
210 rStream.ReadUChar( rHeader.Typ );
211 rStream.ReadInt16( rHeader.CarretX );
212 rStream.ReadInt16( rHeader.CarretY );
213 rStream.ReadInt16( rHeader.CarretZ );
214 rStream.ReadInt32( rHeader.x );
215 rStream.ReadInt32( rHeader.y );
216 rStream.ReadInt32( rHeader.w );
217 rStream.ReadInt32( rHeader.h );
218 rStream.ReadUChar( rHeader.IsRelPos );
219 rStream.ReadUChar( rHeader.DoPrint );
220 rStream.ReadUInt16( rHeader.FrameType );
221 rStream.ReadUChar( rHeader.IsTransparent );
222 lcl_ReadRGB(rStream, rHeader.FrameColor);
223 lcl_ReadRGB(rStream, rHeader.BackColor);
224 rStream.Read(&rHeader.Reserved, sizeof(rHeader.Reserved));
225 }
226
227 static void lcl_ReadImageHeaer(SvStream& rStream, Sc10ImageHeader& rHeader)
228 {
229 lcl_ReadFixedString( rStream, &rHeader.FileName, sizeof(rHeader.FileName));
230 rStream.ReadInt16( rHeader.Typ );
231 rStream.ReadUChar( rHeader.Linked );
232 rStream.ReadInt16( rHeader.x1 );
233 rStream.ReadInt16( rHeader.y1 );
234 rStream.ReadInt16( rHeader.x2 );
235 rStream.ReadInt16( rHeader.y2 );
236 rStream.ReadUInt32( rHeader.Size );
237 }
238
239 static void lcl_ReadChartHeader(SvStream& rStream, Sc10ChartHeader& rHeader)
240 {
241 rStream.ReadInt16( rHeader.MM );
242 rStream.ReadInt16( rHeader.xExt );
243 rStream.ReadInt16( rHeader.yExt );
244 rStream.ReadUInt32( rHeader.Size );
245 }
246
247 static void lcl_ReadChartSheetData(SvStream& rStream, Sc10ChartSheetData& rSheetData)
248 {
249 rStream.ReadUChar( rSheetData.HasTitle );
250 rStream.ReadInt16( rSheetData.TitleX );
251 rStream.ReadInt16( rSheetData.TitleY );
252 rStream.ReadUChar( rSheetData.HasSubTitle );
253 rStream.ReadInt16( rSheetData.SubTitleX );
254 rStream.ReadInt16( rSheetData.SubTitleY );
255 rStream.ReadUChar( rSheetData.HasLeftTitle );
256 rStream.ReadInt16( rSheetData.LeftTitleX );
257 rStream.ReadInt16( rSheetData.LeftTitleY );
258 rStream.ReadUChar( rSheetData.HasLegend );
259 rStream.ReadInt16( rSheetData.LegendX1 );
260 rStream.ReadInt16( rSheetData.LegendY1 );
261 rStream.ReadInt16( rSheetData.LegendX2 );
262 rStream.ReadInt16( rSheetData.LegendY2 );
263 rStream.ReadUChar( rSheetData.HasLabel );
264 rStream.ReadInt16( rSheetData.LabelX1 );
265 rStream.ReadInt16( rSheetData.LabelY1 );
266 rStream.ReadInt16( rSheetData.LabelX2 );
267 rStream.ReadInt16( rSheetData.LabelY2 );
268 rStream.ReadInt16( rSheetData.DataX1 );
269 rStream.ReadInt16( rSheetData.DataY1 );
270 rStream.ReadInt16( rSheetData.DataX2 );
271 rStream.ReadInt16( rSheetData.DataY2 );
272 rStream.Read(&rSheetData.Reserved, sizeof(rSheetData.Reserved));
273 }
274
275 static void lcl_ReadChartTypeData(SvStream& rStream, Sc10ChartTypeData& rTypeData)
276 {
277 rStream.ReadInt16( rTypeData.NumSets );
278 rStream.ReadInt16( rTypeData.NumPoints );
279 rStream.ReadInt16( rTypeData.DrawMode );
280 rStream.ReadInt16( rTypeData.GraphType );
281 rStream.ReadInt16( rTypeData.GraphStyle );
282 lcl_ReadFixedString( rStream, &rTypeData.GraphTitle, sizeof(rTypeData.GraphTitle));
283 lcl_ReadFixedString( rStream, &rTypeData.BottomTitle, sizeof(rTypeData.BottomTitle));
284 sal_uInt16 i;
285 for (i = 0; i < 256; i++)
286 rStream.ReadInt16( rTypeData.SymbolData[i] );
287 for (i = 0; i < 256; i++)
288 rStream.ReadInt16( rTypeData.ColorData[i] );
289 for (i = 0; i < 256; i++)
290 rStream.ReadInt16( rTypeData.ThickLines[i] );
291 for (i = 0; i < 256; i++)
292 rStream.ReadInt16( rTypeData.PatternData[i] );
293 for (i = 0; i < 256; i++)
294 rStream.ReadInt16( rTypeData.LinePatternData[i] );
295 for (i = 0; i < 11; i++)
296 rStream.ReadInt16( rTypeData.NumGraphStyles[i] );
297 rStream.ReadInt16( rTypeData.ShowLegend );
298 for (i = 0; i < 256; i++)
299 lcl_ReadFixedString( rStream, &rTypeData.LegendText[i], sizeof(Sc10ChartText));
300 rStream.ReadInt16( rTypeData.ExplodePie );
301 rStream.ReadInt16( rTypeData.FontUse );
302 for (i = 0; i < 5; i++)
303 rStream.ReadInt16( rTypeData.FontFamily[i] );
304 for (i = 0; i < 5; i++)
305 rStream.ReadInt16( rTypeData.FontStyle[i] );
306 for (i = 0; i < 5; i++)
307 rStream.ReadInt16( rTypeData.FontSize[i] );
308 rStream.ReadInt16( rTypeData.GridStyle );
309 rStream.ReadInt16( rTypeData.Labels );
310 rStream.ReadInt16( rTypeData.LabelEvery );
311 for (i = 0; i < 50; i++)
312 lcl_ReadFixedString( rStream, &rTypeData.LabelText[i], sizeof(Sc10ChartText));
313 lcl_ReadFixedString( rStream, &rTypeData.LeftTitle, sizeof(rTypeData.LeftTitle));
314 rStream.Read(&rTypeData.Reserved, sizeof(rTypeData.Reserved));
315 }
316
317 static double lcl_PascalToDouble(sal_Char* tp6)
318 {
319 sal_uInt8* pnUnsigned = reinterpret_cast< sal_uInt8* >( tp6 );
320 // biased exponent
321 sal_uInt8 be = pnUnsigned[ 0 ];
322 // lower 16 bits of mantissa
323 sal_uInt16 v1 = static_cast< sal_uInt16 >( pnUnsigned[ 2 ] * 256 + pnUnsigned[ 1 ] );
324 // next 16 bits of mantissa
325 sal_uInt16 v2 = static_cast< sal_uInt16 >( pnUnsigned[ 4 ] * 256 + pnUnsigned[ 3 ] );
326 // upper 7 bits of mantissa
327 sal_uInt8 v3 = static_cast< sal_uInt8 >( pnUnsigned[ 5 ] & 0x7F );
328 // sign bit
329 bool s = (pnUnsigned[ 5 ] & 0x80) != 0;
330
331 if (be == 0)
332 return 0.0;
333 return (((((128 + v3) * 65536.0) + v2) * 65536.0 + v1) *
334 ldexp ((s ? -1.0 : 1.0), be - (129+39)));
335 }
336
337 static void lcl_ChangeColor( sal_uInt16 nIndex, Color& rColor )
338 {
339 ColorData aCol;
340
341 switch( nIndex )
342 {
343 case 1: aCol = COL_RED; break;
344 case 2: aCol = COL_GREEN; break;
345 case 3: aCol = COL_BROWN; break;
346 case 4: aCol = COL_BLUE; break;
347 case 5: aCol = COL_MAGENTA; break;
348 case 6: aCol = COL_CYAN; break;
349 case 7: aCol = COL_GRAY; break;
350 case 8: aCol = COL_LIGHTGRAY; break;
351 case 9: aCol = COL_LIGHTRED; break;
352 case 10: aCol = COL_LIGHTGREEN; break;
353 case 11: aCol = COL_YELLOW; break;
354 case 12: aCol = COL_LIGHTBLUE; break;
355 case 13: aCol = COL_LIGHTMAGENTA; break;
356 case 14: aCol = COL_LIGHTCYAN; break;
357 case 15: aCol = COL_WHITE; break;
358 default: aCol = COL_BLACK;
359 }
360
361 rColor.SetColor( aCol );
362 }
363
364 static OUString lcl_MakeOldPageStyleFormatName( sal_uInt16 i )
365 {
366 OUString aName = ScGlobal::GetRscString( STR_PAGESTYLE ) + " " + OUString::number( i + 1 );
367 return aName;
368 }
369
370 template < typename T > sal_uLong insert_new( ScCollection* pCollection, SvStream& rStream )
371 {
372 std::unique_ptr<T> pData(new (::std::nothrow) T( rStream));
373 sal_uLong nError = rStream.GetError();
374 if (pData)
375 {
376 if (!nError)
377 pCollection->Insert( pData.release() );
378 }
379 else
380 nError = errOutOfMemory;
381 return nError;
382 }
383
384 // Font
385
386 Sc10FontData::Sc10FontData(SvStream& rStream)
387 : Height(0)
388 , CharSet(0)
389 , PitchAndFamily(0)
390 {
391 rStream.ReadInt16( Height );
392 rStream.ReadUChar( CharSet );
393 rStream.ReadUChar( PitchAndFamily );
394 sal_uInt16 nLen(0);
395 rStream.ReadUInt16( nLen );
396 if (nLen < sizeof(FaceName))
397 rStream.Read(FaceName, nLen);
398 else
399 rStream.SetError(ERRCODE_IO_WRONGFORMAT);
400 }
401
402 Sc10FontCollection::Sc10FontCollection(SvStream& rStream)
403 : ScCollection(4, 4)
404 , nError(0)
405 {
406 sal_uInt16 ID(0);
407 rStream.ReadUInt16( ID );
408 if (ID == FontID)
409 {
410 sal_uInt16 nAnz(0);
411 rStream.ReadUInt16( nAnz );
412 for (sal_uInt16 i=0; (i < nAnz) && (nError == 0); i++)
413 {
414 nError = insert_new<Sc10FontData>( this, rStream);
415 }
416 }
417 else
418 {
419 OSL_FAIL( "FontID" );
420 nError = errUnknownID;
421 }
422 }
423
424 // named regions
425
426 Sc10NameData::Sc10NameData(SvStream& rStream)
427 {
428 sal_uInt8 nLen;
429 rStream.ReadUChar( nLen );
430 rStream.Read(Name, sizeof(Name) - 1);
431 if (nLen >= sizeof(Name))
432 nLen = sizeof(Name) - 1;
433 Name[nLen] = 0;
434
435 rStream.ReadUChar( nLen );
436 rStream.Read(Reference, sizeof(Reference) - 1);
437 if (nLen >= sizeof(Reference))
438 nLen = sizeof(Reference) - 1;
439 Reference[nLen] = 0;
440 rStream.Read(Reserved, sizeof(Reserved));
441 }
442
443 Sc10NameCollection::Sc10NameCollection(SvStream& rStream) :
444 ScCollection (4, 4),
445 nError (0)
446 {
447 sal_uInt16 ID;
448 rStream.ReadUInt16( ID );
449 if (ID == NameID)
450 {
451 sal_uInt16 nAnz;
452 rStream.ReadUInt16( nAnz );
453 for (sal_uInt16 i=0; (i < nAnz) && (nError == 0); i++)
454 {
455 nError = insert_new<Sc10NameData>( this, rStream);
456 }
457 }
458 else
459 {
460 OSL_FAIL( "NameID" );
461 nError = errUnknownID;
462 }
463 }
464
465 // templates
466 Sc10PatternData::Sc10PatternData(SvStream& rStream)
467 : Attr(0)
468 , Justify(0)
469 , Frame(0)
470 , Raster(0)
471 , nColor(0)
472 , FrameColor(0)
473 , Flags(0)
474 , FormatFlags(0)
475 {
476 memset(Name, 0, sizeof(Name));
477 memset(Reserved, 0, sizeof(Reserved));
478 lcl_ReadFixedString( rStream, Name, sizeof(Name));
479 lcl_ReadValueFormat(rStream, ValueFormat);
480 lcl_ReadLogFont(rStream, LogFont);
481
482 rStream.ReadUInt16( Attr );
483 rStream.ReadUInt16( Justify );
484 rStream.ReadUInt16( Frame );
485 rStream.ReadUInt16( Raster );
486 rStream.ReadUInt16( nColor );
487 rStream.ReadUInt16( FrameColor );
488 rStream.ReadUInt16( Flags );
489 rStream.ReadUInt16( FormatFlags );
490 rStream.Read(Reserved, sizeof(Reserved));
491 }
492
493 Sc10PatternCollection::Sc10PatternCollection(SvStream& rStream)
494 : ScCollection(4, 4)
495 , nError(0)
496 {
497 sal_uInt16 ID;
498 rStream.ReadUInt16( ID );
499 if (ID == PatternID)
500 {
501 sal_uInt16 nAnz;
502 rStream.ReadUInt16( nAnz );
503 for (sal_uInt16 i=0; (i < nAnz) && (nError == 0); i++)
504 {
505 nError = insert_new<Sc10PatternData>( this, rStream);
506 }
507 }
508 else
509 {
510 OSL_FAIL( "PatternID" );
511 nError = errUnknownID;
512 }
513 }
514
515 // database
516
517 Sc10DataBaseData::Sc10DataBaseData(SvStream& rStream)
518 {
519 lcl_ReadFixedString( rStream, &DataBaseRec.Name, sizeof(DataBaseRec.Name));
520 rStream.ReadInt16( DataBaseRec.Tab );
521 lcl_ReadBlockRect(rStream, DataBaseRec.Block);
522 rStream.ReadUChar( DataBaseRec.RowHeader );
523 rStream.ReadInt16( DataBaseRec.SortField0 );
524 rStream.ReadUChar( DataBaseRec.SortUpOrder0 );
525 rStream.ReadInt16( DataBaseRec.SortField1 );
526 rStream.ReadUChar( DataBaseRec.SortUpOrder1 );
527 rStream.ReadInt16( DataBaseRec.SortField2 );
528 rStream.ReadUChar( DataBaseRec.SortUpOrder2 );
529 rStream.ReadUChar( DataBaseRec.IncludeFormat );
530
531 rStream.ReadInt16( DataBaseRec.QueryField0 );
532 rStream.ReadInt16( DataBaseRec.QueryOp0 );
533 rStream.ReadUChar( DataBaseRec.QueryByString0 );
534 lcl_ReadFixedString( rStream, &DataBaseRec.QueryString0, sizeof(DataBaseRec.QueryString0));
535 DataBaseRec.QueryValue0 = ScfTools::ReadLongDouble(rStream);
536
537 rStream.ReadInt16( DataBaseRec.QueryConnect1 );
538 rStream.ReadInt16( DataBaseRec.QueryField1 );
539 rStream.ReadInt16( DataBaseRec.QueryOp1 );
540 rStream.ReadUChar( DataBaseRec.QueryByString1 );
541 lcl_ReadFixedString( rStream, &DataBaseRec.QueryString1, sizeof(DataBaseRec.QueryString1));
542 DataBaseRec.QueryValue1 = ScfTools::ReadLongDouble(rStream);
543
544 rStream.ReadInt16( DataBaseRec.QueryConnect2 );
545 rStream.ReadInt16( DataBaseRec.QueryField2 );
546 rStream.ReadInt16( DataBaseRec.QueryOp2 );
547 rStream.ReadUChar( DataBaseRec.QueryByString2 );
548 lcl_ReadFixedString( rStream, &DataBaseRec.QueryString2, sizeof(DataBaseRec.QueryString2));
549 DataBaseRec.QueryValue2 = ScfTools::ReadLongDouble(rStream);
550 }
551
552 Sc10DataBaseCollection::Sc10DataBaseCollection(SvStream& rStream)
553 : ScCollection(4, 4)
554 , nError(0)
555 {
556 sal_uInt16 ID;
557 rStream.ReadUInt16( ID );
558 if (ID == DataBaseID)
559 {
560 lcl_ReadFixedString( rStream, ActName, sizeof(ActName));
561 sal_uInt16 nAnz;
562 rStream.ReadUInt16( nAnz );
563 for (sal_uInt16 i=0; (i < nAnz) && (nError == 0); i++)
564 {
565 nError = insert_new<Sc10DataBaseData>( this, rStream);
566 }
567 }
568 else
569 {
570 OSL_FAIL( "DataBaseID" );
571 nError = errUnknownID;
572 }
573 }
574
575 bool Sc10LogFont::operator==( const Sc10LogFont& rData ) const
576 {
577 return !strcmp( lfFaceName, rData.lfFaceName )
578 && lfHeight == rData.lfHeight
579 && lfWidth == rData.lfWidth
580 && lfEscapement == rData.lfEscapement
581 && lfOrientation == rData.lfOrientation
582 && lfWeight == rData.lfWeight
583 && lfItalic == rData.lfItalic
584 && lfUnderline == rData.lfUnderline
585 && lfStrikeOut == rData.lfStrikeOut
586 && lfCharSet == rData.lfCharSet
587 && lfOutPrecision == rData.lfOutPrecision
588 && lfClipPrecision == rData.lfClipPrecision
589 && lfQuality == rData.lfQuality
590 && lfPitchAndFamily == rData.lfPitchAndFamily;
591 }
592
593 bool Sc10Color::operator==( const Sc10Color& rColor ) const
594 {
595 return ((Red == rColor.Red) && (Green == rColor.Green) && (Blue == rColor.Blue));
596 }
597
598 bool Sc10HeadFootLine::operator==( const Sc10HeadFootLine& rData ) const
599 {
600 return !strcmp(Title, rData.Title)
601 && LogFont == rData.LogFont
602 && HorJustify == rData.HorJustify
603 && VerJustify == rData.VerJustify
604 && Raster == rData.Raster
605 && Frame == rData.Frame
606 && TextColor == rData.TextColor
607 && BackColor == rData.BackColor
608 && RasterColor == rData.RasterColor
609 && FrameColor == rData.FrameColor
610 && Reserved == rData.Reserved;
611 }
612
613 bool Sc10PageFormat::operator==( const Sc10PageFormat& rData ) const
614 {
615 return !strcmp(PrintAreaName, rData.PrintAreaName)
616 && HeadLine == rData.HeadLine
617 && FootLine == rData.FootLine
618 && Orientation == rData.Orientation
619 && Width == rData.Width
620 && Height == rData.Height
621 && NonPrintableX == rData.NonPrintableX
622 && NonPrintableY == rData.NonPrintableY
623 && Left == rData.Left
624 && Top == rData.Top
625 && Right == rData.Right
626 && Bottom == rData.Bottom
627 && Head == rData.Head
628 && Foot == rData.Foot
629 && HorCenter == rData.HorCenter
630 && VerCenter == rData.VerCenter
631 && PrintGrid == rData.PrintGrid
632 && PrintColRow == rData.PrintColRow
633 && PrintNote == rData.PrintNote
634 && TopBottomDir == rData.TopBottomDir
635 && FirstPageNo == rData.FirstPageNo
636 && RowRepeatStart == rData.RowRepeatStart
637 && RowRepeatEnd == rData.RowRepeatEnd
638 && ColRepeatStart == rData.ColRepeatStart
639 && ColRepeatEnd == rData.ColRepeatEnd
640 && !memcmp( PrnZoom, rData.PrnZoom, sizeof(PrnZoom) )
641 && !memcmp( &PrintArea, &rData.PrintArea, sizeof(PrintArea) );
642 }
643
644 sal_uInt16 Sc10PageCollection::InsertFormat( const Sc10PageFormat& rData )
645 {
646 for (sal_uInt16 i=0; i<nCount; i++)
647 if (At(i)->aPageFormat == rData)
648 return i;
649
650 Insert( new Sc10PageData(rData) );
651
652 return nCount-1;
653 }
654
655 static inline sal_uInt8 GetMixedCol( const sal_uInt8 nB, const sal_uInt8 nF, const sal_uInt16 nFak )
656 {
657 sal_Int32 nT = nB - nF;
658 nT *= ( sal_Int32 ) nFak;
659 nT /= 0xFFFF;
660 nT += nF;
661 return ( sal_uInt8 ) nT;
662 }
663 static inline Color GetMixedColor( const Color& rFore, const Color& rBack, sal_uInt16 nFact )
664 {
665 return Color( GetMixedCol( rBack.GetRed(), rFore.GetRed(), nFact ),
666 GetMixedCol( rBack.GetGreen(), rFore.GetGreen(), nFact ),
667 GetMixedCol( rBack.GetBlue(), rFore.GetBlue(), nFact ) );
668 }
669
670 void Sc10PageCollection::PutToDoc( ScDocument* pDoc )
671 {
672 ScStyleSheetPool* pStylePool = pDoc->GetStyleSheetPool();
673 EditEngine aEditEngine( pDoc->GetEnginePool() );
674 EditTextObject* pEmptyObject = aEditEngine.CreateTextObject();
675
676 for (sal_uInt16 i=0; i<nCount; i++)
677 {
678 Sc10PageFormat* pPage = &At(i)->aPageFormat;
679
680 pPage->Width = (short) ( pPage->Width + 0.5 );
681 pPage->Height = (short) ( pPage->Height + 0.5 );
682 pPage->Top = (short) ( pPage->Top + 0.5 );
683 pPage->Bottom = (short) ( pPage->Bottom + 0.5 );
684 pPage->Left = (short) ( pPage->Left + 0.5 );
685 pPage->Right = (short) ( pPage->Right + 0.5 );
686 pPage->Head = (short) ( pPage->Head + 0.5 );
687 pPage->Foot = (short) ( pPage->Foot + 0.5 );
688
689 OUString aName = lcl_MakeOldPageStyleFormatName( i );
690
691 ScStyleSheet* pSheet = static_cast<ScStyleSheet*>( &pStylePool->Make( aName,
692 SfxStyleFamily::Page,
693 SFXSTYLEBIT_USERDEF | SCSTYLEBIT_STANDARD ) );
694 // #i68483# set page style name at sheet...
695 pDoc->SetPageStyle( static_cast< SCTAB >( i ), aName );
696
697 SfxItemSet* pSet = &pSheet->GetItemSet();
698
699 for (sal_uInt16 nHeadFoot=0; nHeadFoot<2; nHeadFoot++)
700 {
701 Sc10HeadFootLine* pHeadFootLine = nHeadFoot ? &pPage->FootLine : &pPage->HeadLine;
702
703 SfxItemSet aEditAttribs(aEditEngine.GetEmptyItemSet());
704 FontFamily eFam = FAMILY_DONTKNOW;
705 switch (pPage->HeadLine.LogFont.lfPitchAndFamily & 0xF0)
706 {
707 case ffDontCare: eFam = FAMILY_DONTKNOW; break;
708 case ffRoman: eFam = FAMILY_ROMAN; break;
709 case ffSwiss: eFam = FAMILY_SWISS; break;
710 case ffModern: eFam = FAMILY_MODERN; break;
711 case ffScript: eFam = FAMILY_SCRIPT; break;
712 case ffDecorative: eFam = FAMILY_DECORATIVE; break;
713 default: eFam = FAMILY_DONTKNOW; break;
714 }
715 aEditAttribs.Put( SvxFontItem(
716 eFam,
717 SC10TOSTRING( pHeadFootLine->LogFont.lfFaceName ), EMPTY_OUSTRING,
718 PITCH_DONTKNOW, RTL_TEXTENCODING_DONTKNOW, EE_CHAR_FONTINFO ),
719 EE_CHAR_FONTINFO );
720 aEditAttribs.Put( SvxFontHeightItem( std::abs( pHeadFootLine->LogFont.lfHeight ), 100, EE_CHAR_FONTHEIGHT ),
721 EE_CHAR_FONTHEIGHT);
722
723 Sc10Color nColor = pHeadFootLine->TextColor;
724 Color TextColor( nColor.Red, nColor.Green, nColor.Blue );
725 aEditAttribs.Put(SvxColorItem(TextColor, EE_CHAR_COLOR), EE_CHAR_COLOR);
726 // FontAttr
727 if (pHeadFootLine->LogFont.lfWeight != fwNormal)
728 aEditAttribs.Put(SvxWeightItem(WEIGHT_BOLD, EE_CHAR_WEIGHT), EE_CHAR_WEIGHT);
729 if (pHeadFootLine->LogFont.lfItalic != 0)
730 aEditAttribs.Put(SvxPostureItem(ITALIC_NORMAL, EE_CHAR_ITALIC), EE_CHAR_ITALIC);
731 if (pHeadFootLine->LogFont.lfUnderline != 0)
732 aEditAttribs.Put(SvxUnderlineItem(LINESTYLE_SINGLE, EE_CHAR_UNDERLINE), EE_CHAR_UNDERLINE);
733 if (pHeadFootLine->LogFont.lfStrikeOut != 0)
734 aEditAttribs.Put(SvxCrossedOutItem(STRIKEOUT_SINGLE, EE_CHAR_STRIKEOUT), EE_CHAR_STRIKEOUT);
735 OUString aText( pHeadFootLine->Title, strlen(pHeadFootLine->Title), DEFCHARSET );
736 aEditEngine.SetText( aText );
737 aEditEngine.QuickSetAttribs( aEditAttribs, ESelection( 0, 0, 0, aText.getLength() ) );
738
739 EditTextObject* pObject = aEditEngine.CreateTextObject();
740 ScPageHFItem aHeaderItem(nHeadFoot ? ATTR_PAGE_FOOTERRIGHT : ATTR_PAGE_HEADERRIGHT);
741 switch (pHeadFootLine->HorJustify)
742 {
743 case hjCenter:
744 aHeaderItem.SetLeftArea(*pEmptyObject);
745 aHeaderItem.SetCenterArea(*pObject);
746 aHeaderItem.SetRightArea(*pEmptyObject);
747 break;
748 case hjRight:
749 aHeaderItem.SetLeftArea(*pEmptyObject);
750 aHeaderItem.SetCenterArea(*pEmptyObject);
751 aHeaderItem.SetRightArea(*pObject);
752 break;
753 default:
754 aHeaderItem.SetLeftArea(*pObject);
755 aHeaderItem.SetCenterArea(*pEmptyObject);
756 aHeaderItem.SetRightArea(*pEmptyObject);
757 break;
758 }
759 delete pObject;
760 pSet->Put( aHeaderItem );
761
762 SfxItemSet aSetItemItemSet( *pDoc->GetPool(),
763 ATTR_BACKGROUND, ATTR_BACKGROUND,
764 ATTR_BORDER, ATTR_SHADOW,
765 ATTR_PAGE_SIZE, ATTR_PAGE_SIZE,
766 ATTR_LRSPACE, ATTR_ULSPACE,
767 ATTR_PAGE_ON, ATTR_PAGE_SHARED,
768 0 );
769 nColor = pHeadFootLine->BackColor;
770 Color aBColor( nColor.Red, nColor.Green, nColor.Blue );
771 nColor = pHeadFootLine->RasterColor;
772 Color aRColor( nColor.Red, nColor.Green, nColor.Blue );
773
774 sal_uInt16 nFact;
775 bool bSwapCol = false;
776 switch (pHeadFootLine->Raster)
777 {
778 case raNone: nFact = 0xffff; bSwapCol = true; break;
779 case raGray12: nFact = (0xffff / 100) * 12; break;
780 case raGray25: nFact = (0xffff / 100) * 25; break;
781 case raGray50: nFact = (0xffff / 100) * 50; break;
782 case raGray75: nFact = (0xffff / 100) * 75; break;
783 default: nFact = 0xffff;
784 }
785 if( bSwapCol )
786 aSetItemItemSet.Put( SvxBrushItem( GetMixedColor( aBColor, aRColor, nFact ), ATTR_BACKGROUND ) );
787 else
788 aSetItemItemSet.Put( SvxBrushItem( GetMixedColor( aRColor, aBColor, nFact ), ATTR_BACKGROUND ) );
789
790 if (pHeadFootLine->Frame != 0)
791 {
792 sal_uInt16 nLeft = 0;
793 sal_uInt16 nTop = 0;
794 sal_uInt16 nRight = 0;
795 sal_uInt16 nBottom = 0;
796 sal_uInt16 fLeft = (pHeadFootLine->Frame & 0x000F);
797 sal_uInt16 fTop = (pHeadFootLine->Frame & 0x00F0) / 0x0010;
798 sal_uInt16 fRight = (pHeadFootLine->Frame & 0x0F00) / 0x0100;
799 sal_uInt16 fBottom = (pHeadFootLine->Frame & 0xF000) / 0x1000;
800 if (fLeft > 1)
801 nLeft = 50;
802 else if (fLeft > 0)
803 nLeft = 20;
804 if (fTop > 1)
805 nTop = 50;
806 else if (fTop > 0)
807 nTop = 20;
808 if (fRight > 1)
809 nRight = 50;
810 else if (fRight > 0)
811 nRight = 20;
812 if (fBottom > 1)
813 nBottom = 50;
814 else if (fBottom > 0)
815 nBottom = 20;
816 Color ColorLeft(COL_BLACK);
817 Color ColorTop(COL_BLACK);
818 Color ColorRight(COL_BLACK);
819 Color ColorBottom(COL_BLACK);
820 sal_uInt16 cLeft = (pHeadFootLine->FrameColor & 0x000F);
821 sal_uInt16 cTop = (pHeadFootLine->FrameColor & 0x00F0) >> 4;
822 sal_uInt16 cRight = (pHeadFootLine->FrameColor & 0x0F00) >> 8;
823 sal_uInt16 cBottom = (pHeadFootLine->FrameColor & 0xF000) >> 12;
824 lcl_ChangeColor(cLeft, ColorLeft);
825 lcl_ChangeColor(cTop, ColorTop);
826 lcl_ChangeColor(cRight, ColorRight);
827 lcl_ChangeColor(cBottom, ColorBottom);
828 ::editeng::SvxBorderLine aLine;
829 SvxBoxItem aBox( ATTR_BORDER );
830 aLine.SetWidth(nLeft);
831 aLine.SetColor(ColorLeft);
832 aBox.SetLine(&aLine, SvxBoxItemLine::LEFT);
833 aLine.SetWidth(nTop);
834 aLine.SetColor(ColorTop);
835 aBox.SetLine(&aLine, SvxBoxItemLine::TOP);
836 aLine.SetWidth(nRight);
837 aLine.SetColor(ColorRight);
838 aBox.SetLine(&aLine, SvxBoxItemLine::RIGHT);
839 aLine.SetWidth(nBottom);
840 aLine.SetColor(ColorBottom);
841 aBox.SetLine(&aLine, SvxBoxItemLine::BOTTOM);
842
843 aSetItemItemSet.Put(aBox);
844 }
845
846 pSet->Put( SvxULSpaceItem( 0, 0, ATTR_ULSPACE ) );
847
848 if (nHeadFoot==0)
849 aSetItemItemSet.Put( SvxSizeItem( ATTR_PAGE_SIZE, Size( 0, pPage->Top - pPage->Head ) ) );
850 else
851 aSetItemItemSet.Put( SvxSizeItem( ATTR_PAGE_SIZE, Size( 0, pPage->Bottom - pPage->Foot ) ) );
852
853 aSetItemItemSet.Put(SfxBoolItem( ATTR_PAGE_ON, true ));
854 aSetItemItemSet.Put(SfxBoolItem( ATTR_PAGE_DYNAMIC, false ));
855 aSetItemItemSet.Put(SfxBoolItem( ATTR_PAGE_SHARED, true ));
856
857 pSet->Put( SvxSetItem( nHeadFoot ? ATTR_PAGE_FOOTERSET : ATTR_PAGE_HEADERSET,
858 aSetItemItemSet ) );
859 }
860
861 SvxPageItem aPageItem(ATTR_PAGE);
862 aPageItem.SetPageUsage( SVX_PAGE_ALL );
863 aPageItem.SetLandscape( pPage->Orientation != 1 );
864 aPageItem.SetNumType( SVX_ARABIC );
865 pSet->Put(aPageItem);
866
867 pSet->Put(SvxLRSpaceItem( pPage->Left, pPage->Right, 0,0, ATTR_LRSPACE ));
868 pSet->Put(SvxULSpaceItem( pPage->Top, pPage->Bottom, ATTR_ULSPACE ));
869
870 pSet->Put(SfxBoolItem( ATTR_PAGE_HORCENTER, pPage->HorCenter ));
871 pSet->Put(SfxBoolItem( ATTR_PAGE_VERCENTER, pPage->VerCenter ));
872
873 // Area-Parameter:
874
875 {
876 ScRange* pRepeatRow = nullptr;
877 ScRange* pRepeatCol = nullptr;
878
879 if ( pPage->ColRepeatStart >= 0 )
880 pRepeatCol = new ScRange( static_cast<SCCOL> (pPage->ColRepeatStart), 0, 0 );
881 if ( pPage->RowRepeatStart >= 0 )
882 pRepeatRow = new ScRange( 0, static_cast<SCROW> (pPage->RowRepeatStart), 0 );
883
884 if ( pRepeatRow || pRepeatCol )
885 {
886
887 // set for all tables
888
889 for ( SCTAB nTab = 0, nTabCount = pDoc->GetTableCount(); nTab < nTabCount; ++nTab )
890 {
891 pDoc->SetRepeatColRange( nTab, pRepeatCol );
892 pDoc->SetRepeatRowRange( nTab, pRepeatRow );
893 }
894 }
895
896 delete pRepeatRow;
897 delete pRepeatCol;
898 }
899
900 // Table-Parameter:
901
902 pSet->Put( SfxBoolItem( ATTR_PAGE_NOTES, pPage->PrintNote ) );
903 pSet->Put( SfxBoolItem( ATTR_PAGE_GRID, pPage->PrintGrid ) );
904 pSet->Put( SfxBoolItem( ATTR_PAGE_HEADERS, pPage->PrintColRow ) );
905 pSet->Put( SfxBoolItem( ATTR_PAGE_TOPDOWN, pPage->TopBottomDir ) );
906 pSet->Put( ScViewObjectModeItem( ATTR_PAGE_CHARTS, VOBJ_MODE_SHOW ) );
907 pSet->Put( ScViewObjectModeItem( ATTR_PAGE_OBJECTS, VOBJ_MODE_SHOW ) );
908 pSet->Put( ScViewObjectModeItem( ATTR_PAGE_DRAWINGS, VOBJ_MODE_SHOW ) );
909 pSet->Put( SfxUInt16Item( ATTR_PAGE_SCALE,
910 (sal_uInt16)( lcl_PascalToDouble( pPage->PrnZoom ) * 100 ) ) );
911 pSet->Put( SfxUInt16Item( ATTR_PAGE_FIRSTPAGENO, 1 ) );
912
913 pSet->Put( SvxSizeItem( ATTR_PAGE_SIZE, Size( pPage->Width, pPage->Height ) ) );
914 }
915
916 delete pEmptyObject;
917 }
918
919 ScDataObject* Sc10PageData::Clone() const
920 {
921 return new Sc10PageData(aPageFormat);
922 }
923
924 // Import
925
926 Sc10Import::Sc10Import(SvStream& rStr, ScDocument* pDocument ) :
927 rStream (rStr),
928 pDoc (pDocument),
929 pFontCollection (nullptr),
930 pNameCollection (nullptr),
931 pPatternCollection (nullptr),
932 pDataBaseCollection (nullptr),
933 nError (0),
934 nShowTab (0)
935 {
936 pPrgrsBar = nullptr;
937 }
938
939 Sc10Import::~Sc10Import()
940 {
941 pDoc->CalcAfterLoad();
942 pDoc->UpdateAllCharts();
943
944 delete pFontCollection;
945 delete pNameCollection;
946 delete pPatternCollection;
947 delete pDataBaseCollection;
948
949 OSL_ENSURE( pPrgrsBar == nullptr,
950 "*Sc10Import::Sc10Import(): Progressbar lebt noch!?" );
951 }
952
953 sal_uLong Sc10Import::Import()
954 {
955 pPrgrsBar = new ScfStreamProgressBar( rStream, pDoc->GetDocumentShell() );
956
957 ScDocOptions aOpt = pDoc->GetDocOptions();
958 aOpt.SetDate( 1, 1, 1900 );
959 aOpt.SetYear2000( 18 + 1901 ); // 4-digit since SO51 src513e
960 pDoc->SetDocOptions( aOpt );
961 pDoc->GetFormatTable()->ChangeNullDate( 1, 1, 1900 );
962
963 LoadFileHeader(); pPrgrsBar->Progress();
964 if (!nError) { LoadFileInfo(); pPrgrsBar->Progress(); }
965 if (!nError) { LoadEditStateInfo(); pPrgrsBar->Progress(); }
966 if (!nError) { LoadProtect(); pPrgrsBar->Progress(); }
967 if (!nError) { LoadViewColRowBar(); pPrgrsBar->Progress(); }
968 if (!nError) { LoadScrZoom(); pPrgrsBar->Progress(); }
969 if (!nError) { LoadPalette(); pPrgrsBar->Progress(); }
970 if (!nError) { LoadFontCollection(); pPrgrsBar->Progress(); }
971 if (!nError) { LoadNameCollection(); pPrgrsBar->Progress(); }
972 if (!nError) { LoadPatternCollection(); pPrgrsBar->Progress(); }
973 if (!nError) { LoadDataBaseCollection(); pPrgrsBar->Progress(); }
974 if (!nError) { LoadTables(); pPrgrsBar->Progress(); }
975 if (!nError) { LoadObjects(); pPrgrsBar->Progress(); }
976 if (!nError) { ImportNameCollection(); pPrgrsBar->Progress(); }
977 pDoc->SetViewOptions( aSc30ViewOpt );
978
979 #if OSL_DEBUG_LEVEL > 0
980 if (nError)
981 {
982 OSL_FAIL( OString::number(nError).getStr());
983 }
984 #endif
985
986 delete pPrgrsBar;
987 #if OSL_DEBUG_LEVEL > 0
988 pPrgrsBar = nullptr;
989 #endif
990
991 return nError;
992 }
993
994 void Sc10Import::LoadFileHeader()
995 {
996 Sc10FileHeader FileHeader;
997 lcl_ReadFileHeader(rStream, FileHeader);
998
999 nError = rStream.GetError();
1000 if ( nError == 0 )
1001 {
1002 sal_Char Sc10CopyRight[32];
1003 strcpy(Sc10CopyRight, "Blaise-Tabelle");
1004 Sc10CopyRight[14] = 10;
1005 Sc10CopyRight[15] = 13;
1006 Sc10CopyRight[16] = 0;
1007 if ((strcmp(FileHeader.CopyRight, Sc10CopyRight) != 0)
1008 || (FileHeader.Version < 101)
1009 || (FileHeader.Version > 102))
1010 nError = errUnknownFormat;
1011 }
1012 }
1013
1014 void Sc10Import::LoadFileInfo()
1015 {
1016 Sc10FileInfo FileInfo;
1017 rStream.Read(&FileInfo, sizeof(FileInfo));
1018
1019 nError = rStream.GetError();
1020 // TODO: ? copy info
1021 }
1022
1023 void Sc10Import::LoadEditStateInfo()
1024 {
1025 Sc10EditStateInfo EditStateInfo;
1026
1027 #if !defined(NDEBUG)
1028 sal_uInt64 const nOldPos(rStream.Tell());
1029 #endif
1030
1031 rStream.ReadUInt16(EditStateInfo.CarretX);
1032 rStream.ReadUInt16(EditStateInfo.CarretY);
1033 rStream.ReadUInt16(EditStateInfo.CarretZ);
1034 rStream.ReadUInt16(EditStateInfo.DeltaX);
1035 rStream.ReadUInt16(EditStateInfo.DeltaY);
1036 rStream.ReadUInt16(EditStateInfo.DeltaZ);
1037 rStream.ReadUChar(EditStateInfo.DataBaseMode);
1038 rStream.Read(EditStateInfo.Reserved, sizeof(EditStateInfo.Reserved));
1039
1040 assert(rStream.GetError() || rStream.Tell() == nOldPos + sizeof(Sc10EditStateInfo));
1041
1042 nError = rStream.GetError();
1043 nShowTab = static_cast<SCTAB>(EditStateInfo.DeltaZ);
1044 // TODO: ? copy cursor position and offset of the table (shall we do that??)
1045
1046 }
1047
1048 void Sc10Import::LoadProtect()
1049 {
1050 lcl_ReadSheetProtect(rStream, SheetProtect);
1051 nError = rStream.GetError();
1052
1053 ScDocProtection aProtection;
1054 aProtection.setProtected(static_cast<bool>(SheetProtect.Protect));
1055 aProtection.setPassword(SC10TOSTRING(SheetProtect.PassWord));
1056 pDoc->SetDocProtection(&aProtection);
1057 }
1058
1059 void Sc10Import::LoadViewColRowBar()
1060 {
1061 bool bViewColRowBar;
1062 rStream.ReadCharAsBool( bViewColRowBar );
1063 nError = rStream.GetError();
1064 aSc30ViewOpt.SetOption( VOPT_HEADER, bViewColRowBar );
1065 }
1066
1067 void Sc10Import::LoadScrZoom()
1068 {
1069 // TODO: unfortunately Zoom is a 6-byte TP real number (don't know how to translate that)
1070 sal_Char cZoom[6];
1071 rStream.Read(cZoom, sizeof(cZoom));
1072 nError = rStream.GetError();
1073 }
1074
1075 void Sc10Import::LoadPalette()
1076 {
1077 lcl_ReadPalette(rStream, TextPalette);
1078 lcl_ReadPalette(rStream, BackPalette);
1079 lcl_ReadPalette(rStream, RasterPalette);
1080 lcl_ReadPalette(rStream, FramePalette);
1081
1082 nError = rStream.GetError();
1083 }
1084
1085 void Sc10Import::LoadFontCollection()
1086 {
1087 pFontCollection = new Sc10FontCollection(rStream);
1088 if (!nError)
1089 nError = pFontCollection->GetError();
1090 }
1091
1092 void Sc10Import::LoadNameCollection()
1093 {
1094 pNameCollection = new Sc10NameCollection(rStream);
1095 if (!nError)
1096 nError = pNameCollection->GetError();
1097 }
1098
1099 void Sc10Import::ImportNameCollection()
1100 {
1101 ScRangeName* pRN = pDoc->GetRangeName();
1102
1103 for (sal_uInt16 i = 0; i < pNameCollection->GetCount(); i++)
1104 {
1105 Sc10NameData* pName = pNameCollection->At( i );
1106 pRN->insert(
1107 new ScRangeData(
1108 pDoc, SC10TOSTRING(pName->Name), SC10TOSTRING(pName->Reference)));
1109 }
1110 }
1111
1112 void Sc10Import::LoadPatternCollection()
1113 {
1114 pPatternCollection = new Sc10PatternCollection( rStream );
1115 if (!nError)
1116 nError = pPatternCollection->GetError();
1117 if (nError == errOutOfMemory)
1118 return; // hopeless
1119 ScStyleSheetPool* pStylePool = pDoc->GetStyleSheetPool();
1120 for( sal_uInt16 i = 0 ; i < pPatternCollection->GetCount() ; i++ )
1121 {
1122 Sc10PatternData* pPattern = pPatternCollection->At( i );
1123 OUString aName( pPattern->Name, strlen(pPattern->Name), DEFCHARSET );
1124 SfxStyleSheetBase* pStyle = pStylePool->Find( aName, SfxStyleFamily::Para );
1125 if( pStyle == nullptr )
1126 pStylePool->Make( aName, SfxStyleFamily::Para );
1127 else
1128 {
1129 pPattern->Name[ 27 ] = 0;
1130 strcat( pPattern->Name, "_Old" );
1131 aName = SC10TOSTRING( pPattern->Name );
1132 pStylePool->Make( aName, SfxStyleFamily::Para );
1133 }
1134 pStyle = pStylePool->Find( aName, SfxStyleFamily::Para );
1135 if( pStyle != nullptr )
1136 {
1137 SfxItemSet &rItemSet = pStyle->GetItemSet();
1138 // Font
1139 if( ( pPattern->FormatFlags & pfFont ) == pfFont )
1140 {
1141 FontFamily eFam = FAMILY_DONTKNOW;
1142 switch( pPattern->LogFont.lfPitchAndFamily & 0xF0 )
1143 {
1144 case ffDontCare : eFam = FAMILY_DONTKNOW; break;
1145 case ffRoman : eFam = FAMILY_ROMAN; break;
1146 case ffSwiss : eFam = FAMILY_SWISS; break;
1147 case ffModern : eFam = FAMILY_MODERN; break;
1148 case ffScript : eFam = FAMILY_SCRIPT; break;
1149 case ffDecorative : eFam = FAMILY_DECORATIVE; break;
1150 default: eFam = FAMILY_DONTKNOW; break;
1151 }
1152 rItemSet.Put( SvxFontItem( eFam, SC10TOSTRING( pPattern->LogFont.lfFaceName ), EMPTY_OUSTRING,
1153 PITCH_DONTKNOW, RTL_TEXTENCODING_DONTKNOW, ATTR_FONT ) );
1154 rItemSet.Put( SvxFontHeightItem( std::abs( pPattern->LogFont.lfHeight ), 100, ATTR_FONT_HEIGHT ) );
1155 Color TextColor( COL_BLACK );
1156 lcl_ChangeColor( ( pPattern->nColor & 0x000F ), TextColor );
1157 rItemSet.Put( SvxColorItem( TextColor, ATTR_FONT_COLOR ) );
1158 // FontAttr
1159 if( pPattern->LogFont.lfWeight != fwNormal )
1160 rItemSet.Put( SvxWeightItem( WEIGHT_BOLD, ATTR_FONT_WEIGHT ) );
1161 if( pPattern->LogFont.lfItalic != 0 )
1162 rItemSet.Put( SvxPostureItem( ITALIC_NORMAL, ATTR_FONT_POSTURE ) );
1163 if( pPattern->LogFont.lfUnderline != 0 )
1164 rItemSet.Put( SvxUnderlineItem( LINESTYLE_SINGLE, ATTR_FONT_UNDERLINE ) );
1165 if( pPattern->LogFont.lfStrikeOut != 0 )
1166 rItemSet.Put( SvxCrossedOutItem( STRIKEOUT_SINGLE, ATTR_FONT_CROSSEDOUT ) );
1167 }
1168 // alignment
1169 if( ( pPattern->FormatFlags & pfJustify ) == pfJustify )
1170 {
1171 sal_uInt16 HorJustify = ( pPattern->Justify & 0x000F );
1172 sal_uInt16 VerJustify = ( pPattern->Justify & 0x00F0 ) >> 4;
1173 sal_uInt16 OJustify = ( pPattern->Justify & 0x0F00 ) >> 8;
1174 sal_uInt16 EJustify = ( pPattern->Justify & 0xF000 ) >> 12;
1175 if( HorJustify != 0 )
1176 switch( HorJustify )
1177 {
1178 case hjLeft:
1179 rItemSet.Put( SvxHorJustifyItem( SVX_HOR_JUSTIFY_LEFT, ATTR_HOR_JUSTIFY ) );
1180 break;
1181 case hjCenter:
1182 rItemSet.Put( SvxHorJustifyItem( SVX_HOR_JUSTIFY_CENTER, ATTR_HOR_JUSTIFY ) );
1183 break;
1184 case hjRight:
1185 rItemSet.Put( SvxHorJustifyItem( SVX_HOR_JUSTIFY_RIGHT, ATTR_HOR_JUSTIFY ) );
1186 break;
1187 }
1188 if( VerJustify != 0 )
1189 switch( VerJustify )
1190 {
1191 case vjTop:
1192 rItemSet.Put( SvxVerJustifyItem( SVX_VER_JUSTIFY_TOP, ATTR_VER_JUSTIFY ) );
1193 break;
1194 case vjCenter:
1195 rItemSet.Put( SvxVerJustifyItem( SVX_VER_JUSTIFY_CENTER, ATTR_VER_JUSTIFY ) );
1196 break;
1197 case vjBottom:
1198 rItemSet.Put( SvxVerJustifyItem( SVX_VER_JUSTIFY_BOTTOM, ATTR_VER_JUSTIFY ) );
1199 break;
1200 }
1201
1202 if( ( OJustify & ojWordBreak ) == ojWordBreak )
1203 rItemSet.Put( SfxBoolItem( ATTR_LINEBREAK, true ) );
1204 if( ( OJustify & ojBottomTop ) == ojBottomTop )
1205 rItemSet.Put( SfxInt32Item( ATTR_ROTATE_VALUE, 9000 ) );
1206 else if( ( OJustify & ojTopBottom ) == ojTopBottom )
1207 rItemSet.Put( SfxInt32Item( ATTR_ROTATE_VALUE, 27000 ) );
1208
1209 sal_Int16 Margin = std::max( ( sal_uInt16 ) 20, ( sal_uInt16 ) ( EJustify * 20 ) );
1210 if( ( ( OJustify & ojBottomTop ) == ojBottomTop ) )
1211 rItemSet.Put( SvxMarginItem( 20, Margin, 20, Margin, ATTR_MARGIN ) );
1212 else
1213 rItemSet.Put( SvxMarginItem( Margin, 20, Margin, 20, ATTR_MARGIN ) );
1214 }
1215
1216 // Frame
1217 if( ( pPattern->FormatFlags & pfFrame ) == pfFrame )
1218 {
1219 if( pPattern->Frame != 0 )
1220 {
1221 sal_uInt16 nLeft = 0;
1222 sal_uInt16 nTop = 0;
1223 sal_uInt16 nRight = 0;
1224 sal_uInt16 nBottom = 0;
1225 sal_uInt16 fLeft = ( pPattern->Frame & 0x000F );
1226 sal_uInt16 fTop = ( pPattern->Frame & 0x00F0 ) / 0x0010;
1227 sal_uInt16 fRight = ( pPattern->Frame & 0x0F00 ) / 0x0100;
1228 sal_uInt16 fBottom = ( pPattern->Frame & 0xF000 ) / 0x1000;
1229
1230 if( fLeft > 1 )
1231 nLeft = 50;
1232 else if( fLeft > 0 )
1233 nLeft = 20;
1234
1235 if( fTop > 1 )
1236 nTop = 50;
1237 else if( fTop > 0 )
1238 nTop = 20;
1239
1240 if( fRight > 1 )
1241 nRight = 50;
1242 else if( fRight > 0 )
1243 nRight = 20;
1244
1245 if( fBottom > 1 )
1246 nBottom = 50;
1247 else if( fBottom > 0 )
1248 nBottom = 20;
1249
1250 Color ColorLeft( COL_BLACK );
1251 Color ColorTop( COL_BLACK );
1252 Color ColorRight( COL_BLACK );
1253 Color ColorBottom( COL_BLACK );
1254
1255 sal_uInt16 cLeft = ( pPattern->FrameColor & 0x000F );
1256 sal_uInt16 cTop = ( pPattern->FrameColor & 0x00F0 ) >> 4;
1257 sal_uInt16 cRight = ( pPattern->FrameColor & 0x0F00 ) >> 8;
1258 sal_uInt16 cBottom = ( pPattern->FrameColor & 0xF000 ) >> 12;
1259
1260 lcl_ChangeColor( cLeft, ColorLeft );
1261 lcl_ChangeColor( cTop, ColorTop );
1262 lcl_ChangeColor( cRight, ColorRight );
1263 lcl_ChangeColor( cBottom, ColorBottom );
1264
1265 ::editeng::SvxBorderLine aLine;
1266 SvxBoxItem aBox( ATTR_BORDER );
1267
1268 aLine.SetWidth( nLeft );
1269 aLine.SetColor( ColorLeft );
1270 aBox.SetLine( &aLine, SvxBoxItemLine::LEFT );
1271 aLine.SetWidth( nTop );
1272 aLine.SetColor( ColorTop );
1273 aBox.SetLine( &aLine, SvxBoxItemLine::TOP );
1274 aLine.SetWidth( nRight );
1275 aLine.SetColor( ColorRight );
1276 aBox.SetLine( &aLine, SvxBoxItemLine::RIGHT );
1277 aLine.SetWidth( nBottom );
1278 aLine.SetColor( ColorBottom );
1279 aBox.SetLine( &aLine, SvxBoxItemLine::BOTTOM );
1280 rItemSet.Put( aBox );
1281 }
1282 }
1283 // grid
1284 if( ( pPattern->FormatFlags & pfRaster ) == pfRaster )
1285 {
1286 if( pPattern->Raster != 0 )
1287 {
1288 sal_uInt16 nBColor = ( pPattern->nColor & 0x00F0 ) >> 4;
1289 sal_uInt16 nRColor = ( pPattern->nColor & 0x0F00 ) >> 8;
1290 Color aBColor( COL_BLACK );
1291
1292 lcl_ChangeColor( nBColor, aBColor );
1293
1294 if( nBColor == 0 )
1295 aBColor.SetColor( COL_WHITE );
1296 else if( nBColor == 15 )
1297 aBColor.SetColor( COL_BLACK );
1298
1299 Color aRColor( COL_BLACK );
1300 lcl_ChangeColor( nRColor, aRColor );
1301 sal_uInt16 nFact;
1302 bool bSwapCol = false;
1303 bool bSetItem = true;
1304 switch (pPattern->Raster)
1305 {
1306 case raNone: nFact = 0xffff; bSwapCol = true; bSetItem = (nBColor > 0); break;
1307 case raGray12: nFact = (0xffff / 100) * 12; break;
1308 case raGray25: nFact = (0xffff / 100) * 25; break;
1309 case raGray50: nFact = (0xffff / 100) * 50; break;
1310 case raGray75: nFact = (0xffff / 100) * 75; break;
1311 default: nFact = 0xffff; bSetItem = (nRColor < 15);
1312 }
1313 if ( bSetItem )
1314 {
1315 if( bSwapCol )
1316 rItemSet.Put( SvxBrushItem( GetMixedColor( aBColor, aRColor, nFact ), ATTR_BACKGROUND ) );
1317 else
1318 rItemSet.Put( SvxBrushItem( GetMixedColor( aRColor, aBColor, nFact ), ATTR_BACKGROUND ) );
1319 }
1320 }
1321 }
1322 // number formats
1323 if( ( pPattern->ValueFormat.Format != 0 ) &&
1324 ( ( pPattern->FormatFlags & pfValue ) == pfValue ) )
1325 {
1326 sal_uLong nKey = 0;
1327 ChangeFormat( pPattern->ValueFormat.Format, pPattern->ValueFormat.Info, nKey );
1328 rItemSet.Put( SfxUInt32Item( ATTR_VALUE_FORMAT, ( sal_uInt32 ) nKey ) );
1329 }
1330
1331 // cell attributes (protected, hidden...)
1332 if( ( pPattern->Flags != 0 ) &&
1333 ( ( pPattern->FormatFlags & pfProtection ) == pfProtection ) )
1334 {
1335 bool bProtect = ( ( pPattern->Flags & paProtect ) == paProtect );
1336 bool bHFormula = ( ( pPattern->Flags & paHideFormula ) == paHideFormula );
1337 bool bHCell = ( ( pPattern->Flags & paHideAll ) == paHideAll );
1338 bool bHPrint = ( ( pPattern->Flags & paHidePrint ) == paHidePrint );
1339 rItemSet.Put( ScProtectionAttr( bProtect, bHFormula, bHCell, bHPrint ) );
1340 }
1341 } // if Style != 0
1342 } // for (i = 0; i < GetCount()
1343 }
1344
1345 void Sc10Import::LoadDataBaseCollection()
1346 {
1347 pDataBaseCollection = new Sc10DataBaseCollection(rStream);
1348 if (!nError)
1349 nError = pDataBaseCollection->GetError();
1350 if (nError == errOutOfMemory)
1351 return; // hopeless
1352 for( sal_uInt16 i = 0 ; i < pDataBaseCollection->GetCount() ; i++ )
1353 {
1354 Sc10DataBaseData* pOldData = pDataBaseCollection->At(i);
1355 ScDBData* pNewData = new ScDBData( SC10TOSTRING( pOldData->DataBaseRec.Name ),
1356 ( SCTAB ) pOldData->DataBaseRec.Tab,
1357 ( SCCOL ) pOldData->DataBaseRec.Block.x1,
1358 ( SCROW ) pOldData->DataBaseRec.Block.y1,
1359 ( SCCOL ) pOldData->DataBaseRec.Block.x2,
1360 ( SCROW ) pOldData->DataBaseRec.Block.y2,
1361 true,
1362 (bool) pOldData->DataBaseRec.RowHeader );
1363 bool ins = pDoc->GetDBCollection()->getNamedDBs().insert(pNewData);
1364 assert(ins); (void)ins;
1365 //TODO: or can this fail (and need delete pNewData)?
1366 }
1367 }
1368
1369 namespace
1370 {
1371 sal_uInt16 ReadAndSanitizeDataCount(SvStream &rStream)
1372 {
1373 sal_uInt16 nDataCount(0);
1374 rStream.ReadUInt16(nDataCount);
1375 const size_t nMinRecordSize = sizeof(sal_uInt16)*2;
1376 const size_t nMaxRecords = rStream.remainingSize() / nMinRecordSize;
1377 if (nDataCount > nMaxRecords)
1378 {
1379 SAL_WARN("sc", "Parsing error: " << nMaxRecords <<
1380 " max possible entries, but " << nDataCount << " claimed, truncating");
1381 nDataCount = nMaxRecords;
1382 }
1383 return nDataCount;
1384 }
1385 }
1386
1387 void Sc10Import::LoadTables()
1388 {
1389 Sc10PageCollection aPageCollection;
1390
1391 sal_Int16 nTabCount;
1392 rStream.ReadInt16( nTabCount );
1393 for (sal_Int16 Tab = 0; (Tab < nTabCount) && (nError == 0); Tab++)
1394 {
1395 Sc10PageFormat PageFormat;
1396 sal_Int16 DataBaseIndex;
1397 Sc10TableProtect TabProtect;
1398 sal_Int16 TabNo;
1399 sal_Char TabName[128];
1400 sal_uInt16 Display;
1401 sal_uInt8 Visible;
1402 sal_uInt16 ID;
1403 sal_uInt16 DataCount;
1404 sal_uInt16 DataStart;
1405 sal_uInt16 DataEnd;
1406 sal_uInt16 DataValue;
1407 sal_uInt16 Count;
1408 sal_uInt16 i;
1409
1410 lcl_ReadPageFormat(rStream, PageFormat);
1411
1412 sal_uInt16 nAt = aPageCollection.InsertFormat(PageFormat);
1413 OUString aPageName = lcl_MakeOldPageStyleFormatName( nAt );
1414
1415 pPrgrsBar->Progress();
1416
1417 rStream.ReadInt16( DataBaseIndex );
1418
1419 lcl_ReadTabProtect(rStream, TabProtect);
1420
1421 ScTableProtection aProtection;
1422 aProtection.setProtected(static_cast<bool>(TabProtect.Protect));
1423 aProtection.setPassword(SC10TOSTRING(TabProtect.PassWord));
1424 pDoc->SetTabProtection(static_cast<SCTAB>(Tab), &aProtection);
1425
1426 rStream.ReadInt16( TabNo );
1427
1428 sal_uInt8 nLen;
1429 rStream.ReadUChar( nLen );
1430 rStream.Read(TabName, sizeof(TabName) - 1);
1431 if (nLen >= sizeof(TabName))
1432 nLen = sizeof(TabName) - 1;
1433 TabName[nLen] = 0;
1434
1435 rStream.ReadUInt16( Display );
1436
1437 if ( Tab == (sal_Int16)nShowTab )
1438 {
1439 ScVObjMode eObjMode = VOBJ_MODE_SHOW;
1440
1441 aSc30ViewOpt.SetOption( VOPT_FORMULAS, IS_SET(dfFormula,Display) );
1442 aSc30ViewOpt.SetOption( VOPT_NULLVALS, IS_SET(dfZerro,Display) );
1443 aSc30ViewOpt.SetOption( VOPT_SYNTAX, IS_SET(dfSyntax,Display) );
1444 aSc30ViewOpt.SetOption( VOPT_NOTES, IS_SET(dfNoteMark,Display) );
1445 aSc30ViewOpt.SetOption( VOPT_VSCROLL );
1446 aSc30ViewOpt.SetOption( VOPT_HSCROLL );
1447 aSc30ViewOpt.SetOption( VOPT_TABCONTROLS );
1448 aSc30ViewOpt.SetOption( VOPT_OUTLINER );
1449 aSc30ViewOpt.SetOption( VOPT_GRID, IS_SET(dfGrid,Display) );
1450
1451 // VOPT_HEADER is set in LoadViewColRowBar()
1452
1453 if ( IS_SET(dfObjectAll,Display) ) // show objects
1454 eObjMode = VOBJ_MODE_SHOW;
1455 else if ( IS_SET(dfObjectFrame,Display) ) // object as placeholder
1456 eObjMode = VOBJ_MODE_SHOW;
1457 else if ( IS_SET(dfObjectNone,Display) ) // don't show objects
1458 eObjMode = VOBJ_MODE_HIDE;
1459
1460 aSc30ViewOpt.SetObjMode( VOBJ_TYPE_OLE, eObjMode );
1461 aSc30ViewOpt.SetObjMode( VOBJ_TYPE_CHART, eObjMode );
1462 aSc30ViewOpt.SetObjMode( VOBJ_TYPE_DRAW, eObjMode );
1463 }
1464
1465 rStream.ReadUChar( Visible );
1466
1467 nError = rStream.GetError();
1468 if (nError != 0) return;
1469
1470 if (TabNo == 0)
1471 pDoc->RenameTab(static_cast<SCTAB> (TabNo), SC10TOSTRING( TabName ), false);
1472 else
1473 pDoc->InsertTab(SC_TAB_APPEND, SC10TOSTRING( TabName ) );
1474
1475 pDoc->SetPageStyle( static_cast<SCTAB>(Tab), aPageName );
1476
1477 if (Visible == 0) pDoc->SetVisible(static_cast<SCTAB> (TabNo), false);
1478
1479 // ColWidth
1480 rStream.ReadUInt16( ID );
1481 if (ID != ColWidthID)
1482 {
1483 OSL_FAIL( "ColWidthID" );
1484 nError = errUnknownID;
1485 return;
1486 }
1487 DataCount = ReadAndSanitizeDataCount(rStream);
1488 DataStart = 0;
1489 for (i=0; i < DataCount; i++)
1490 {
1491 rStream.ReadUInt16( DataEnd );
1492 DataEnd = SanitizeCol(DataEnd);
1493 rStream.ReadUInt16( DataValue );
1494 for (SCCOL j = static_cast<SCCOL>(DataStart); j <= static_cast<SCCOL>(DataEnd); j++)
1495 pDoc->SetColWidth(j, static_cast<SCTAB> (TabNo), DataValue);
1496 DataStart = DataEnd + 1;
1497 }
1498 pPrgrsBar->Progress();
1499
1500 // ColAttr
1501 rStream.ReadUInt16( ID );
1502 if (ID != ColAttrID)
1503 {
1504 OSL_FAIL( "ColAttrID" );
1505 nError = errUnknownID;
1506 return;
1507 }
1508
1509 DataCount = ReadAndSanitizeDataCount(rStream);
1510 DataStart = 0;
1511 for (i=0; i < DataCount; i++)
1512 {
1513 rStream.ReadUInt16( DataEnd );
1514 rStream.ReadUInt16( DataValue );
1515 if (DataValue != 0)
1516 {
1517 bool bPageBreak = ((DataValue & crfSoftBreak) == crfSoftBreak);
1518 bool bManualBreak = ((DataValue & crfHardBreak) == crfHardBreak);
1519 bool bHidden = ((DataValue & crfHidden) == crfHidden);
1520 for (SCCOL k = SanitizeCol(static_cast<SCCOL>(DataStart)); k <= SanitizeCol(static_cast<SCCOL>(DataEnd)); k++)
1521 {
1522 pDoc->SetColHidden(k, k, static_cast<SCTAB>(TabNo), bHidden);
1523 pDoc->SetColBreak(k, static_cast<SCTAB> (TabNo), bPageBreak, bManualBreak);
1524 }
1525 }
1526 DataStart = DataEnd + 1;
1527 }
1528 pPrgrsBar->Progress();
1529
1530 // RowHeight
1531 rStream.ReadUInt16( ID );
1532 if (ID != RowHeightID)
1533 {
1534 OSL_FAIL( "RowHeightID" );
1535 nError = errUnknownID;
1536 return;
1537 }
1538
1539 DataCount = ReadAndSanitizeDataCount(rStream);
1540 DataStart = 0;
1541 for (i=0; i < DataCount; i++)
1542 {
1543 rStream.ReadUInt16( DataEnd );
1544 rStream.ReadUInt16( DataValue );
1545 pDoc->SetRowHeightRange(static_cast<SCROW> (DataStart), static_cast<SCROW> (DataEnd), static_cast<SCTAB> (TabNo), DataValue);
1546 DataStart = DataEnd + 1;
1547 }
1548 pPrgrsBar->Progress();
1549
1550 // RowAttr
1551 rStream.ReadUInt16( ID );
1552 if (ID != RowAttrID)
1553 {
1554 OSL_FAIL( "RowAttrID" );
1555 nError = errUnknownID;
1556 return;
1557 }
1558
1559 DataCount = ReadAndSanitizeDataCount(rStream);
1560 DataStart = 0;
1561 for (i=0; i < DataCount; i++)
1562 {
1563 rStream.ReadUInt16( DataEnd );
1564 rStream.ReadUInt16( DataValue );
1565 if (DataValue != 0)
1566 {
1567 bool bPageBreak = ((DataValue & crfSoftBreak) == crfSoftBreak);
1568 bool bManualBreak = ((DataValue & crfHardBreak) == crfHardBreak);
1569 bool bHidden = ((DataValue & crfHidden) == crfHidden);
1570 for (SCROW l = SanitizeRow(static_cast<SCROW>(DataStart)); l <= SanitizeRow(static_cast<SCROW>(DataEnd)); ++l)
1571 {
1572 pDoc->SetRowHidden(l, l, static_cast<SCTAB> (TabNo), bHidden);
1573 pDoc->SetRowBreak(l, static_cast<SCTAB> (TabNo), bPageBreak, bManualBreak);
1574 }
1575 }
1576 DataStart = DataEnd + 1;
1577 }
1578 pPrgrsBar->Progress();
1579
1580 // Data table
1581 rStream.ReadUInt16( ID );
1582 if (ID != TableID)
1583 {
1584 OSL_FAIL( "TableID" );
1585 nError = errUnknownID;
1586 return;
1587 }
1588 for (SCCOL Col = 0; (Col <= SC10MAXCOL) && (nError == 0); Col++)
1589 {
1590 rStream.ReadUInt16( Count );
1591 nError = rStream.GetError();
1592 if ((Count != 0) && (nError == 0))
1593 LoadCol(Col, static_cast<SCTAB> (TabNo));
1594 }
1595 OSL_ENSURE( nError == 0, "Stream" );
1596 }
1597 pPrgrsBar->Progress();
1598
1599 aPageCollection.PutToDoc( pDoc );
1600 }
1601
1602 void Sc10Import::LoadCol(SCCOL Col, SCTAB Tab)
1603 {
1604 LoadColAttr(Col, Tab);
1605
1606 sal_uInt16 CellCount;
1607 sal_uInt8 CellType;
1608 sal_uInt16 Row;
1609 rStream.ReadUInt16( CellCount );
1610 SCROW nScCount = static_cast< SCROW >( CellCount );
1611 if (nScCount > MAXROW) nError = errUnknownFormat;
1612 for (sal_uInt16 i = 0; (i < CellCount) && (nError == 0); i++)
1613 {
1614 rStream.ReadUChar( CellType );
1615 rStream.ReadUInt16( Row );
1616 nError = rStream.GetError();
1617 if (nError == 0)
1618 {
1619 switch (CellType)
1620 {
1621 case ctValue :
1622 {
1623 const SfxPoolItem* pValueFormat = pDoc->GetAttr(Col, static_cast<SCROW> (Row), Tab, ATTR_VALUE_FORMAT);
1624 sal_uLong nFormat = static_cast<const SfxUInt32Item*>(pValueFormat)->GetValue();
1625 double Value = ScfTools::ReadLongDouble(rStream);
1626 //rStream.Read(&Value, sizeof(Value));
1627
1628 // TODO: adjustment is needed if we change the Basis Date
1629 // StarCalc 1.0: 01.01.1900
1630 // if ((nFormat >= 30) && (nFormat <= 35))
1631 // Value += 0;
1632 if ((nFormat >= 40) && (nFormat <= 45))
1633 Value /= 86400.0;
1634 pDoc->SetValue(Col, static_cast<SCROW> (Row), Tab, Value);
1635 break;
1636 }
1637 case ctString :
1638 {
1639 sal_uInt8 Len;
1640 sal_Char s[256];
1641 rStream.ReadUChar( Len );
1642 rStream.Read(s, Len);
1643 s[Len] = 0;
1644
1645 pDoc->SetString( Col, static_cast<SCROW> (Row), Tab, SC10TOSTRING( s ) );
1646 break;
1647 }
1648 case ctFormula :
1649 {
1650 /*double Value =*/ ScfTools::ReadLongDouble(rStream);
1651 sal_uInt8 Len;
1652 sal_Char s[256+1];
1653 rStream.ReadUChar( Len );
1654 rStream.Read(&s[1], Len);
1655 s[0] = '=';
1656 s[Len + 1] = 0;
1657 ScFormulaCell* pCell = new ScFormulaCell( pDoc, ScAddress( Col, static_cast<SCROW> (Row), Tab ) );
1658 pCell->SetHybridFormula( SC10TOSTRING( s ),formula::FormulaGrammar::GRAM_NATIVE );
1659 pDoc->EnsureTable(Tab);
1660 pDoc->SetFormulaCell(ScAddress(Col,Row,Tab), pCell);
1661 break;
1662 }
1663 case ctNote :
1664 break;
1665 default :
1666 nError = errUnknownFormat;
1667 break;
1668 }
1669 sal_uInt16 nNoteLen(0);
1670 rStream.ReadUInt16(nNoteLen);
1671 size_t nAvailable = rStream.remainingSize();
1672 if (nNoteLen > nAvailable)
1673 nNoteLen = nAvailable;
1674 if (nNoteLen != 0)
1675 {
1676 std::unique_ptr<sal_Char[]> xNote(new sal_Char[nNoteLen+1]);
1677 nNoteLen = rStream.Read(xNote.get(), nNoteLen);
1678 xNote[nNoteLen] = 0;
1679 OUString aNoteText( SC10TOSTRING(xNote.get()));
1680 xNote.reset();
1681 ScAddress aPos( Col, static_cast<SCROW>(Row), Tab );
1682 ScNoteUtil::CreateNoteFromString( *pDoc, aPos, aNoteText, false, false );
1683 }
1684 }
1685 pPrgrsBar->Progress();
1686 }
1687 }
1688
1689 void Sc10Import::LoadColAttr(SCCOL Col, SCTAB Tab)
1690 {
1691 Sc10ColAttr aFont;
1692 Sc10ColAttr aAttr;
1693 Sc10ColAttr aJustify;
1694 Sc10ColAttr aFrame;
1695 Sc10ColAttr aRaster;
1696 Sc10ColAttr aValue;
1697 Sc10ColAttr aColor;
1698 Sc10ColAttr aFrameColor;
1699 Sc10ColAttr aFlag;
1700 Sc10ColAttr aPattern;
1701
1702 if (nError == 0) LoadAttr(aFont);
1703 if (nError == 0) LoadAttr(aAttr);
1704 if (nError == 0) LoadAttr(aJustify);
1705 if (nError == 0) LoadAttr(aFrame);
1706 if (nError == 0) LoadAttr(aRaster);
1707 if (nError == 0) LoadAttr(aValue);
1708 if (nError == 0) LoadAttr(aColor);
1709 if (nError == 0) LoadAttr(aFrameColor);
1710 if (nError == 0) LoadAttr(aFlag);
1711 if (nError == 0) LoadAttr(aPattern);
1712
1713 if (nError)
1714 return;
1715
1716 SCROW nStart;
1717 sal_uInt16 i;
1718 sal_uInt16 nLimit;
1719 sal_uInt16 nValue1;
1720 Sc10ColData *pColData;
1721
1722 // Font (Name, Size)
1723 nStart = 0;
1724 nLimit = aFont.Count;
1725 pColData = aFont.pData;
1726 for( i = 0 ; i < nLimit ; i++, pColData++ )
1727 {
1728 SCROW nEnd = static_cast<SCROW>(pColData->Row);
1729 if ((nStart <= nEnd) && (pColData->Value))
1730 {
1731 FontFamily eFam = FAMILY_DONTKNOW;
1732 Sc10FontData* pFont = pFontCollection->At(pColData->Value);
1733 if (pFont)
1734 {
1735 switch (pFont->PitchAndFamily & 0xF0)
1736 {
1737 case ffDontCare : eFam = FAMILY_DONTKNOW; break;
1738 case ffRoman : eFam = FAMILY_ROMAN; break;
1739 case ffSwiss : eFam = FAMILY_SWISS; break;
1740 case ffModern : eFam = FAMILY_MODERN; break;
1741 case ffScript : eFam = FAMILY_SCRIPT; break;
1742 case ffDecorative : eFam = FAMILY_DECORATIVE; break;
1743 default: eFam = FAMILY_DONTKNOW; break;
1744 }
1745 ScPatternAttr aScPattern(pDoc->GetPool());
1746 aScPattern.GetItemSet().Put(SvxFontItem(eFam, SC10TOSTRING( pFont->FaceName ), EMPTY_OUSTRING,
1747 PITCH_DONTKNOW, RTL_TEXTENCODING_DONTKNOW, ATTR_FONT ));
1748 aScPattern.GetItemSet().Put(SvxFontHeightItem(std::abs(pFont->Height), 100, ATTR_FONT_HEIGHT ));
1749 pDoc->ApplyPatternAreaTab(Col, nStart, Col, nEnd, Tab, aScPattern);
1750 }
1751 }
1752 nStart = nEnd + 1;
1753 }
1754
1755 // Font color
1756 nStart = 0;
1757 nLimit = aColor.Count;
1758 pColData = aColor.pData;
1759 for( i = 0 ; i < nLimit ; i++, pColData++ )
1760 {
1761 SCROW nEnd = static_cast<SCROW>(pColData->Row);
1762 if ((nStart <= nEnd) && (pColData->Value))
1763 {
1764 Color TextColor(COL_BLACK);
1765 lcl_ChangeColor((pColData->Value & 0x000F), TextColor);
1766 ScPatternAttr aScPattern(pDoc->GetPool());
1767 aScPattern.GetItemSet().Put(SvxColorItem(TextColor, ATTR_FONT_COLOR ));
1768 pDoc->ApplyPatternAreaTab(Col, nStart, Col, nEnd, Tab, aScPattern);
1769 }
1770 nStart = nEnd + 1;
1771 }
1772
1773 // Font attributes (Bold, Italic...)
1774 nStart = 0;
1775 nLimit = aAttr.Count;
1776 pColData = aAttr.pData;
1777 for( i = 0 ; i < nLimit ; i++, pColData++ )
1778 {
1779 SCROW nEnd = static_cast<SCROW>(pColData->Row);
1780 nValue1 = pColData->Value;
1781 if ((nStart <= nEnd) && (nValue1))
1782 {
1783 ScPatternAttr aScPattern(pDoc->GetPool());
1784 if ((nValue1 & atBold) == atBold)
1785 aScPattern.GetItemSet().Put(SvxWeightItem(WEIGHT_BOLD, ATTR_FONT_WEIGHT));
1786 if ((nValue1 & atItalic) == atItalic)
1787 aScPattern.GetItemSet().Put(SvxPostureItem(ITALIC_NORMAL, ATTR_FONT_POSTURE));
1788 if ((nValue1 & atUnderline) == atUnderline)
1789 aScPattern.GetItemSet().Put(SvxUnderlineItem(LINESTYLE_SINGLE, ATTR_FONT_UNDERLINE));
1790 if ((nValue1 & atStrikeOut) == atStrikeOut)
1791 aScPattern.GetItemSet().Put(SvxCrossedOutItem(STRIKEOUT_SINGLE, ATTR_FONT_CROSSEDOUT));
1792 pDoc->ApplyPatternAreaTab(Col, nStart, Col, nEnd, Tab, aScPattern);
1793 }
1794 nStart = nEnd + 1;
1795 }
1796
1797 // Cell alignment
1798 nStart = 0;
1799 nLimit = aJustify.Count;
1800 pColData = aJustify.pData;
1801 for( i = 0 ; i < nLimit ; i++, pColData++ )
1802 {
1803 SCROW nEnd = static_cast<SCROW>(pColData->Row);
1804 nValue1 = pColData->Value;
1805 if ((nStart <= nEnd) && (nValue1))
1806 {
1807 ScPatternAttr aScPattern(pDoc->GetPool());
1808 sal_uInt16 HorJustify = (nValue1 & 0x000F);
1809 sal_uInt16 VerJustify = (nValue1 & 0x00F0) >> 4;
1810 sal_uInt16 OJustify = (nValue1 & 0x0F00) >> 8;
1811 sal_uInt16 EJustify = (nValue1 & 0xF000) >> 12;
1812
1813 switch (HorJustify)
1814 {
1815 case hjLeft:
1816 aScPattern.GetItemSet().Put(SvxHorJustifyItem(SVX_HOR_JUSTIFY_LEFT, ATTR_HOR_JUSTIFY));
1817 break;
1818 case hjCenter:
1819 aScPattern.GetItemSet().Put(SvxHorJustifyItem(SVX_HOR_JUSTIFY_CENTER, ATTR_HOR_JUSTIFY));
1820 break;
1821 case hjRight:
1822 aScPattern.GetItemSet().Put(SvxHorJustifyItem(SVX_HOR_JUSTIFY_RIGHT, ATTR_HOR_JUSTIFY));
1823 break;
1824 }
1825
1826 switch (VerJustify)
1827 {
1828 case vjTop:
1829 aScPattern.GetItemSet().Put(SvxVerJustifyItem(SVX_VER_JUSTIFY_TOP, ATTR_VER_JUSTIFY));
1830 break;
1831 case vjCenter:
1832 aScPattern.GetItemSet().Put(SvxVerJustifyItem(SVX_VER_JUSTIFY_CENTER, ATTR_VER_JUSTIFY));
1833 break;
1834 case vjBottom:
1835 aScPattern.GetItemSet().Put(SvxVerJustifyItem(SVX_VER_JUSTIFY_BOTTOM, ATTR_VER_JUSTIFY));
1836 break;
1837 }
1838
1839 if (OJustify & ojWordBreak)
1840 aScPattern.GetItemSet().Put(SfxBoolItem(ATTR_LINEBREAK, true));
1841 if (OJustify & ojBottomTop)
1842 aScPattern.GetItemSet().Put(SfxInt32Item(ATTR_ROTATE_VALUE,9000));
1843 else if (OJustify & ojTopBottom)
1844 aScPattern.GetItemSet().Put(SfxInt32Item(ATTR_ROTATE_VALUE,27000));
1845
1846 sal_Int16 Margin = std::max((sal_uInt16)20, (sal_uInt16)(EJustify * 20));
1847 if (OJustify & ojBottomTop)
1848 aScPattern.GetItemSet().Put(SvxMarginItem(20, Margin, 20, Margin, ATTR_MARGIN));
1849 else
1850 aScPattern.GetItemSet().Put(SvxMarginItem(Margin, 20, Margin, 20, ATTR_MARGIN));
1851 pDoc->ApplyPatternAreaTab(Col, nStart, Col, nEnd, Tab, aScPattern);
1852 }
1853 nStart = nEnd + 1;
1854 }
1855 // Border
1856 bool bEnd = false;
1857 sal_uInt16 nColorIndex = 0;
1858 sal_uInt16 nFrameIndex = 0;
1859
1860 // Special Fix...
1861 const sal_uInt32 nHelpMeStart = 100;
1862 sal_uInt32 nHelpMe = nHelpMeStart;
1863 sal_uInt16 nColorIndexOld = nColorIndex;
1864 sal_uInt16 nFrameIndexOld = nColorIndex;
1865
1866 nStart = 0;
1867 while( !bEnd && nHelpMe )
1868 {
1869 SCROW nEnd = 0;
1870 pColData = &aFrame.pData[ nFrameIndex ];
1871
1872 sal_uInt16 nValue = pColData->Value;
1873 sal_uInt16 nLeft = 0;
1874 sal_uInt16 nTop = 0;
1875 sal_uInt16 nRight = 0;
1876 sal_uInt16 nBottom = 0;
1877 sal_uInt16 fLeft = ( nValue & 0x000F );
1878 sal_uInt16 fTop = ( nValue & 0x00F0 ) >> 4;
1879 sal_uInt16 fRight = ( nValue & 0x0F00 ) >> 8;
1880 sal_uInt16 fBottom = ( nValue & 0xF000 ) >> 12;
1881
1882 if( fLeft > 1 )
1883 nLeft = 50;
1884 else if( fLeft > 0 )
1885 nLeft = 20;
1886
1887 if( fTop > 1 )
1888 nTop = 50;
1889 else if( fTop > 0 )
1890 nTop = 20;
1891
1892 if( fRight > 1 )
1893 nRight = 50;
1894 else if( fRight > 0 )
1895 nRight = 20;
1896
1897 if( fBottom > 1 )
1898 nBottom = 50;
1899 else if( fBottom > 0 )
1900 nBottom = 20;
1901
1902 Color ColorLeft( COL_BLACK );
1903 Color ColorTop( COL_BLACK );
1904 Color ColorRight( COL_BLACK );
1905 Color ColorBottom( COL_BLACK );
1906 sal_uInt16 nFrmColVal = aFrameColor.pData[ nColorIndex ].Value;
1907 SCROW nFrmColRow = static_cast<SCROW>(aFrameColor.pData[ nColorIndex ].Row);
1908 sal_uInt16 cLeft = ( nFrmColVal & 0x000F );
1909 sal_uInt16 cTop = ( nFrmColVal & 0x00F0 ) >> 4;
1910 sal_uInt16 cRight = ( nFrmColVal & 0x0F00 ) >> 8;
1911 sal_uInt16 cBottom = ( nFrmColVal & 0xF000 ) >> 12;
1912
1913 lcl_ChangeColor( cLeft, ColorLeft );
1914 lcl_ChangeColor( cTop, ColorTop );
1915 lcl_ChangeColor( cRight, ColorRight );
1916 lcl_ChangeColor( cBottom, ColorBottom );
1917
1918 if( static_cast<SCROW>(pColData->Row) < nFrmColRow )
1919 {
1920 nEnd = static_cast<SCROW>(pColData->Row);
1921 if( nFrameIndex < ( aFrame.Count - 1 ) )
1922 nFrameIndex++;
1923 }
1924 else if( static_cast<SCROW>(pColData->Row) > nFrmColRow )
1925 {
1926 nEnd = static_cast<SCROW>(aFrameColor.pData[ nColorIndex ].Row);
1927 if( nColorIndex < ( aFrameColor.Count - 1 ) )
1928 nColorIndex++;
1929 }
1930 else
1931 {
1932 nEnd = nFrmColRow;
1933 if( nFrameIndex < (aFrame.Count - 1 ) )
1934 nFrameIndex++;
1935 if( nColorIndex < ( aFrameColor.Count - 1 ) )
1936 nColorIndex++;
1937 }
1938 if( ( nStart <= nEnd ) && ( nValue != 0 ) )
1939 {
1940 ScPatternAttr aScPattern(pDoc->GetPool());
1941 ::editeng::SvxBorderLine aLine;
1942 SvxBoxItem aBox( ATTR_BORDER );
1943
1944 aLine.SetWidth( nLeft );
1945 aLine.SetColor( ColorLeft );
1946 aBox.SetLine( &aLine, SvxBoxItemLine::LEFT );
1947
1948 aLine.SetWidth( nTop );
1949 aLine.SetColor( ColorTop );
1950 aBox.SetLine( &aLine, SvxBoxItemLine::TOP );
1951
1952 aLine.SetWidth( nRight );
1953 aLine.SetColor( ColorRight );
1954 aBox.SetLine( &aLine, SvxBoxItemLine::RIGHT );
1955
1956 aLine.SetWidth( nBottom );
1957 aLine.SetColor( ColorBottom );
1958 aBox.SetLine( &aLine, SvxBoxItemLine::BOTTOM );
1959
1960 aScPattern.GetItemSet().Put( aBox );
1961 pDoc->ApplyPatternAreaTab( Col, nStart, Col, nEnd, Tab, aScPattern );
1962 }
1963 nStart = nEnd + 1;
1964
1965 bEnd = ( nFrameIndex == ( aFrame.Count - 1 ) ) && ( nColorIndex == ( aFrameColor.Count - 1 ) );
1966
1967 if( nColorIndexOld != nColorIndex || nFrameIndexOld != nFrameIndex )
1968 {
1969 nColorIndexOld = nColorIndex;
1970 nFrameIndexOld = nFrameIndex;
1971 nHelpMe = nHelpMeStart;
1972 }
1973 else
1974 nHelpMe--;
1975
1976 pColData++;
1977 }
1978
1979 // TODO: Code up to here works more or less ... from here I've had enough ! (GT)
1980
1981 // Background (Color, Raster)
1982 sal_uInt16 nRasterIndex = 0;
1983 bEnd = false;
1984 nColorIndex = 0;
1985 nStart = 0;
1986
1987 // Special Fix...
1988 nHelpMe = nHelpMeStart;
1989 sal_uInt16 nRasterIndexOld = nRasterIndex;
1990
1991 while( !bEnd && nHelpMe )
1992 {
1993 SCROW nEnd = 0;
1994 sal_uInt16 nBColor = ( aColor.pData[ nColorIndex ].Value & 0x00F0 ) >> 4;
1995 sal_uInt16 nRColor = ( aColor.pData[ nColorIndex ].Value & 0x0F00 ) >> 8;
1996 Color aBColor( COL_BLACK );
1997
1998 lcl_ChangeColor( nBColor, aBColor );
1999
2000 if( nBColor == 0 )
2001 aBColor.SetColor( COL_WHITE );
2002 else if( nBColor == 15 )
2003 aBColor.SetColor( COL_BLACK );
2004
2005 Color aRColor( COL_BLACK );
2006
2007 lcl_ChangeColor( nRColor, aRColor );
2008
2009 ScPatternAttr aScPattern( pDoc->GetPool() );
2010
2011 sal_uInt16 nFact;
2012 bool bSwapCol = false;
2013 bool bSetItem = true;
2014 switch ( aRaster.pData[ nRasterIndex ].Value )
2015 {
2016 case raNone: nFact = 0xffff; bSwapCol = true; bSetItem = (nBColor > 0); break;
2017 case raGray12: nFact = (0xffff / 100) * 12; break;
2018 case raGray25: nFact = (0xffff / 100) * 25; break;
2019 case raGray50: nFact = (0xffff / 100) * 50; break;
2020 case raGray75: nFact = (0xffff / 100) * 75; break;
2021 default: nFact = 0xffff; bSetItem = (nRColor < 15);
2022 }
2023 if ( bSetItem )
2024 {
2025 if( bSwapCol )
2026 aScPattern.GetItemSet().Put( SvxBrushItem( GetMixedColor( aBColor, aRColor, nFact ), ATTR_BACKGROUND ) );
2027 else
2028 aScPattern.GetItemSet().Put( SvxBrushItem( GetMixedColor( aRColor, aBColor, nFact ), ATTR_BACKGROUND ) );
2029 }
2030 if( aRaster.pData[ nRasterIndex ].Row < aColor.pData[ nColorIndex ].Row )
2031 {
2032 nEnd = static_cast<SCROW>(aRaster.pData[ nRasterIndex ].Row);
2033 if( nRasterIndex < ( aRaster.Count - 1 ) )
2034 nRasterIndex++;
2035 }
2036 else if( aRaster.pData[ nRasterIndex ].Row > aColor.pData[ nColorIndex ].Row )
2037 {
2038 nEnd = static_cast<SCROW>(aColor.pData[ nColorIndex ].Row);
2039 if( nColorIndex < ( aColor.Count - 1 ) )
2040 nColorIndex++;
2041 }
2042 else
2043 {
2044 nEnd = static_cast<SCROW>(aColor.pData[ nColorIndex ].Row);
2045 if( nRasterIndex < ( aRaster.Count - 1 ) )
2046 nRasterIndex++;
2047 if( nColorIndex < ( aColor.Count - 1 ) )
2048 nColorIndex++;
2049 }
2050 if( nStart <= nEnd )
2051 pDoc->ApplyPatternAreaTab( Col, nStart, Col, nEnd, Tab, aScPattern );
2052
2053 nStart = nEnd + 1;
2054
2055 bEnd = ( nRasterIndex == ( aRaster.Count - 1 ) ) && ( nColorIndex == ( aColor.Count - 1 ) );
2056
2057 if( nColorIndexOld != nColorIndex || nRasterIndexOld != nRasterIndex )
2058 {
2059 nColorIndexOld = nColorIndex;
2060 nRasterIndexOld = nRasterIndex;
2061 nHelpMe = nHelpMeStart;
2062 }
2063 else
2064 nHelpMe--;
2065
2066 nHelpMe--;
2067 }
2068
2069 // Number format
2070 nStart = 0;
2071 nLimit = aValue.Count;
2072 pColData = aValue.pData;
2073 for (i=0; i<nLimit; i++, pColData++)
2074 {
2075 SCROW nEnd = static_cast<SCROW>(pColData->Row);
2076 nValue1 = pColData->Value;
2077 if ((nStart <= nEnd) && (nValue1))
2078 {
2079 sal_uLong nKey = 0;
2080 sal_uInt16 nFormat = (nValue1 & 0x00FF);
2081 sal_uInt16 nInfo = (nValue1 & 0xFF00) >> 8;
2082 ChangeFormat(nFormat, nInfo, nKey);
2083 ScPatternAttr aScPattern(pDoc->GetPool());
2084 aScPattern.GetItemSet().Put(SfxUInt32Item(ATTR_VALUE_FORMAT, (sal_uInt32)nKey));
2085 pDoc->ApplyPatternAreaTab(Col, nStart, Col, nEnd, Tab, aScPattern);
2086 }
2087 nStart = nEnd + 1;
2088 }
2089
2090 // Cell attributes (protected, hidden...)
2091 nStart = 0;
2092 for (i=0; i<aFlag.Count; i++)
2093 {
2094 SCROW nEnd = static_cast<SCROW>(aFlag.pData[i].Row);
2095 if ((nStart <= nEnd) && (aFlag.pData[i].Value != 0))
2096 {
2097 bool bProtect = ((aFlag.pData[i].Value & paProtect) == paProtect);
2098 bool bHFormula = ((aFlag.pData[i].Value & paHideFormula) == paHideFormula);
2099 bool bHCell = ((aFlag.pData[i].Value & paHideAll) == paHideAll);
2100 bool bHPrint = ((aFlag.pData[i].Value & paHidePrint) == paHidePrint);
2101 ScPatternAttr aScPattern(pDoc->GetPool());
2102 aScPattern.GetItemSet().Put(ScProtectionAttr(bProtect, bHFormula, bHCell, bHPrint));
2103 pDoc->ApplyPatternAreaTab(Col, nStart, Col, nEnd, Tab, aScPattern);
2104 }
2105 nStart = nEnd + 1;
2106 }
2107
2108 // Cell style
2109 nStart = 0;
2110 ScStyleSheetPool* pStylePool = pDoc->GetStyleSheetPool();
2111 for (i=0; i<aPattern.Count; i++)
2112 {
2113 SCROW nEnd = static_cast<SCROW>(aPattern.pData[i].Row);
2114 if ((nStart <= nEnd) && (aPattern.pData[i].Value != 0))
2115 {
2116 sal_uInt16 nPatternIndex = (aPattern.pData[i].Value & 0x00FF) - 1;
2117 Sc10PatternData* pPattern = pPatternCollection->At(nPatternIndex);
2118 if (pPattern != nullptr)
2119 {
2120 ScStyleSheet* pStyle = static_cast<ScStyleSheet*>( pStylePool->Find(
2121 SC10TOSTRING( pPattern->Name ), SfxStyleFamily::Para) );
2122
2123 if (pStyle != nullptr)
2124 pDoc->ApplyStyleAreaTab(Col, nStart, Col, nEnd, Tab, *pStyle);
2125 }
2126 }
2127 nStart = nEnd + 1;
2128 }
2129 }
2130
2131 void Sc10Import::LoadAttr(Sc10ColAttr& rAttr)
2132 {
2133 // rAttr is not reused, otherwise we'd have to delete [] rAttr.pData;
2134 rStream.ReadUInt16(rAttr.Count);
2135
2136 const size_t nMaxEntries = rStream.remainingSize() / (sizeof(sal_uInt16) * 2);
2137 if (rAttr.Count > nMaxEntries)
2138 rAttr.Count = nMaxEntries;
2139
2140 if (!rAttr.Count)
2141 return;
2142
2143 rAttr.pData = new (::std::nothrow) Sc10ColData[rAttr.Count];
2144 if (rAttr.pData == nullptr)
2145 {
2146 nError = errOutOfMemory;
2147 rAttr.Count = 0;
2148 return;
2149 }
2150
2151 for (sal_uInt16 i = 0; i < rAttr.Count; ++i)
2152 {
2153 rStream.ReadUInt16( rAttr.pData[i].Row );
2154 rStream.ReadUInt16( rAttr.pData[i].Value );
2155 }
2156
2157 nError = rStream.GetError();
2158 }
2159
2160 void Sc10Import::ChangeFormat(sal_uInt16 nFormat, sal_uInt16 nInfo, sal_uLong& nKey)
2161 {
2162 // TODO: formats are mapped only for StarCalc 3.0 internal formats
2163 // more correctly, at times new formats need to be created (Stephan: please check!)
2164 nKey = 0;
2165 switch (nFormat)
2166 {
2167 case vfStandard :
2168 if (nInfo > 0)
2169 nKey = 2;
2170 break;
2171 case vfMoney :
2172 if (nInfo > 0)
2173 nKey = 21;
2174 else
2175 nKey = 20;
2176 break;
2177 case vfThousend :
2178 if (nInfo > 0)
2179 nKey = 4;
2180 else
2181 nKey = 5;
2182 break;
2183 case vfPercent :
2184 if (nInfo > 0)
2185 nKey = 11;
2186 else
2187 nKey = 10;
2188 break;
2189 case vfExponent :
2190 nKey = 60;
2191 break;
2192 case vfZerro :
2193 // TODO: no equivalent
2194 break;
2195 case vfDate :
2196 switch (nInfo)
2197 {
2198 case df_NDMY_Long :
2199 nKey = 31;
2200 break;
2201 case df_DMY_Long :
2202 nKey = 30;
2203 break;
2204 case df_MY_Long :
2205 nKey = 32;
2206 break;
2207 case df_NDM_Long :
2208 nKey = 31;
2209 break;
2210 case df_DM_Long :
2211 nKey = 33;
2212 break;
2213 case df_M_Long :
2214 nKey = 34;
2215 break;
2216 case df_NDMY_Short :
2217 nKey = 31;
2218 break;
2219 case df_DMY_Short :
2220 nKey = 30;
2221 break;
2222 case df_MY_Short :
2223 nKey = 32;
2224 break;
2225 case df_NDM_Short :
2226 nKey = 31;
2227 break;
2228 case df_DM_Short :
2229 nKey = 33;
2230 break;
2231 case df_M_Short :
2232 nKey = 34;
2233 break;
2234 case df_Q_Long :
2235 nKey = 35;
2236 break;
2237 case df_Q_Short :
2238 nKey = 35;
2239 break;
2240 default :
2241 nKey = 30;
2242 break;
2243 }
2244 break;
2245 case vfTime :
2246 switch (nInfo)
2247 {
2248 case tf_HMS_Long :
2249 nKey = 41;
2250 break;
2251 case tf_HM_Long :
2252 nKey = 40;
2253 break;
2254 case tf_HMS_Short :
2255 nKey = 43;
2256 break;
2257 case tf_HM_Short :
2258 nKey = 42;
2259 break;
2260 default :
2261 nKey = 41;
2262 break;
2263 }
2264 break;
2265 case vfBoolean :
2266 nKey = 99;
2267 break;
2268 case vfStandardRed :
2269 if (nInfo > 0)
2270 nKey = 2;
2271 break;
2272 case vfMoneyRed :
2273 if (nInfo > 0)
2274 nKey = 23;
2275 else
2276 nKey = 22;
2277 break;
2278 case vfThousendRed :
2279 if (nInfo > 0)
2280 nKey = 4;
2281 else
2282 nKey = 5;
2283 break;
2284 case vfPercentRed :
2285 if (nInfo > 0)
2286 nKey = 11;
2287 else
2288 nKey = 10;
2289 break;
2290 case vfExponentRed :
2291 nKey = 60;
2292 break;
2293 case vfFormula :
2294 break;
2295 case vfString :
2296 break;
2297 default :
2298 break;
2299 }
2300 }
2301
2302 void Sc10Import::LoadObjects()
2303 {
2304 sal_uInt16 ID;
2305 rStream.ReadUInt16( ID );
2306 if (rStream.IsEof())
2307 return;
2308 if (ID == ObjectID)
2309 {
2310 sal_uInt16 nAnz;
2311 rStream.ReadUInt16( nAnz );
2312 sal_Char Reserved[32];
2313 rStream.Read(Reserved, sizeof(Reserved));
2314 nError = rStream.GetError();
2315 if ((nAnz > 0) && (nError == 0))
2316 {
2317 sal_uInt8 ObjectType;
2318 Sc10GraphHeader GraphHeader;
2319 bool IsOleObject = false; // TODO: this is only a band-aid
2320 for (sal_uInt16 i = 0; (i < nAnz) && (nError == 0) && !rStream.IsEof() && !IsOleObject; i++)
2321 {
2322 rStream.ReadUChar( ObjectType );
2323 lcl_ReadGraphHeader(rStream, GraphHeader);
2324
2325 double nPPTX = ScGlobal::nScreenPPTX;
2326 double nPPTY = ScGlobal::nScreenPPTY;
2327
2328 long nStartX = 0;
2329 SCCOL nMaxCol = SanitizeCol(GraphHeader.CarretX);
2330 for (SCCOL nX = 0; nX < nMaxCol; ++nX)
2331 nStartX += pDoc->GetColWidth(nX, static_cast<SCTAB>(GraphHeader.CarretZ));
2332 nStartX = (long) ( nStartX * HMM_PER_TWIPS );
2333 nStartX += (long) ( GraphHeader.x / nPPTX * HMM_PER_TWIPS );
2334 long nSizeX = (long) ( GraphHeader.w / nPPTX * HMM_PER_TWIPS );
2335 long nStartY = pDoc->GetRowHeight( 0,
2336 SanitizeRow(static_cast<SCsROW>(GraphHeader.CarretY) - 1),
2337 SanitizeTab(static_cast<SCTAB>(GraphHeader.CarretZ)));
2338 nStartY = (long) ( nStartY * HMM_PER_TWIPS );
2339 nStartY += (long) ( GraphHeader.y / nPPTY * HMM_PER_TWIPS );
2340 long nSizeY = (long) ( GraphHeader.h / nPPTY * HMM_PER_TWIPS );
2341
2342 switch (ObjectType)
2343 {
2344 case otOle :
2345 // TODO: here we need to do something like OleLoadFromStream
2346 IsOleObject = true;
2347 break;
2348 case otImage :
2349 {
2350 Sc10ImageHeader ImageHeader;
2351 lcl_ReadImageHeaer(rStream, ImageHeader);
2352
2353 // Attention: here come the data (Bitmap oder Metafile)
2354 // Typ = 1 Device-dependend Bitmap DIB
2355 // Typ = 2 MetaFile
2356 rStream.SeekRel(ImageHeader.Size);
2357
2358 if( ImageHeader.Typ != 1 && ImageHeader.Typ != 2 )
2359 nError = errUnknownFormat;
2360 break;
2361 }
2362 case otChart :
2363 {
2364 Sc10ChartHeader ChartHeader;
2365 Sc10ChartSheetData ChartSheetData;
2366 Sc10ChartTypeData* pTypeData = new (::std::nothrow) Sc10ChartTypeData;
2367 if (!pTypeData)
2368 nError = errOutOfMemory;
2369 else
2370 {
2371 lcl_ReadChartHeader(rStream, ChartHeader);
2372
2373 // TODO: use old Metafile ??
2374 rStream.SeekRel(ChartHeader.Size);
2375
2376 lcl_ReadChartSheetData(rStream, ChartSheetData);
2377
2378 lcl_ReadChartTypeData(rStream, *pTypeData);
2379
2380 Rectangle aRect( Point(nStartX,nStartY), Size(nSizeX,nSizeY) );
2381 Sc10InsertObject::InsertChart( pDoc, static_cast<SCTAB>(GraphHeader.CarretZ), aRect,
2382 static_cast<SCTAB>(GraphHeader.CarretZ),
2383 ChartSheetData.DataX1, ChartSheetData.DataY1,
2384 ChartSheetData.DataX2, ChartSheetData.DataY2 );
2385
2386 delete pTypeData;
2387 }
2388 break;
2389 }
2390 default :
2391 nError = errUnknownFormat;
2392 break;
2393 }
2394 nError = rStream.GetError();
2395 }
2396 }
2397 }
2398 else
2399 {
2400 OSL_FAIL( "ObjectID" );
2401 nError = errUnknownID;
2402 }
2403 }
2404
2405 FltError ScFormatFilterPluginImpl::ScImportStarCalc10( SvStream& rStream, ScDocument* pDocument )
2406 {
2407 rStream.Seek( 0UL );
2408 Sc10Import aImport( rStream, pDocument );
2409 return ( FltError ) aImport.Import();
2410 }
2411
2412 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
FREE OFFICE SUITE