What's new
Version 5.1.12 Release 29.01.2019
Allowed to ignore field autosize height property (new parameter n_dwr_service_parm.ib_ignore_autosizeheight)
|
Version 5.1.11 Release 30.04.2018
Improved temporary file logic
|
Alternative way to calculate autosize height (new parameter n_dwr_service_parm.ib_nonvisual_calc_height)
|
Version 5.1.10 Release 03.08.2017
Fixed problem with objects in foreground and background bands for Crosstab DWs
|
Version 5.1.9 Release 04.07.2017
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)
|
Version 5.1.8 Release 13.10.2016
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)
|
Version 5.1.7 Release 13.09.2016
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
|
Version 5.1.6 Release 31.08.2016
Supported Suppress Repeating Values setting
|
Fixed n_dwr_service_parm.ib_hide_grid not working
|
Avoided "Mixing signed and unsigned" warnings on .NET
|
Version 5.1.5 Release 12.07.2016
Solved problem with LF, CR, TAB incorrectly escaped in OOXML format
|
Workaround for problem with nested reports on Appeon
|
Version 5.1.4 Release 07.06.2016
Special escape for control characters (supported in MS Excel OOXML format).
|
Version 5.1.3 Release 13.05.2016
Reduced memory usage.
|
Fixed crash on big amounts of data.
|
Version 5.1.2 Release 12.05.2016
Solved problem with memory usage.
|
Version 5.1.1 Release 22.01.2016
Improved export into XLSX (OOXML) format so that resulting file can be opened on iOS.
|
Version 5.1.0 Release 16.08.2015
Supported 64-bit applications.
|
Supported TreeView DW.
|
Supported Appeon and .NET WinForms deployments.
|
Version 4.1.5 Release 19.07.2012
Fixed problem with autoheight and different DataWindow Units.
|
Version 4.1.4 Release 02.07.2012
Fixed computing static X coordinates for slim objects (lines, rectangles)
|
Version 4.1.3 Release 30.06.2012
Optimized memory usage optimized for DWs without expressions in X and Width
|
More responsive progress bar for large DWs
|
Version 4.1.2 Release 09.12.2010
Fixed some problems with autosize height property for columns.
|
Fixed problem that caused fields with value 0 to be empty in resulting xls-file.
|
Version 4.1.1 Release 03.11.2010
Solved problem with progress window blinking during export.
|
Version 4.1.0 Release 27.10.2010
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.
|
Version 4.0.9 Release 10.08.2010
Fixed problem with rectangles and autosize height property of detail band.
|
Version 4.0.8 Release 29.06.2010
Fixed problem with nested reports and groups.
|
Version 4.0.7 Release 15.04.2010
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.
|
Version 4.0.6 Release 24.02.2010
Fixed problem with right and bottom margins processing in dll.
|
Version 4.0.5 Release 05.02.2010
Fixed problem with cells format that caused number fields to have format 'Text' after export.
|
Version 4.0.4 Release 03.02.2010
Fixed problem with autosizeheight property when ib_enable_merge_cells = false.
|
Version 4.0.3 Release 25.12.2009
Added support for autosizeheight property of fields.
|
Version 4.0.2 Release 23.12.2009
Added parameter ib_font_height_expression to n_dwr_service_parm.
If FALSE then font height expressions will not be evaluated.
|
Version 4.0.1 Release 28.10.2009
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.
|
Version 4.0 Release 01.03.2009
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
|
Version 3.2.3 Release 26.06.2008
Fixed regression in 3.0.5 which caused creating of damaged XLS when some objects have negative coordinates
|
Version 3.2.2 Release 19.06.2008
Fixed regression in 3.2.1 with height.autosize in detail band
|
Version 3.2.1 Release 18.06.2008
Fixed exporting of objects outside band bounds
|
Version 3.2 Release 28.02.2008
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
|
Version 3.1.8 Release 18.02.2008
Fixed multipart [currency] format processing
|
Version 3.1.7 Release 16.11.2007
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"
|
Version 3.1.6 Release 08.11.2007
Fixed check for Excel sheet limits: max. rows 65536, max. cols 256
|
Version 3.1.5 Release 01.11.2007
Added support for XLS header text. See the is_header_xxxxx parameters in n_dwr_servce_parm
|
Version 3.1.4 Release 17.07.2007
Fixed processing of detail autosizeheight + detail height = 0
|
Version 3.1.3 Release 18.06.2007
Basic Treeview DW support: only leafs (without level bands)
|
Fixed regression in 3.1.X with conversion of ~r in strings
|
Version 3.1.2 Release 02.04.2007
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
|
Version 3.1 Release 27.03.2007
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
|
Version 3.0.5 Release 28.02.2007
Fixed processing of X > 2^16
|
Version 3.0.4 Release 23.02.2007
Bands with height=0 are not exported any more
|
Version 3.0.3 Release 19.02.2007
Fixed null object reference after cancelling the export
|
Version 3.0.2 Release 19.02.2007
Increased the default values for slim cell merging: id_min_width = 0.5, id_min_height = 4.0
|
Version 3.0.1 Release 13.02.2007
Fixed empty computes in nested crosstabs
|
Fixed OLE stream copy for large nested DW data
|
Version 3.0 Release 18.11.2006
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. |
Version 2.1.0 Release 22.06.2006
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
|
Version 2.0.7 Release 22.05.2006
Fixed access to nested DW data
|
More support for DDDW in nested DW
|
Version 2.0.6 Release 18.01.2006
Version 2.0.5 Release 03.11.2005
Fixed expressions support in text objects.
|
Added support for regional date, time, currency formats.
|
Version 2.0.4 Release 13.07.2005
New option added: ib_nested (default value is true). |
Version 2.0.3 Release 29.06.2005
Fixed corruption of large Excel files. |
Version 2.0.2 Release 29.05.2005
Fixed expressions support in text property of text objects. |
Version 2.0.1 Release 27.05.2005
Fixed exporting of nested Crosstabs. |
Version 2.0 Release 11.04.2005
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. |
Version 1.4.0 Release 15.09.2004
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). |
Version 1.3.4 Release 11.05.2004
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). |
Version 1.3.3 Release 15.04.2004
Empty details in a grid datawindow with autoheight detail band bug fixed(Thanks to Chris Fauvel, Luis Pesaressi) |
Version 1.3.2 Release 05.04.2004
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). |
Version 1.3.1 Release 22.03.2004
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 |
Version 1.3 Release 15.02.2004
Support Excel97 file format |
New option added: ib_hide_grid |
New option added: is_version |
Support reports with N-UP presentation style |
Version 1.2 Release 13.01.2004
Convert date in Any variable to datetime bug fixed (Thanks to Philip Salgannik) |
Support date/datetime format like "[shortdate]", "[time]" etc. |
Version 1.1 Release 24.11.2003
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 |
Version 1.0 Release 31.10.2003
Support color expression |
Support background color expression |
Getvalue bug fixed |