February 22nd, 2011· Conversion of XLS/XLSX files. When specifying sheets whose name contains a dash character "-" it would not work if the 'Convert XLS' conversion method was being used.
· You can now specify a range of sheets by sheet name.
February 22nd, 2011· Special Processing of XLS/XLSX files: If users didn't specify an extension in the OUTPUT file an error would sometimes occur. An extension will automatically be added if none exists.
January 6th, 2011· Conversion of XLSX: "Treat Values As Text" was not functioning. Leading zeroes were being dropped.
November 10th, 2010· Conversion of csv to xls,xlsx: spaces and double quotes may have been dropped
· Conversion of XLSX: Roundoff issues resolved
October 23rd, 2010· Command Line: When using special process 109, control characters like carraige return and line feed were not getting passed properly.
October 23rd, 2010· Conversion of xlsx: Dates weren't getting handled properly
· Conversion of xlsx: If regional settings were such that a comma is used for decimal point, issues sometimes occurred.
September 30th, 2010· Special Processes: When specifying a target file with the wild card, the file extension of the output files did not always use what was specified.
September 24th, 2010· Special Process 117 added, Delete All Empty Sheets from workbook.
September 24th, 2010· When converting XLS or XLSX to Unicode (42) and using the MS Excel method, while specifying more than one sheet, only one sheet was present in the output.
September 24th, 2010· Windows 7 compatibility enhancements made. Default report folders now updated. Fixed width \Profiles\ folder now placed according to operating system for example. If Vista or greater see the %appdata%\Profiles\ folder, otherwise c:\Program Files\Sofinterface, Inc\ConvertXLS\Profiles\
· Working well now with Office 2010
July 8th, 2010· Conversion: When the input file was XLSX and there were more than 27 columns the output would be problematic. Columns after the 27th would be problematic.
June 2nd, 2010· Language: Japanese language module updated.
May 25th, 2010· Command Line: Special process 113 Print Excel Sheets: If the /4 switch (number of copies to print) was not specified, this command line would fail.
May 16th, 2010· Special process 115 Import Tables from document, has been enhanced for Office 2007 and greater.
May 13th, 2010· Conversion: When converting to/from an Excel file, a new option "Treat values as text" has been added (see Options button, then Excel tab). Use this option to retain leading zeroes (i.e. 000101023) when converting from txt or csv to xls for example. This option can be enabled by using the /D switch from the command line.
· Conversion: Some XLSX columns were not coming out perfectly.
April 22nd, 2010· When using the 'Convert XLS' conversion and choosing a sheet within the OPTIONS button area, the error 'Unable to get Excel Properties' was occurring when xlsx files were being used as the Input file.
· If users saves SII file, we add existing conversion item if none exists in the list.
March 10th, 2010· Conversion: When using the 'Convert XLS' conversion method and converting from TXT or CSV, the conversion would stop after 128 empty lines were detected.
March 10th, 2010· Conversion: When using the 'Convert XLS' conversion method, converting a input XLS file, if an incorrect sheet was specified no error was being reported.
· Conversion: When using the 'Convert XLS' conversion method, if an input file was open in another application, no sharing violation error was being reported.
· Conversion: When using the 'Convert XLS' conversion method, converting xls files, formulas were not being converted properly.
March 10th, 2010· Search and replace was failing with a text file, when trying to replace a double quote
February 12th, 2010· Japanese language file updated
February 12th, 2010· User Interface: If users launch the target file and it does not exist, now it opens the folder in explorer.
February 12th, 2010· Help system completely rewritten. CHM help file now used, and web help is there for backup.
· User Interface: The terms "Original" and "Target" file have been replaced with the more intuitive "Input" and "Output" respectively.
February 12th, 2010· Localization: Japanese language file updated.
· Special Process, Search And Replace. When replacing with nothing, the user interface would not update properly. It would work fine however.
December 3rd, 2009· Command Line: A new test batch file called TestCommandLine.bat has been added to the installation folder. This should exercise the command line, and be a good guide for future command line users.
· Command Line: We've made it much faster for any conversion/process not requiring Excel.
· Command Line: Special Processes that used MS Excel, had an issue.
· User Interface: When XLSX is chosen for the input file, the status bar now shows more details of what options are chosen
· User Interface: Picking input and output files, the filter should be more appropriate
December 3rd, 2009· User Interface: Is faster for those processes not requiring MS Excel. An unnecessary check was being done with MS Excel, if installed on each run. Command line was already streamlined.
December 3rd, 2009· User Interface: Upon completion of a Conversion Job, the status bar now flashes 100% complete. If minimized, the taskbar flashes to indicate completion.
· User Interface: When running the scheduler, if program is minimized the time remaining shows up in the task bar.
· User Interface: When running the scheduler, PAUSE button now enabled to halt scheduler.
October 17th, 2009· Conversion: XLS to CSV/TXT using the 'Convert XLS' conversion method. Some xls files were problematic.
· Command Line: "Runtime error 380" was popping up. Happened when users selected MS Excel in the user interface, however, used the 'Convert XLS' method in the command line. Finally fixed in 4.092.
October 17th, 2009· Conversion: CSV to XLS usng the 'Convert XLS' conversion method. Fields with unusually large text strings were being truncated.
October 17th, 2009· Conversion: For some extremely large XLS files the conversion would say completed but no output file existed.
October 17th, 2009· Conversion: For input xls files created in OpenOffice conversion would sometimes be incorrect.
October 17th, 2009· Move the input (original) file after processing has been added as a 'program option'. See the FileOptions menu or the Options button in the user interface. This will be very helpful for those looking to use the scheduler to convert a specific folder of files while avoiding redundant conversions.
October 17th, 2009· Command Line: When users are not using MS Excel, upon exit the program was attempting to kill any instances of Excel. This was removed, and therefore the command line should be a bit faster now.
October 17th, 2009· Conversion of XLS, XLSX to TXT, CSV etc. Fractional values getting lost in the conversion.
October 17th, 2009· Conversion of XLS, XLSX to TXT, CSV etc. Column B formatting (number of decimal places) was getting lost.
· Conversion of XLSX, sheet 2 Cell A1, sometimes did not convert completely. Error introduced on 7/14/2009 and removed on 7/15/2009.
June 5th, 2009· Conversion of XLSX: Conversion sometimes lost textual data, numeric data seemed fine in some cases.
May 30th, 2009Command Line: Full path not required for /S /T /L /I /B and /J. If the full path is not specified it is assumed the current folder will be used. If the current folder path is invalid, then the folder that contains ConvertXLS.exe will be used. This makes it easy to specify the command line like so:
· ConvertXLS.EXE /S "input.CSV" /T"Output File.XLS" /C-4143 /F6 /M2
May 2nd, 2009· Usability: Most Recently Used Conversion Job files now available from the FILE menu item
January 15th, 2009· Conversion of XLS Files. Certain xls files when converted to CSV, the output would be "Ge0eral".
November 18th, 2008· Special Process (114 Run a Macro): If the original and target file were the same file, it would never save the xls file even if this option was chosen.