What's new
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 |
