Message-ID: <1521209865.10385.1711723301694.JavaMail.web05$@web05>
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_Part_10384_812216771.1711723301694"
------=_Part_10384_812216771.1711723301694
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Location: file:///C:/exported.html
Below are a list of added features and bug fixes that are incorp=
orated for 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 Se=
rvices Integration
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
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 Integration
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.
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 Integration
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
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 Integration
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 Integration
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 Integration
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 Integration
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 Integration
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 Integration
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 Integra=
tion, and Installer
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 Services 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 Integration
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 Integration
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.
------=_Part_10384_812216771.1711723301694--