Message-ID: <632958345.9201.1711679812873.JavaMail.web05$@web05>
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_Part_9200_519946684.1711679812873"
------=_Part_9200_519946684.1711679812873
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Location: file:///C:/exported.html
=20
Icon=20
=20
The OfficeWriter Change Log lists the new features and bug fixe=
s in every supported minor and major build of the product.
Current su=
pported builds are v9.0.0 - v9.1 and 8.0.0-8.6.2
OfficeWriter includes several components that are developed on separatel=
y, so features and fixes are listed by component:
- ExcelWriter - .NET API
- WordWriter - .NET API
- PowerPointWriter - .NET API
- Reporting Services - SSRS Integration, including the OfficeWriter D=
esigner and Renderers for Excel and Word
- Installer - Components not related to the functionality of the prod=
uct, including the installer and license key manager.
=20
=20
=20
OfficeWriter 9.x
Below are a list of added features and bug fixes that are incorporated f=
or each minor build of OfficeWriter 9.x
OfficeWriter 9.1
ExcelWriter
New Features
All new features are implemented for XLSX/XLSM files on=
ly unless otherwise indicated.
Enhancements
All enhancements are implemented for XLSX/XLSM files on=
ly unless otherwise indicated.
Bug Fixes
- Issue when reading/writing certain PageSetup object prope=
rties resolved.
PowerPointWriter
- No changes were made to PowerPointWriter in 9.1&=
nbsp;
WordWriter
New Features
No changes were made to WordWriter in 9.1
Reporting Se=
rvices Integration
New Features
Installer
- The OfficeWriter installer no longer removes V8 License k=
eys when installing OfficeWriter 9.
- The OfficeWriter installer no longer automatically instal=
ls the OfficeWriter Designer. Please install the OfficeWriter Designer .NET=
separately.
OfficeWriter 9.0
ExcelWriter=
p>
New Features
PowerPointWriter
New Features
- Template Object (see PowerPointTemplate API)
- Application Object: Copy Slide, Delete Slide, Align Images, Document Pr=
operties
WordWriter
New Features
- Add missing outer HTML tags to HTML documents used with the document mo=
difier
Reporting Services Inte=
gration
No changes were made to Reporting Services Integration in 9.0.0=
Installer
New Features
- Handles multiple license keys
- Automatically selects components to install based on license keys
OfficeWriter 8.x
Below are a list of added features and bug fixes that are incorporated f=
or each minor build of OfficeWriter 8.x
OfficeWriter 8.6.2
ExcelWriter
No changes were made to ExcelWriter in 8.6.2
WordWriter
New Features
All new features are implemented for WordTemplate DOCX/DOCM only unl=
ess otherwise indicated.
- Ability to ignore certain merge fields when processing with WordTemplat=
e
Reporting Services Inte=
gration
No changes were made to Reporting Services Integration in 8.6.2=
Installer
Issues Resolved
- Installer fails on certain environments with SharePoint 2010 and SSRS 2=
008 R2 in integrated mode
=
p>
OfficeWriter 8.6.1
ExcelWriter
New Features
All new features are implemented for XLSX/XLSM files only unless oth=
erwise indicated.
Issues Resolved
All issues are resolved in ExcelApplication for XLSX/XLSM files only=
unless otherwise indicated.
- Custom pivot table styles were corrupted after opening and saving the f=
ile
- Minor chart tick line position and visibility were set incorrectly
- Copying and deleting a worksheet with custom print properties caused co=
rrupt output
- ExcelWriter threw Invalid ST_PatternType error on save
- Importing large 0 values with ImportData caused corrupt output
- Setting ShowEquation and ShowRSquaredValue had no effect (XLS files onl=
y)
WordWriter
New Features
All new features are implemented for WordTemplate DOCX/DOCM only unl=
ess otherwise indicated.
Issues Resolved
All issues are resolved in WordTemplate DOCX/DOCM only unless otherw=
ise indicated.
- WordWriter threw invalid hexidecimal character error on machines with m=
ulti-core CPUs
Reporting Services Inte=
gration
Issues Resolved
- ImportTemplate button not disabled in report view in Excel and Word Des=
igners
- Word designer hangs when viewing reports with long parameter names, lon=
g report names, or are stored in deeply nested report server directories
Installer
Issues Resolved
- Unable to install OfficeWriter 8.5.1 or 8.6.0.
=
p>
OfficeWriter 8.6.0
Release September 25, 2013
ExcelWriter
New Features
All new features are implemented for XLSX/XLSM files only unless oth=
erwise indicated.
- Enhanced performance for opening files with extensive formulas in Excel=
Application
- ExcelApplication PivotTable API=
supports classic=
layout
- Sparkline support for ExcelTemplate
- Sparklines that point to data markers are updated
- Sparklines in data marker rows are copied for each new row
Issues Resolved
All issues are resolved in ExcelApplication for XLSX/XLSM files only=
unless otherwise indicated.
- Cell references in data labels for Excel 2013 files were not preserved<=
/li>
- ExcelWriter throws index out of bounds exception when setting =
ColumnProperties.Width =
to 0 if the column contains an anchor for an image
- PivotTables created from mixed case data (i.e. "Half Price" v=
s. "half price") produced corrupt output
- Special characters written to Cell.=
Value were not encoded correctly
- ExcelTemplate throws key not present in dictionary exception w=
hen a worksheet with data markers and a text box is deleted with Worksheets.Delete(String)
WordWriter
No changes were made to WordWriter in 8.6.0
Reporting Services Inte=
gration
New Features
- New OfficeWriter Designer .NET with support for 64-bit and 32-bit Excel=
- Import an existing Excel template into an RDL through the OfficeWriter =
Designer for Excel
- Import an existing Word template into an RDL through the OfficeWriter D=
Esigner for Word
=
p>
OfficeWriter 8.5.1
Release July 1, 2013
ExcelWriter
New Features
All new features are implemented for XLSX files only unless otherwis=
e indicated
- ImportData() option to treat merged cells as though they aren't merged
- Available also in XLS files
- ExcelTemplate and ExcelApplication Save() returns a generated XLSX file=
as a new memory stream
Issues Resolved
All issues are resolved in ExcelApplication for XLSX files only unle=
ss otherwise indicated
- Accessing a character runs in merged cells caused an error when using C=
opyPaste
- Setting a formula on a merged area had no effect
- Image files are locked after inserting with ExcelApplication
- Unable to modify an image after inserting with ExcelApplication
- Unable to close a file stream for an image after inserting with ExcelAp=
plication
- CopySheet causes output files to crash in Excel 2013
- 2013 call-out data label formatting was stripped out of files
- Convert Strings (released in 8.4) does not affect column headers
- Series.ScatterValues returns an empty string for scatter charts
- Delay the parsing of invalid shared formulas
- Sheet names that start with C or R are not wrapped in quotations when r=
eferenced in formulas
- Files bloat after copying a selection with filters and freeze panes
WordWriter
No changes were made to WordWriter in 8.5.1.
Reporting Services Inte=
gration
New Features
- ExcelTemplate.LicenseKey and WordTemplate.LicenseKey can be set globall=
y in web.config for SSRS
- OfficeWriter Designer for Excel can now 'View' reports with multi-value=
d parameters
Issues Resolved
- OfficeWriter Designer for Word detects incorrect Word version in region=
s where decimal separator is a comma
- Designer installer correctly checks for required Microsoft security upd=
ates.
Installer
New Features
- Installer works on machines with .NET 4.0 and 4.5
- License Key manager works on machines with .NET 4.0 and 4.5
- Installer works with SSRS 2012 in SharePoint integrated mode against Sh=
arePoint 2010 and 2013
OfficeWriter 8.5.0
Released May 8, 2013
ExcelWriter
New Features
- ExcelTemplate allows data markers in tab names of XLSX/XLSM files
- ExcelApplication support for remaining Excel 2007, 2010, and 2013 formu=
las:
- Excel 2007:
- DATESTRING, LEFTB, LENB, MIDB, NUMBERSTRING
- IFERROR, DBCS, USDOLLAR, GETPIVOTDATA
- EFFECT, FVSCHEDULE, INTRATE, MDURATION, NOMINAL, RECEIVED, TBILLEQ, XIR=
R, XNPV
- ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, CUMIMPT, CUMPRINC, DISC, DOLLAR=
DE, DOLLARFR, DURATION, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PRICE, =
PRICEDISC, PRICEMAT, TBILLPRICE, TBILLYIELD, YIELD, YIELDDISC, YIELDMAT
- COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD
- BESSELI, BESSELJ, BESSELK, BESSELY, COMPLEX, CONVERT, DELTA, ERF, ERFC,=
GESTEP
- IMABS, IMAGINARY, IMARGUMENT, IMCONJUGATE, IMCOS, IMDIV, IMEXP, IMLN, I=
MLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSIN, IMSQRT, IMSUB, IMSUM
- BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC,=
HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
- CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESE=
T, CUBSETCOUNT, CUBEVALUE
- Excel 2010:
- NETWORKDAYS.INTL, WORKDAY.INTL
- ERF.PRECISE, ERFC.PRECISE
- AGGREGATE, CEILING.PRECISE, FLOOR.PRECISE, ISO.CEILING
- BETA.DIST, BETA.INV, BINOM.DIST, BINOM.INV, CHISQ.DIST, CHISQ.DIST.RT, =
CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, CONFIDENCE.NORM, CONFIDENCE.T, COVARIA=
NCE.P, COVARIANCE.S, F.DIST, F.DIST.RT, F.INV, F.INV.RT, F.TEST, GAMMA.DIST=
, GAMMA.INV, LOGNORM.DIST, LOGNORM.INV, MODE.MULT, MODE.SNGL, NORM.DIST, NO=
RM.INV, NORM.S.DIST, NORM.S.INV, PERCENTILE.EXC, PERCENTILE.INC, PERCENTRAN=
K.EXC, PERCENTRANK.INC, QUARTILE.EXC, QUARTILE.INC, RANK.AVG, RANK.EQ, STDE=
V.P, STDEV.S, VAR.P, VAR.S, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, =
T.TEST, ECMA.CEILING, EXPON.DIST, GAMMALN.PRECISE, HYPEGEOM.DIST, NEGBINOM.=
DIST, POISSON.DIST, WEIBULL.DIST, Z.TEST
- Excel 2013:
- ACOT, ACOTH, ARABIC, BASE, CEILING.MATH, COMBINA, COT, COTH, CSC, CSCH,=
DECIMAL, FLOOR.MATH, SEC, SECH
- BION.DIST.RANGE, GAMMA, GAUSS, PERMUTATIONA, PHI, SKEW.P
- BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR, IMCOSH, IMCOT, IMCSC, IMCS=
CH, IMSEC, IMSECH, IMSINH, IMTAN
- DAYS, ISOWEEKNUM
- ENCODEURL, FILTERXML, WEBSERVICE
- FORMULATEXT, IFNA, ISFORMULA, NUMBERVALUE, PDURATION, RRI, SHEET, SHEET=
S, UNICHAR, UNICODE, XOR
Issues Resolved
All issues are resolved in ExcelApplication for XLSX files only unle=
ss otherwise indicated
- CopySheet between workbooks
- Print titles and print areas are now copied
- Normal font is copied
- Column widths from original workbook copied
- Auto filters copied correctly
- Fixes to formulas
- File with worksheet range created on workbook level throws error on ope=
n
- Unable to parse conditional format formulas with multiple escape quotes=
- Delayed parsing of formulas from Open to only when necessary (see KB po=
st for more information)
- Textboxes/Shapes
- Textboxes containing formulas resulted in corrupt output
- Textbox with Japanese type facing throws object reference exception
- Textbox with no text is not editable after open/save
- Shape.Text returned empty string instead of cached text
- Setting Shape.Text on an existing text box containing a formula had no =
affect
- Textboxes, images, shapes containing formulas not recognized as valid f=
ile
- FitToPagesWide did not work in XLSX files
- Deleting a column changes VBA UsedRange property to apply to entire wor=
ksheet
- XLSX files with grouped Active-X controls not recognized as valid files=
- Custom page size throws error
- Category Axis and Value Axis not displaying correctly in Excel 2010
- Error processing chart with two named ranges as data source
WordWriter
New Features
- Document modifier now supports insert DOCX files into DOCX/DOCM files=
li>
Reporting Services Inte=
gration
New Features
Issues Resolved
- OfficeWriter Designer can now install against 32-bit Office 2013
OfficeWriter 8.4.0
Released February 12, 2013
ExcelWriter
New Features
Issues Resolved
- XLSX files with worksheets created by CreateWorksheet() do not open on =
a Blackberry
- Hyperlinks copied with CopySheet do not update the display name in Exce=
l 2007
- Using SetConditionalFormat to copy conditional formats between workbook=
s corrupts the formatting
- ExcelWriter removes VBA digital signatures from XLSM files when opened =
with ExcelApplication
- ActiveX objects converted to images in XLSM files opened with ExcelAppl=
ication
- Certain named styles caused worksheet count to be zero
- ExcelApplication does not handle array formulas that contain external r=
eferences in XLSX files
WordWriter
New Features
Reporting Services Inte=
gration
No changes were made the Reporting Services Integration for OfficeWr=
iter 8.4.0.
OfficeWriter 8.3.0
Released November 1, 2012
ExcelWriter
All changes are for ExcelApplication in XLSX files unless otherwise indi=
cated.
Features Added
- Ability to set auto filters pro=
grammatically
- ExcelWriter can parse the following 2007 formulas:
- IsEven, IsOdd, FactDouble, GCD, LCM, MROUND, Multinomial, Quotient, Ser=
iessum, sqrpi, sumifs, Edate, EoMonth, Networkdays, Weeknum, Workday, Yearf=
rac
- ExcelTemplate and ExcelApplication: S=
upport for opening ExcelWriter-generated OOXML files on iPhone, iPad
Issues Resolved
- ExcelWriter fails to add worksheets that contain formulas that it canno=
t parse
- Error thrown when 3D charts data source referenced a name range
- Shared VLOOKUP formula referencing named range threw exception
- CopySheet did not update the chart series formula
- Setting PageSetUp properties before calling CopySheet threw a Null refe=
rence exception
- Error when legacy shapes contain line breaks in text
- Error when Excel form controls contain line breaks in text
- Formulas that referenced external workbooks threw an exception
- ExcelTemplate threw "Stream does not support reading" excepti=
on when running against .NET 4.5
WordWriter
Features Added
- WordTemplateTemplate and WordApplication: Support for opening WordWriter-generated OOXML files on iPhone, iPad=
li>
Issues Resolved
- WordTemplate opened in protected mode if importing no rows of data in D=
OC files
- WordTemplate threw "Stream does not support reading" exceptio=
n when running against .NET 4.5
Reporting Services Inte=
gration
Issues Resolved
- SSRS 2008 R2 formulas not correctly deleted from the OfficeWriter Desig=
ner for Excel
- Designer corrupted an RDL file if the report contained more than 10 SSR=
S formulas
OfficeWriter 8.2.1
Released July 10, 2012
ExcelWriter
Issues Resolved
- Settings=
LineAreaScatter.ShowDropLines always read as True
- Copying worksheets that contained tables with Worksheets.CopySheet produced corrupt output=
- Null reference exception thrown when modifying certain XLSX files gener=
ated by Apache POI
- "Value cannot be parsed as a number" exception thrown when tr=
ying to parse Cell.Value on a Swedi=
sh machine
WordWriter
No changes were made for v8.2.1
Reporting Services Inte=
gration
Issues Resolved
- Designer threw "Compile error: Method or data member not found&quo=
t; when publishing reports to or retrieving reports from the report server<=
/li>
OfficeWriter 8.2.0
Released June 27, 2012
ExcelWriter
Features Added
Issues Resolved
Template Object
Application Object
- Active X objects in Excel 2010 XLSM files are converted into images
- "Given key was not present" exception thrown when a list box =
form control is on a chart sheet
- Using a named range in a data validation causes ExcelWriter to ignore c=
ertain worksheets
- ExcelWriter generated XLSX files are set to 300 dpi by default instead =
of 600 dpi
- ExcelWriter is unable to read certain cell values in files generated by=
SSRS 2012 built in EXCEL export option
- RowProperties.Style and RowProperties.ApplyStyle() do not set the style=
s correctly if the cell value is written before the style is applied
- FreezePane.ColumnNumber returns the incorrect value
- If RANDBETWEEN was dragged between cells in a file, ExcelWriter throws =
an exception
- ExcelWriter is accessing a static dictionary in a non-thread safe manne=
r
- ExcelWriter throws exception on certain files generated with Apache POI=
WordWriter
Features Added
Reporting Services Int=
egration
Features Added
- Support for native SQL Server Reporting Services 2012
- Updated Designer copyright dates
Issues Resolved
- Formulas in some SSRS 2008 reports disappeared after opening the report=
in Visual Studio
Installer
Features Added
- Updated End User License Agreement
- OfficeWriter Designer Installer provides useful message when trying to =
install against a 64-bit version of Office
Issues Resolved
- License Key Manager version doesn't match release version
- Installer did not unpack SSRS dlls under Program Files
OfficeWriter 8.1.2
Released April 30, 2012
ExcelWriter, WordWriter, Reporting Services Integration, and Ins=
taller
Issues Resolved
- OfficeWriter 8 was not FIPS compliant, which prevented installing or ru=
nning OfficeWriter 8 on FIPS-enabled machines. This fix has been applied to=
all OfficeWriter 8 components.
OfficeWriter 8.1.1
Released April 19, 2012
ExcelWriter and WordWriter
No changes were made for v8.1.1
Reporting Ser=
vices Integration and Installer
Issues Resolved
- The OfficeWriter Designer 8.1.0 installer required VB6 (for Office 2007=
) to be installed. The OfficeWriter Designer 8.1.1 installer requires etihe=
r VB6 (Office 2007) or VB7 (Office 2010) to be installed.
OfficeWriter 8.1.0
Released March 28, 2012
ExcelWriter
Features Added
Issues Resolved
Template Object
- No exception thrown when rows of imported data exceeds file format limi=
t
- Cultures with different thousand separators cause corrupt output in OOX=
ML files
- Rows pushed down when using pivot tables in OOXML files
Application Object
- Getting a data label for a data point puts x-axis values in chart legen=
d
- Deleting a row with conditional formatting causes a file error in Excel=
2007/2010
- Hyperlink.Href returns null value instead of a valid link
- Exception thrown if chart legend has a background fill
The following fixes apply only to OOXML files:
- SoftArtisans.OfficeWriter.ExcelWriter.XMLModel at index does not ex=
ist exception thrown
- Unable to create hyperlinks in a merged area adjacent to another merged=
area
- Workbook.UseRCFo=
rmulaNotation always returned false
WordWriter
Features Added
Issues Resolved
- Table.InsertRow=
s takes the formatting from the first row of the table
- WordTemplate image modifier does not scale images correctly in OOXML fi=
les
Reporting Services Int=
egration
Features Added
- New ribbon design for Office 2007/2010 in Excel and Word
- OfficeWriter Designer support for Office 2010
Issues Resolved
- Designer in Excel hangs when previewing reports after changing multiple=
parameter values
Installer
Features Added
- Redesigned and improved installer for the OfficeWriter Designer
OfficeWriter 8.0.0
Released November 30, 2011
ExcelWriter
Features Added
- Complete support for Excel 2007/2010 (XLSX) file formats with ExcelAppl=
ication
Issues Resolved
- Deleting the last remaining worksheet in a Workbook throws an exception=
on call to Save instead of on Delete
- Passing a non-seekable Stream object to a method when creating a pictur=
e will throw an exception
- Merged cells next to data markers on adjacent rows causes corrupt outpu=
t
- License Manager tool displays popup twice when upgrading OfficeWriter k=
ey
- ExcelWriter allowed setting of invalid font sizes, which resulted in wa=
rnings in Excel 2010
- Incorrect default character width ysed for default font
WordWriter
Features Added
Reporting Services Int=
egration
No changes were made for 8.0.0.
Installer
Features Added
- Redesigned and improved kit for installing .NET, Reporting Services, an=
d SharePoint solutions on 32-bit and 64-bit systems.
OfficeWriter 4.x
Below is a list of added features and bug fixes that are incorporated fo=
r each minor build of OfficeWriter 4.x.
=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
Reporting Services I=
ntegration 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
Reporting Services I=
ntegration 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
Reporting Services I=
ntegration 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
Reporting Services I=
ntegration 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
Reporting Services I=
ntegration 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
Reporting Services I=
ntegration 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
=20
------=_Part_9200_519946684.1711679812873--