Dw2xls developer's reference

Allowed to ignore field autosize height property (new parameter n_dwr_service_parm.ib_ignore_autosizeheight)

Improved temporary file logic

Alternative way to calculate autosize height (new parameter n_dwr_service_parm.ib_nonvisual_calc_height)

Fixed problem with objects in foreground and background bands for Crosstab DWs

Added workaround for dates before 1900-03-01 which are calculated in Excel in a different way in comparison to OpenOffice and LibreOffice (see new parameter n_dwr_service_parm.ib_fix_date_base)

Allowed to switch ON/OFF dash borders for Grid DWs separately from document gridlines (see new parameter n_dwr_service_parm.ib_draw_dw_grid_lines)

Supported pictures (for OOXML format only)

Fixed problem with Footer band appeared before Summary band

Fixed problem with DDDW when in some conditions Data Column was exported instead of Display Column

Supported Suppress Repeating Values setting

Fixed n_dwr_service_parm.ib_hide_grid not working

Avoided "Mixing signed and unsigned" warnings on .NET

Solved problem with LF, CR, TAB incorrectly escaped in OOXML format

Workaround for problem with nested reports on Appeon

Special escape for control characters (supported in MS Excel OOXML format).

Reduced memory usage.

Fixed crash on big amounts of data.

Solved problem with memory usage.

Improved export into XLSX (OOXML) format so that resulting file can be opened on iOS.

Supported 64-bit applications.

Supported TreeView DW.

Supported Appeon and .NET WinForms deployments.

Fixed problem with autoheight and different DataWindow Units.

Fixed computing static X coordinates for slim objects (lines, rectangles)

Optimized memory usage optimized for DWs without expressions in X and Width

More responsive progress bar for large DWs

Fixed some problems with autosize height property for columns.

Fixed problem that caused fields with value 0 to be empty in resulting xls-file.

Solved problem with progress window blinking during export.

Fixed problem with resulting XLS-file structure that caused impossibility to open it in OpenOffice 3.2.x.

Fixed problem with empty cells that were not evaluated in Excel as blank.

Fixed problem with rectangles and autosize height property of detail band.

Fixed problem with nested reports and groups.

Added parameter ib_trim_overlapped for switching On/Off trimming of overlapping objects.

Added parameter ib_export_invisible for switching On/Off export of invisible objects.

Fixed problem with right and bottom margins processing in dll.

Fixed problem with cells format that caused number fields to have format 'Text' after export.

Fixed problem with autosizeheight property when ib_enable_merge_cells = false.

Added support for autosizeheight property of fields.

Added parameter ib_font_height_expression to n_dwr_service_parm. If FALSE then font height expressions will not be evaluated.

Fixed problem that caused file locking after process cancel.

Fixed problem with double quotes in text fields.

Fixed problem that sometimes caused computed fields to be not exported.

Added support for the new Excel file format, OOXML (XML based Excel 2007 format). Set parm.is_version = "OOXML". Default is still 97.

Added support for rectangles and solid lines (only vertical and horizontal). Set parm.ib_lines and parm.ib_rectangles. These objects are emulated using slim cells. Note, that if a line or a rectangle is too close to another cell, then it may be displayed not properly in Excel.

Added support for band background color and color expressions. Set parm.ib_background_color

Added support for exporting more than one datawindow on a single sheet. See multidwexample.htm

Overlapping objects are trimmed so that they do not overlap

Grid column's header is not exported anymore if the column is hidden

Fixed regression in 3.0.5 which caused creating of damaged XLS when some objects have negative coordinates

Fixed regression in 3.2.1 with height.autosize in detail band

Fixed exporting of objects outside band bounds

Added support for legacy user code which used some PB2XLS functions removed in DW2XLS 3.1.

Added support for DataWindow.Print.Orientation

Added support for .Font.Escapement

Fixed multipart [currency] format processing

The XLS header feature is now renamed to the XLS title. All related parameters is_header_xxxxx were renamed as well to is_title_xxxxx.

Fixed converting from Windows time format to Excel time format (added 'tt' to 'AM/PM')

Fixed setting format for large string cells (>255 chars). Now it's forced to "General"

Fixed check for Excel sheet limits: max. rows 65536, max. cols 256

Added support for XLS header text. See the is_header_xxxxx parameters in n_dwr_servce_parm

Fixed processing of detail autosizeheight + detail height = 0

Basic Treeview DW support: only leafs (without level bands)

Fixed regression in 3.1.X with conversion of ~r in strings

fixed storing wrong strings in XLS : critical bug in 3.1, upgrade is required

fixed incorrect FreeLibrary declaration causing the PB2XLS.DLL stay in memory until application exits

fixed hide_grid option processing

removed support for Excel5, now only Excel97 is supported

added support for font family and font charset properties

considerably increased the performance, up to 400% for DWs without dynamic formatting properties

Fixed processing of X > 2^16

Bands with height=0 are not exported any more

Fixed null object reference after cancelling the export

Increased the default values for slim cell merging: id_min_width = 0.5, id_min_height = 4.0

Fixed empty computes in nested crosstabs

Fixed OLE stream copy for large nested DW data

Moved to C++ some code. As of DW2XLS 3.0 a DLL, PB2XLS.DLL, is used as part of the library. It must be distributed with your application in order the export to work.

Removed the exponential dependence of export time depending on number of rows. Now it's a linear dependence.

More support for nested DWs and/or expressions for X,Y,W,H. In the previous versions, some combinations of coordinates and expressions could cause improper cell merging in XLS.

Excel columns that are tighter than the minimum column width are merged with the next column and rows that are shorter than the minumum row height are merged with the next row. This is controlled by n_dwr_service_parm parameters, id_min_width and id_min_height.

Fixed access to nested DW data in 2.0.7.

Removed the following restriction: Positioning of other nester DW or any other fields under nested DW is not allowed

Progress bar is now updated in nested DWs

Fixed access to nested DW data

More support for DDDW in nested DW

Speed optimization.

Fixed expressions support in text objects.

Added support for regional date, time, currency formats.

New option added: ib_nested (default value is true).

Fixed corruption of large Excel files.

Fixed expressions support in text property of text objects.

Fixed exporting of nested Crosstabs.

Support for Composite type added.

Support added for nested dw for DW types: Composite, Free Form, Tabular.

Restriction:
Positioning of other nester DW or any other fields under nested DW is not allowed.
During processing of nested DW lines, the position of progressbar does not change.
Autosizeheight property for nested DW and for band containing them is ignored.

Added the conversion of datawindows (datastores) to separate sheets of Excel Workbook. For detail information, see object "n_dwr_service_excel".

Added the conversion of datastores into Excel file. (See functions uf_save_ds_as_excel and uf_save_ds_as_excel_parm). Great thanks to Roland Berns for his assistance. The right of unlimited support and product upgrades for DW2XLS library is awarded to him.

New option added: ib_group_pagebreak (default value is false).

New option added: ib_group_pageheader (default value is true).

Save to Excel file more than 8126 unique text string bug fixed (Thanks to Mario Tzakov, Chris Fauvel).

Extraction of the time of value datetime bug fixed (Thanks to Matthieu WENTZINGER).

Conditional formating for all font properties(Thanks to Ronald Berns).

Default worksheet name bug fixed.

New option added: is_sheet_name (default value is 'Sheet1').

"New Page on Group Break" property processing added(Thanks to Alok Mehta).

Empty details in a grid datawindow with autoheight detail band bug fixed(Thanks to Chris Fauvel, Luis Pesaressi)

A lot of empty columns in Excel file bug fixed (Thanks to Jacob Grobman).

Last symbol missing in each function of pbl module bug fixed.

Header band missing in crosstab datawindow bug fixed (Thanks to Mario Tzakov, Allan Rath).

Format list overflow in excel file bug fixed (Thanks to Juan Carlos Hurtado Salcedo).

A lot of empty rows in Excel file bug fixed (Grid presentation style, autoheight detail band) (Thanks to Jacob Grobman).

Long text as '####...' bug fixed

Support Excel97 file format

New option added: ib_hide_grid

New option added: is_version

Support reports with N-UP presentation style

Convert date in Any variable to datetime bug fixed (Thanks to Philip Salgannik)

Support date/datetime format like "[shortdate]", "[time]" etc.

Last group trailer duplication bug fixed (Thanks to Robert Scott Harrison, Esq.)

Empty detail rows bug fixed (Thanks to Rashid A. Basu)

Developer's reference updated

Support color expression

Support background color expression

Getvalue bug fixed