WhatuseistheDataPilot?
..................................................................................................250
CreatingDataPilotTables
...................................................................................................250
SelectingDataPilotOutputRanges
....................................................................................252
EditingDataPilotTables
.....................................................................................................252
FilteringDataPilotTables
...................................................................................................252
UpdatingDataPilotTables
.................................................................................................252
DeletingDataPilotTables
...................................................................................................252
ConsolidatingData
..................................................................................................................253
ApplyingGoalSeek
................................................................................................................255
NamingCells
......................................................................................................................255
StartGoalSeek
...................................................................................................................256
ApplyingMultipleOperations
............................................................................................256
MultipleOperationsinColumnsorRows
.....................................................................256
Examples
........................................................................................................................256
CalculatingWithOneFormulaandOneVariable
........................................................257
CalculatingwithSeveralformulaeSimultaneously
......................................................257
MultipleOperationsAcrossRowsandColumns
...............................................................257
CalculatingwithTwoVariables
....................................................................................258
UsingScenarios
.......................................................................................................................259
UsingReady­MadeScenarios
............................................................................................259
CreatingPersonalScenarios
...............................................................................................259
ValidityofCellContents
........................................................................................................261
UsingCellContentsValidity
..............................................................................................261
Samplemacro:
....................................................................................................................263
PrintingorExportingSpreadsheets
.........................................................................................264
PrintingSheetDetails
.........................................................................................................264
DefiningNumberofPagesforPrinting
..............................................................................264
PrintingSheetsinLandscapeFormat
.................................................................................265
PrintingRowsorColumnsonEveryPage
.........................................................................265
SavingandOpeningSheetsinHTML
....................................................................................267
SavingSheetsinHTML
.....................................................................................................267
OpeningSheetsinHTML
..................................................................................................267
OpenOffice.orgUserGuidefor2.x
xv
Pdf reverse page order preview - re-order PDF pages in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Support Customizing Page Order of PDF Document in C# Project
reverse page order pdf; pdf change page order online
Pdf reverse page order preview - VB.NET PDF Page Move Library: re-order PDF pages in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
Sort PDF Document Pages Using VB.NET Demo Code
move pages within pdf; pdf rearrange pages
formulaeandValuesasCSVFiles
..........................................................................................268
ExportingformulaeandValuesasCSVFiles
....................................................................268
ImportingaCSVFile
.........................................................................................................268
AutoFill
...................................................................................................................................270
ApplyingSortLists
.............................................................................................................270
AutomaticRowFilling
.......................................................................................................270
ProtectingSheets
................................................................................................................271
CreatingaReference
..........................................................................................................272
FurtherInformation
............................................................................................................272
Insertinganote
..................................................................................................................273
Insertingasheetintoanotherdocument
............................................................................273
Displayingformulae
..........................................................................................................273
Usingprintranges
..............................................................................................................273
FreezingColumns
...............................................................................................................273
SplittingaCalcWindow
....................................................................................................273
ConditionalFormatting
......................................................................................................273
DefiningValidity
................................................................................................................275
CreatingInputHelp
............................................................................................................275
LinkingSheetInformation
.................................................................................................276
Chapter5:CreatingPresentationsWithImpress
.............................................. ........277
OpenOffice.orgImpressToolbarsandWindows®
.................................................................278
HowtoCreateaBasicPresentation
........................................................................................279
CreatingaPresentationWiththeWizard
...........................................................................279
CreatingaSimplePresentationWithouttheWizard
..........................................................284
SwitchingPresentationViews
............................................................................................285
ArrangingSlides
.................................................................................................................286
IncorporatingSlideShowEffects
.......................................................................................287
In­SlideEffects
..............................................................................................................287
ShowingaPresentation
......................................................................................................287
EditingPresentations
...............................................................................................................288
Defining
Backgroundcolours
.............................................................................................288
SwitchingPageStyles
........................................................................................................289
OpenOffice.orgUserGuidefor2.x
xvi
PresentationStyles
..............................................................................................................289
UsingOutlineView
.................................................................................................................290
SlideTransitions,EffectsandAnimation
...............................................................................291
AutomaticSlideTransition
.................................................................................................291
EffectsforObjects
..............................................................................................................291
SelectingHiddenObjects
...................................................................................................292
IndividualPresentations
.....................................................................................................292
Exporting,PrintingandPresenting
.........................................................................................294
PrintingaPresentationSlide
..............................................................................................294
ExportingPresentationsasWebPages
...............................................................................295
ExchangingDataviatheClipboard
....................................................................................296
CreatingaBusinessReport
.....................................................................................................297
CreatingaBusinessReportinPresentationForm
..............................................................297
EnteringTextintheOutlineView
.....................................................................................298
ChangingtheSlideLayout
.................................................................................................298
DesigningSlides
.................................................................................................................298
CreatingaSlideShow
.............................................................................................................300
DefiningorChangingSlideOrder
.....................................................................................300
CreatingCross­FadeEffects
..............................................................................................300
StartingPresentations
........................................................................................................300
WorkingwithConnectors
.......................................................................................................302
"EdgetoEdge”Connectors
................................................................................................302
"MiddletoMiddle”Connectors
.........................................................................................303
EditingConnectors
.............................................................................................................303
UsingaSnapGrid
.............................................................................................................303
EditingGluePoints
............................................................................................................304
HintsandTipsforaSuccessfulPresentation
..........................................................................305
UsingtheMouseasaPointer
.............................................................................................305
ChangingBulletSymbolsinOutlineView
........................................................................305
Inserting,
DeletingandRenamingSlides
...........................................................................305
CreatingandPrintingHandouts
.........................................................................................306
OrganizingandPrintingNotes
...........................................................................................306
OpenOffice.orgUserGuidefor2.x
xvii
UsingtheNavigator
............................................................................................................307
EditJumpTargets
...............................................................................................................307
ModifyingObjectSize
.......................................................................................................307
CreatingAdditionalObjects
..............................................................................................307
ChangingFontandFontSize
............................................................................................307
Modifyingcolours
.............................................................................................................307
KeyboardNavigatingandSelectioninImpress
.................................................................308
Chapter6:
CreatingDrawingswithDraw
................................................................ ..309
OpenOffice.orgDrawFunctions
.............................................................................................309
CreatingandPublishing
VectorGraphics
..........................................................................309
Creating3DObjects
...........................................................................................................309
Manage
OrganizationCharts
..............................................................................................309
Drawing
..............................................................................................................................309
Export
.................................................................................................................................310
Construct
.............................................................................................................................310
Integrate
..............................................................................................................................310
TheOpenOffice.orgDrawWindow
........................................................................................311
ToolbarsandWindows®inOpenOffice.orgDraw
............................................................311
Drawing
RectanglesandEllipses
andEnteringText
.........................................................312
Rotatingand
ResizingObjects
...........................................................................................314
Arrangingand
AligningObjects
.............................................................................................315
ArrangingObjects
..............................................................................................................315
AligningObjects
.................................................................................................................315
Drawing
SectorsandSegments
..........................................................................................316
EnteringText
......................................................................................................................317
NormalText
........................................................................................................................317
FittingTexttoFrames
........................................................................................................317
Callouts
...............................................................................................................................318
ConvertingTextInto3D
....................................................................................................318
Drawing,EditingandConverting
...........................................................................................319
CurvesandObjects
.............................................................................................................319
DrawingCurves
.............................................................................................................319
OpenOffice.orgUserGuidefor2.x
xviii
EditingCurves
....................................................................................................................320
VectorizingBitmaps
...........................................................................................................321
ConvertingTextCharacterstoCurves
...............................................................................322
ConvertingtoCurves,Polygons,3D
..................................................................................323
WorkingWithObjects
............................................................................................................326
DuplicatingObjects
............................................................................................................326
Cross­Fading
BetweenTwoObjects
..................................................................................327
GroupingObjects
..........................................................................................................328
EnteringGroups
.............................................................................................................328
ExitingGroups
...............................................................................................................328
NavigatingBetweenObjectsofaGroup
.......................................................................329
CombiningObjectsandConstructingShapes
.........................................................................330
CombiningObjects
.............................................................................................................330
ConstructingShapes
...........................................................................................................330
Shapes­Merge
..............................................................................................................331
Shapes­Subtract
...........................................................................................................331
GraphicObjectsinDrawingsandPresentations
.....................................................................332
InsertingBitmaps
................................................................................................................332
EditingBitmaps
..................................................................................................................332
ApplyingTexttoBitmaps
.............................................................................................332
SavingBitmaps
...................................................................................................................333
WorkingWithcolours
.............................................................................................................335
T he
colourBar
....................................................................................................................335
Defining
Customcolours
....................................................................................................336
ReplacingcoloursusingtheEyedropper
............................................................................338
GradientsandPatterns
forObjectsand
Background
..............................................................340
DefiningGradients
.............................................................................................................340
Definingacustom
colourGradient
....................................................................................340
InteractivelyDefininga
colourGradient
............................................................................341
OrganizingtheAttributeTables
.........................................................................................342
3DGlobe
.................................................................................................................................343
CreatingTextureona3DObject
........................................................................................343
OpenOffice.orgUserGuidefor2.x
xix
UsingIllumination
..............................................................................................................345
More3dEffects
..................................................................................................................345
3DEffects:Favourites
...................................................................................................345
3DEffects:Geometry
....................................................................................................346
3 D
Effects:Shading
.......................................................................................................346
3DEffects:Illumination
................................................................................................347
3DEffects:TexturesandMaterial
................................................................................347
Designing3DObjectsFromFontCharacters
.........................................................................348
FirstStep:
.......................................................................................................................348
SecondStep:
..................................................................................................................349
ThirdStep:
....................................................................................................................350
FourthStep:
...................................................................................................................352
FifthStep:
......................................................................................................................353
UsingaGrid
.......................................................................................................................355
MechanicalorConstruction
Drawings
....................................................................................356
CreatingaConstructionPlan
..............................................................................................357
UsingSnapLines
...........................................................................................................361
UsingDimensionLines
......................................................................................................361
WorkingWithMultipleLayers
..........................................................................................362
UsingOne
colourperLayer
...............................................................................................363
Chapter7:Databasesand
DataSources
........................................................... ..........364
Creatinga
databasefile
...........................................................................................................364
Creatingatable
.......................................................................................................................365
Creatingarelatedtable
............................................................................................................366
Creatingarelationshipbetweentables
....................................................................................367
Creatingadataentryform
.......................................................................................................367
Makingdataentryeasier
.........................................................................................................368
Modifyinga
datefield
........................................................................................................368
Addingalistboxtoaform
.................................................................................................369
Addinga
combobox
toaform
...........................................................................................370
Changingthetaborderofaform
.......................................................................................371
ViewingData
..........................................................................................................................372
OpenOffice.orgUserGuidefor2.x
xx
Copyingtheform
...............................................................................................................372
Changingtheform'sproperties
...........................................................................................372
Settingasortorderforaform
............................................................................................372
Creatingaquerytofindtoday'sappointments
........................................................................373
Addasortordertothequery
..............................................................................................374
ChangingtheJointypeinthequery
...................................................................................374
Creatingareport
......................................................................................................................375
SometipsforusingtheCalendardatabase
.............................................................................376
Addingdatatoarelatedtable
.............................................................................................376
Opentheformfortherelatedtable
................................................................................376
Openthe
DataSources
window
.....................................................................................376
Refreshingtheform
.......................................................................................................377
FilteringData
......................................................................................................................377
Registering
aDataSource
.......................................................................................................378
Connectingtoothertypesofdatabases
...................................................................................378
AddressBooks
........................................................................................................................379
Registering
anAddressBook
.............................................................................................379
UsingtheWizardtoimportanAddressBook
...................................................................379
Manually
Registering
anExistingAddressBook
.............................................................379
SystemAddressBookasDataSource
................................................................................380
ImportingandExporting
DatainTextFormat
...................................................................380
ExportinginCSVTextFormat
..........................................................................................381
FormDesign
............................................................................................................................382
FormsinOpenOffice.org
....................................................................................................382
Availablecontrols
..........................................................................................................383
Customizingcontrols
.....................................................................................................384
Creatingagroupofoptionbuttons
................................................................................385
Doanyothercontrolshaveanwizard?
..............................................................................385
Attachingadatasourcetoaform
..................................................................................385
Associatingdatawithafield
..........................................................................................386
Activating
formcontrolsinadocument
........................................................................386
Howtousetheform
......................................................................................................387
OpenOffice.orgUserGuidefor2.x
xxi
SearchinginTablesandFormDocuments
............................................................................388
SearchingWitha
FormFilter
............................................................................................389
Operators
........................................................................................................................389
Commands
....................................................................................................................390
Chapter8:CustomizingOpenOffice.org
.................................................. ..................392
ModifyingandCustomizingtheUserInterfaceofOpenOffice.org
.......................................392
ConfiguringtheKeyboard
..................................................................................................392
ConfiguringMenus
.............................................................................................................393
ChangingToolbars
.............................................................................................................394
Inserting,Movingand
DeletingIconsonToolbars
............................................................394
ChangingIconViews
.........................................................................................................395
ChangingtheLookoftheUserInterface
................................................................................396
Selecting
MeasurementUnits
.............................................................................................396
Moving,DeletingorCopyingIcons
...................................................................................396
SendingFaxesand
ConfiguringOpenOffice.orgforFaxing
..................................................397
CreatingaLANFriendlyFaxingSolutionunderLinux
....................................................397
CreatingaLANFriendlyFaxingSolutionunderWindows
...............................................397
SendingaFaxviadialogue
.................................................................................................398
ConfiguringOpenOffice.orgforFaxingviaIcon
...............................................................398
FurtherInformation
.................................................................................................................398
Chapter9:AdvancedTechniques
...................................................... .........................399
CopyingandMoving
DataUsingDragandDrop
..................................................................399
DraggingandDroppingWithinaOpenOffice.orgDocument
...........................................399
InsertingObjects
FromtheGallery
....................................................................................399
Insertinganobjectasacopy
..........................................................................................399
Insertinganobjectasalink
...........................................................................................400
Insertinganobjectasa
backgroundgraphic
..................................................................400
Insertinganobjectasatexture(pattern)foranotherobject
..........................................400
CopyingGraphics
FromtheGallery
..................................................................................400
InsertingGraphicsFromaDocumentintheGallery
.........................................................400
CopyingGraphicsBetweenDocuments
.............................................................................401
CopyingDrawObjectsintoOtherDocuments
...................................................................401
OpenOffice.orgUserGuidefor2.x
xxii
InsertingaDrawobject
inatextdocument
........................................................................402
InsertingaDrawobject
inaspreadsheet
............................................................................403
Dragand
DropWiththe
DataSourceView
............................................................................404
Usingdatainatextdocument
............................................................................................404
Applyingdatatoatabledocument
.....................................................................................404
Insertingcontrolsinatextform
.........................................................................................404
CopyingSheetAreastoTextDocuments
...............................................................................405
InsertingDataFromSpreadsheets
......................................................................................405
InsertingDataFromTextDocuments
................................................................................405
Copying
TextUsingDragandDrop
..................................................................................406
RevisionMarkingFunction
.....................................................................................................407
RecordingandDisplayingChanges
...................................................................................407
AcceptingorRejectingChanges
........................................................................................408
ComparingVersionsofaDocument
..................................................................................409
MergingVersions
...............................................................................................................409
RecordingChanges
.............................................................................................................409
VersionManagement
..............................................................................................................410
ProtectingContentsinOpenOffice.org
...................................................................................411
ProtectingAllDocumentsWhenSaving
............................................................................411
Turningonprotection
...................................................................................................411
Turningoffprotection
...................................................................................................411
ProtectingRevisionMarking
..............................................................................................411
Turningonrevisionprotection
.....................................................................................411
Turningoffrevisionprotection
.....................................................................................411
ProtectingCellRangesinCalc
...........................................................................................411
ProtectingSectionsinWriter
..............................................................................................412
Turningonprotection
...................................................................................................412
Turningoffprotection
...................................................................................................412
ProtectingCellsinaOpenOffice.orgWriterTable
............................................................412
AutomaticProtectionofIndexesandTables
......................................................................413
Turningonprotection
...................................................................................................413
Turningoffprotection
...................................................................................................413
OpenOffice.orgUserGuidefor2.x
xxiii
Protectingframes,graphicsandOLEobjects
....................................................................413
ProtectingDrawingObjectsandFormObjects
..................................................................413
Turningonprotection
...................................................................................................413
Turningoffprotection
...................................................................................................413
ProtectingRecords
..............................................................................................................414
DigitalSignatures
andEncryption
..........................................................................................414
Overview
............................................................................................................................414
Certificates
..........................................................................................................................414
Howtogeta
Certificate?
...............................................................................................414
Self­signedcertificates
..............................................................................................415
Certificatesfroma
CertificateAuthority
..................................................................415
Integratinga
CertificatewithOpenOffice.org
....................................................................415
ChangingDefaultsandOtherConfigurationItems
................................................................416
SavingConfigurationWithDocument
...............................................................................416
InsertingandEditingTabStops
.........................................................................................416
MovingTabsontheRuler
.............................................................................................417
ChangingthePropertiesofTabs
....................................................................................417
DeletingTabs
.................................................................................................................417
ChangingtheDefaults
...................................................................................................417
Changingthe
colourofText
...................................................................................................418
InsertingLandscapepagesintoaPortrait­orientedDocument
...........................................418
MoreonTemplates
.................................................................................................................419
ChangingDefaultTemplates
..............................................................................................419
ModifyingDefaultTemplates
............................................................................................419
ResettingDefaultTemplates
..............................................................................................419
Using
CustomTemplates
...................................................................................................419
UsingOpenOffice.orgoveraNetwork
..............................................................................420
Chapter10:Introducing
OpenOffice.orgBasicandMacros
....................................421
AccessingtheSampleMacros
................................................................................................421
CallingtheSampleMacros
................................................................................................421
EditingtheSampleMacros
................................................................................................422
TheSampleMacros
.................................................................................................................423
OpenOffice.orgUserGuidefor2.x
xxiv
Documents you may be interested
Documents you may be interested