Message-ID: <2025870232.8109.1711632404660.JavaMail.web05$@web05>
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_Part_8108_547373019.1711632404660"
------=_Part_8108_547373019.1711632404660
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Location: file:///C:/exported.html
Below is a list of added features and bug fixes that are incorpo=
rated for each minor build of OfficeWriter 4.x.
=20
=20
OfficeWriter 4.6.1
=
=20
Released July 5, 2011
=20
ExcelWriter 7.6.1
=
=20
Features Added
=20
=20
- ExcelApplication is now 20% faster and requires 20% less memory
=20
=20
Issues Resolved
=20
=20
- Specific formula caused "Unreadable Content" error in XLSX fi=
le processed by ExcelTemplate in SSRS
=20
- ExcelWriter would return the wrong default character width for Calibri =
- size 11
=20
- ExcelApplication threw an exception when parsing some SSRS 2008 generat=
ed Excel files
=20
- Chart text was not properly set to "Automatic" by default
=20
- Data Series in charts were sometimes not sequenced correctly
=20
- GetHeader and GetFooter threw NullReferenceException when called on new=
ly created worksheets
=20
=20
WordWriter 4.6.1
=20
There were no changes made for 4.6.1.
=20
Reporti=
ng Services Integration 4.6.1
=20
Issues Resolved
=20
=20
- Specific formula caused "Unreadable Content" error in XLSX fi=
le processed by ExcelTemplate in SSRS
=20
- Opening an RDL in the OfficeWriter Designer threw a "Type Mismatch=
" error with certain regional settings
=20
=20
=20
OfficeWriter 4.6.0
=
=20
Released April 4, 2011
=20
ExcelWriter 7.6.0
=
=20
Features Added
=20
=20
- Data markers in Pivot Table cells are no longer processed explicitly (w=
ith data being brought in) or implicitly (with blank rows added to the shee=
t), as described in the new EWTemplates =
and Pivot Tables (deprecated) page=20
=20
- Pivot Table templates no longer require dummy data
=20
- Pivot Table templates no longer require edit copies set not to refresh =
on open
=20
- Shapes and Charts can be placed beside Pivot Tables
=20
=20
- Sparklines now preserved in Excel 2010 created file when processed by E=
xcelTemplate
=20
=20
Issues Resolved
=20
=20
- ExcelTemplate threw an error on Excel 2010-created files with Excel 200=
3-format pivot tables
=20
- Shapes such as charts stretched when placed next to pivot tables that w=
ere filled using ExcelTemplate
=20
- ExcelWriter generated files no longer open in protected mode in Excel 2=
010
=20
=20
WordWriter 4.6.0
=20
Features Added
=20
=20
- Since the WordTemplate COM-callable wrapper is no longer installed, Wor=
dWriter is no longer installed in the Global Assembly Cache (GAC).
=20
=20
Issues resolved
=20
=20
- Some files processed by WordTemplate, then WordApplication, caused erro=
rs when opened in Word 2010
=20
- WordWriter threw an error when repeat blocks were in tables in template=
s created using Word 2010
=20
=20
Reporti=
ng Services Integration 4.6.0
=20
Issues Resolved
=20
=20
- Reporting Services 2008 R2 formulas did not work in OfficeWriter Report=
ing Services integration for Word
=20
- OfficeWriter Designer did not read Reporting Services 2008 formulas fro=
m the RDL files
=20
=20
Installer
=20
Features Added
=20
=20
- ExcelWriter COM and the WordTemplate COM-callable wrapper are no longer=
automatically installed during the OfficeWriter installation process. Bits=
are available upon request.
=20
=20
=20
OfficeWriter 4.5.1
=
=20
Released January 25, 2011
=20
ExcelWriter 7.5.1
=
=20
Features Added
=20
=20
Issues Resolved
=20
=20
- Issues with PivotCharts in ExcelTemplate=20
=20
- PivotCharts missing data in ExcelTemplate reports when streamed to clie=
nt
=20
- PivotCharts lose series formatting in OOXML (Excel 2007) file format=20
=20
- ExcelTemplate did not work with template files created in Excel 2010=20
- ExcelTemplate did not throw an error if file format limits on the numbe=
r of characters in a cell were exceeded.
=20
- Processing certain files with comments using ExcelTemplate created a co=
rrupt file
=20
- Calling ExcelTempla=
te.Process() on files were certain formulas threw an "Unrecognizab=
le symbol" exception.
=20
- ExcelApplication did not throw an error if file format limits on the nu=
mber of characters in a cell were exceeded.
=20
- Horizontal page breaks could not be inserted on worksheets created usin=
g Worksheets.CopySheet<=
/a>
=20
- PageSetup attributes were not ap=
plied to worksheets created using Worksheets.CopySheet
=20
- Merging some spreadsheets created using Crystal Reports resulted in a c=
orrupt workbook.
=20
- A number of Charting API issues in ExcelApplication=20
=20
- Setting Series.Label.ContainsValue broke formatting
=20
- Setting DataPoint.Interior.Pattern corrupted some files
=20
- Data Labels set in code not visible in Excel 2003
=20
- Picture chart fills cause an exception to be thrown when patterns are r=
ead
=20
- ExcelApplication fails to parse Legend visibility correctly
=20
- Some files were corrupted when a Series was removed from a SeriesCollec=
tion
=20
- Setting a CategoryData formula to a multi-column range threw an invalid=
formula exception
=20
=20
- ColumnProperties.Au=
toFitWidth() entered an infinite loop on columns with certain NumberFor=
mat settings
=20
- Cell.Formula threw an excepti=
on when attempting to read a formula referencing an external workbook using=
VLookup
=20
- Some files generated with ExcelTemplate created corrupt files when open=
ed and saved in ExcelApplication
=20
=20
WordWriter 4.5.1
=20
Issues Resolved
=20
=20
- WordTemplate created a corrupted file when processing two IF fields
=20
- WordTempalte threw an exception or produced a corrupt file when process=
ing a template with IF fields containing other fields
=20
- Merging a document with a programmatically-created table into another d=
ocument threw an index out of bounds exception
=20
- After replacing an object in a header or footer using Element.SearchAndReplace=
a>, the next call to SearchAndReplace() threw a WordWriterException
=20
- Watermark object can now access waterm=
arks in input files
=20
- Watermark was not able to insert new w=
atermarks
=20
- Setting some table styles using WordApplication caused formatting issue=
s and corrupted tables
=20
- Merging two documents using Document.Append caused corrupted output in some cases
=20
- Opening and saving a file created using a non-English version of Word c=
aused formatting issues
=20
=20
Reporti=
ng Services Integration 4.5.1
=20
Features Added
=20
=20
- OfficeWriter Designer now supports reports built using Report Builder 3=
.0
=20
=20
Issues Resolved
=20
=20
- Reporting Services reports created with the OfficeWriter Designer broke=
reports when an Oracle data source was used.
=20
=20
Installer
=20
Issues Resolved
=20
=20
- License Key Manager threw error when being run on a machine with no Sof=
tArtisans license keys in the registry.
=20
=20
=20
OfficeWriter 4.5.0
=
=20
Released September 21, 2010
=20
ExcelWriter 7.5.0
=
=20
Features Added
=20
=20
Issues Resolved
=20
=20
- ExcelTemplate can now process files created using Microsoft's OOXML SDK=
=20
=20
- Process method no longer throws exception when processing a worksheet c=
opied using Microsoft's OOXML SDK
=20
- Process method no longer throws exception when processing a workbook wi=
th a large number of worksheets copied using Microsoft's OOXML SDK
=20
=20
- Issues with deleting worksheets in workbooks=20
=20
- Deleting a Worksheet in a Workbook with Worksheet-level named ranges no=
longer corrupts the output spreadsheet
=20
- Deleting a Worksheet in a Workbook with Workbook-level named ranges no =
longer throws an "Unable to parse formula" exception when Save is=
called
=20
- Calling PageSetup.S=
etPrintTitleRows or PageSetup.SetPrintTitleColumns on the last sheet of a workbook, then d=
eleting the worksheet no longer throws exception on Save
=20
=20
- Improved Grouping and Nesting Support=20
=20
- Headers and Footers are no longer printed when the data source is empty=
=20
- Data marker modifiers now also work on %%value() markers
=20
- Merged cells are now preserved in spreadsheets with Grouping and Nestin=
g
=20
- Conditional formatting copied from a header or footer to a data marker =
row using paste special -> formats is now preserved
=20
- Shared formulas in headers or footers are changed to equivalent regular=
formulas, rather than causing a corrupt output spreadsheet
=20
=20
- ExcelTemplate.Proce=
ss() issues with some templates=20
=20
- Process no longer fails on a small number of template files that had pr=
eviously caused it to fail
=20
- Process no longer throws a "Cannot find last DBCELL record" a=
fter being first opened in ExcelApplication
=20
- Process no longer throws a "Sheet was not in expected location&quo=
t; error after being first opened in ExcelApplication
=20
=20
- Shape.FillTransparency<=
/a> no longer inverts its value
=20
- Cell values on sheets created using Worksheets.CopySheet no longer reference incorrect val=
ues
=20
- Calling ColumnPrope=
rties.AutoFitWidth() on a column with a custom NumberFormat no longer causes an Out of Memory exception<=
/li>=20
- R1C1-style formulas no longer cause an "Unable to parse formula&qu=
ot; exception
=20
- Improved ability to handle spreadsheets generated by Crystal Reports=20
=20
- ExcelWriter can now open some files generated by Crystal Reports that h=
ad previously been impossible to open
=20
- Small bmp files can now be copied from Excel spreadsheets generated thr=
ough Crystal Reports
=20
=20
=20
WordWriter 4.5.0
=20
Features Added
=20
=20
- WordWriter SharePoint Integrat=
ion=20
=20
- WordWriter can now use SharePoint Lists and Views as data sources
=
=20
- WordWriter can now save documents as Document Library items or List Ite=
m attachments
=20
=20
- New WordTemplate.SaveExte=
nsion property returns the extension of the template file that has been=
opened
=20
- New Document.Append method appends one Document to another, preserving all Sections, includin=
g header and footers plus other section formatting
=20
- WordWriter now supports Grouping and Nesting with the WordTemplate object
=20
=20
Issues resolved
=20
=20
- Improved WordTemplate support for Open Office XML format=20
=20
- Newline characters now handled correctly by WordTemplate in the Open Office XML file format
=20
- Support for all Open Office XML file extensions (.docm, .dotx, and .dot=
m all are now supported)
=20
=20
- Deleting table rows containing merge fields within a bookmark no longer=
damages the bookmark, allowing the template to populate without corrupting=
the output document
=20
- Binding an empty DataTable to a template using WordTemplate.SetRepeatBlock no longer throws an =
exception, but instead removes bookmark
=20
- Inserting content into a header with field no longer causes a corrupt d=
ocument
=20
- Custom styles preserved when two Document=
a> objects are merged using the Document.InsertAfter method
=20
- Word documents with images with text wrapping settings other than "=
;Inline with Text" no longer corrupted when opened and saved using Wor=
dApplication
=20
- Setting TableFormatting.Au=
toWidth to true no longer fails to have any effect; columns set to Auto=
using Table.SetPreferredColumnWidthUnits will now have t=
heir widths automatically calculated
=20
=20
Reporti=
ng Services Integration 4.5.0
=20
No changes were made for 4.5.0
=20
=20
OfficeWriter 4.1.0
=
=20
Released November 30, 2009
=20
ExcelWriter 7.1.0
=
=20
Features Added
=20
=20
- ExcelTemplate can process files created with Microsoft's Office Open XM=
L (OOXML) SDK
=20
- Nesting and grouping formatting enabled for OOXML files. For more infor=
mation, see Creating Data Markers
=20
=20
Issues Resolved
=20
=20
- Compiler error thrown while using ChartType enumeration in Visual Studi=
o 2008
=20
- Several issues addressed regarding support for files created by the nat=
ive Excel renderer from SQL Server Reporting Services 2008=20
=20
- Accessing worksheets threw object reference exceptions
=20
- Creating a chart and adding a series corrupted the output file
=20
- Adding or removing rows or columns, copying worksheets, or creating a n=
amed range threw an internal casting exception
=20
- Creating a range from one or more areas threw a parser exception
=
=20
- Accessing or changing colors in the Palette threw Invalid Color Index e=
xception
=20
=20
- Several issues addressed regarding support for files created by the nat=
ive Excel renderer from SQL Server Reporting Services 2005=20
=20
- Missing shared string table from some spreadsheets threw Object Referen=
ce exception
=20
- ColumnProperty.ApplyStyle() failed to get Style interface unless Worksh=
eet.PopulatedCells was first accessed
=20
=20
- ExcelWriter did not process three-letter columns correctly when referen=
cing cells, for example "AAA4"
=20
- AutoFitWidth threw IndexOutOfBounds exception for column with formula f=
ormatted as number
=20
- Calling ApplyStyle() or SetStyle() on a ColumnProperties object referen=
cing a column with a formula in it threw an Object Reference exception
=
=20
- Setting CharacterRun.Font properties for more than 586 cells corrupted =
the file
=20
- Setting CORREL function with Application object displayed "#VALUE&=
quot; until user clicked on the cell
=20
- ExcelTemplate.ExcludeMacros property now available when working with OO=
XML files
=20
- Strings that looked like data markers after a formula is evaluated were=
treated like data markers
=20
- The wrong content-type header was being sent when streaming OOXML files=
to the user, causing some browsers to treat them as BIFF8 (.xls) files
=20
- ExcelTemplate no longer inserts a 0 for Null values brought into an OOX=
ML template using a DataReader
=20
=20
WordWriter 4.1.0
=20
Features Added
=20
=20
- WordTemplate can evaluate formulas for Word 2007 OOXML file format file=
s (.docx/.docm). For more information, see Creating Merge Fields
=20
=20
Issues Resolved
=20
=20
- Deleting an element in a table made in Word 2007 corrupted the output d=
ocument in some cases
=20
- Deleting a row in a table also deleted the value in the first cell of t=
he next row
=20
- In some cases documents with embedded images threw Out of Memory except=
ions
=20
- Calling Document.Search() on a document with an empty field threw a sta=
ck overflow exception
=20
- Inserting many images with WordTemplate caused some images not to displ=
ay
=20
=20
Reporti=
ng Services Integration 4.1.0
=20
Issues resolved
=20
=20
- OfficeWriter Designer threw an error when attempting to publish a 2008 =
RDL with a Report Global embedded using the Insert Formula button
=20
- OfficeWriter Designer threw data source exception when a query was asso=
ciated with a row in a table in a Word Document
=20
- OfficeWriter Designer did not allow exporting Excel 2007 files with mac=
ros as RDLs
=20
- OfficeWriter Designer's RDL parser thew an Unknown Exception for report=
model data sources with field names containing fewer than 5 characters
=20
=20
=20
OfficeWriter 4.0.0
=
=20
Released June 3, 2009
=20
ExcelWriter 7.0.0
=
=20
Features Added
=20
=20
- ExcelWriter is written in pure C# .NET and no longer has a dependency o=
n the J# runtime
=20
- ExcelTemplate supports Excel 2007 OpenOXML (OOXML) files with .xlsx, .x=
lsm, .xltx, and .xltm extensions
=20
- Support for creating and viewing ExcelWriter files in Excel 2007
=
=20
- Ability to iterate over all named ranges in a worksheet or workbook
=20
- New Shape.FillTranspare=
ncy property added
=20
- Ability to bind data to an individual worksheet with the DataBindingProperties object
=20
- Support for unicode in data markers
=20
- New Cell.GetTextHeight and GetTextWidth methods for autofitting merged =
cells
=20
- New InsertRows() and InsertColumns() methods
=20
- Performance improvements:=20
=20
- ExcelTemplate + ExcelApplication=20
=20
- Processes binary (XLS) files up to 50% faster
=20
- Blank cell optimizations results in 400% improvement in speed and memor=
y usage when using ExcelTemplate and ExcelApplication together
=20
=20
- ExcelTemplate=20
=20
- Formulas are processed up to twice as fast
=20
- Reduced memory usage
=20
- Ability to bind data only to a specific worksheet
=20
=20
- ExcelApplication=20
=20
- Faster algorithm for style optimization
=20
- Improved performance when opening existing files and setting column wid=
ths
=20
- Formulas can be inserted up to 8 times faster and improved performance =
for the formula parser
=20
- Improved autofit algorithm
=20
=20
=20
=20
WordWriter 4.0.0
=20
Featured Added
=20
=20
- Support for Office Open XML (OOXML) files in WordTemplate with .docx, d=
ocm, dotx, dotm file extensions
=20
- Support for creating and viewing files in Word 2007 including:=20
=20
- Support for new themes, styles, table formatting options, hapes, charts=
, and diagrams
=20
=20
- Written in pure #C .NET and no longer depends on J# runtime
=20
- Ability to evaluate IF fields
=20
- New EnableNextFields property
=20
- New SetMailMerge functionality to mimic Microsoft Word mail merge
=
=20
- Improvements to performance=20
=20
- WordTemplate uses 40x less memory with OOXML files when processing larg=
e files or importing large amounts of data
=20
- WordTemplate is 35% when processing large binary (DOC) files
=20
- WordApplication is up to 6x faster when processing binary files
=20
=20
- HMTLtoWord open source project for importing HTML into WordWriter docum=
ents
=20
=20
Reporti=
ng Services Integration 4.0.0
=20
Features Added
=20
=20
- Full SQL Server Reporting Services 2008 support
The OfficeWriter Designer now supports the em=
bedding of Excel and Word within reports for SQL Server Reporting Services =
2008.
=20
- Add real Excel and Word to reports designed in Visual Studio 20=
08
The OfficeWriter Designer a=
lso now supports reports designed in Visual Studio 2008 and Report Builder =
2.0, allowing the addition of Excel and Word versions to an existing report=
.
=
li>=20
- Office Open XML Format support
In SoftArtisans OfficeWriter version 4, the Office Open XML fo=
rmat (.docx and .xlsx; .docm and .xlsm) is now supported.
=20
- Significant performance improvements
Improvements with memory efficiency in underlying ExcelW=
riter and WordWriter DLLs can lead to significant performance gains
=20
- Unicode Field Names in Data Markers
Data markers can now include any Unicode character except=
brackets [] and braces {}
=20
- Unicode Data Source Names with Excel Reports
Excel reports now accept any Unicode character i=
n data source names =20
------=_Part_8108_547373019.1711632404660--