Modify ↓

Opened 11 years ago

Closed 11 years ago

#2351 closed Feature Request (Completed)

_ExcelBookSaveAs format XLSX (default workbook)

Reported by: slash.cyberpunk@… Owned by:
Milestone: Component: Standard UDFs
Version: Severity: None
Keywords: excel, xlsx Cc:

Description

In beta 3.3.9.2 too.
Add const:

Global Const $xlWorkbookDefault = 51

Change in _ExcelBookSaveAs function in Excel.au3:
Before:

	If $sType = "xls" Or $sType = "csv" Or $sType = "txt" Or $sType = "template" Or $sType = "html" Then
		If $sType = "xls" Then $sType = $xlNormal
		If $sType = "csv" Then $sType = $xlCSVMSDOS
		If $sType = "txt" Then $sType = $xlTextWindows
		If $sType = "template" Then $sType = $xlTemplate
		If $sType = "html" Then $sType = $xlHtml
	Else
		Return SetError(2, 0, 0)
	EndIf

After:

	If $sType = "xls" Or $sType = "xlsx" Or $sType = "csv" Or $sType = "txt" Or $sType = "template" Or $sType = "html" Then
		If $sType = "xls" Then $sType = $xlNormal
	    If $sType = "xlsx" Then $sType = $xlWorkbookDefault
		If $sType = "csv" Then $sType = $xlCSVMSDOS
		If $sType = "txt" Then $sType = $xlTextWindows
		If $sType = "template" Then $sType = $xlTemplate
		If $sType = "html" Then $sType = $xlHtml
	Else
		Return SetError(2, 0, 0)
	EndIf

Attachments (0)

Change History (3)

comment:1 Changed 11 years ago by TicketCleanup

  • Version 3.3.8.1 deleted

Automatic ticket cleanup.

comment:2 Changed 11 years ago by guinness

This is currently in the beta v3.3.9.8.

comment:3 Changed 11 years ago by guinness

  • Resolution set to Completed
  • Status changed from new to closed

Guidelines for posting comments:

  • You cannot re-open a ticket but you may still leave a comment if you have additional information to add.
  • In-depth discussions should take place on the ​forum.

For more information see the full version of the ticket guidelines here.

Add Comment

Modify Ticket

Action
as closed The ticket will remain with no owner.
Author


E-mail address and user name can be saved in the Preferences.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.