Spreadsheet Link™ EX Release
Notes
How to Contact The MathWorks
www.mathworks.
comp.soft-sys.matlab Newsgroup
www.mathworks.com/contact_TS.html Technical Support
suggest@mathworks.com Product enhancement suggestions
bugs@mathwo
doc@mathworks.com Documentation error reports
service@mathworks.com Order status, license renewals, passcodes
info@mathwo
com
rks.com
rks.com
Web
Bug reports
Sales, prici
ng, and general information
508-647-7000 (Phone)
508-647-7001 (Fax)
The MathWorks, Inc.
3 Apple Hill Drive
Natick, MA 01760-2098
For contact information about worldwide offices, see the MathWorks Web site.
Spreadsheet Link™ EX Release Notes
© COPYRIGHT 2004–20 10 by The MathWorks, Inc.
The software described in this document is furnished under a license agreement. The software may be used
or copied only under the terms of the license agreement. No part of this manual may be photocopied or
reproduced in any form without prior written consent from The MathW orks, Inc.
FEDERAL ACQUISITION: This provision applies to all acquisitions of the Program and Documentation
by, for, or through the federal government of the United States. By accepting delivery of the Program
or Documentation, the government hereby agrees that this software or documentation qualifies as
commercial computer software or commercial computer software documentation as such terms are used
or defined in FAR 12.212, DFARS Part 227.72, and DFARS 252.227-7014. Accordingly, the terms and
conditions of this Agreement and only those rights specified in this Agreement, shall pertain to and govern
theuse,modification,reproduction,release,performance,display,anddisclosureoftheProgramand
Documentation by the federal government (or other entity acquiring for or through the federal government)
and shall supersede any conflicting contractual terms or conditions. If this License fails to meet the
government’s needs or is inconsistent in any respect with federal procurement law, the government agrees
to return the Program and Docu mentation, unused, to The MathWorks, Inc.
Trademarks
MATLAB and Simulink are registered trademarks of The MathWorks, Inc. See
www.mathworks.com/trademarks for a list of additional trademarks. Other product or brand
names may be trademarks or registered trademarks of their respective holders.
Patents
The MathWorks products are protected by one or more U.S. patents. Please see
www.mathworks.com/patents for more information.
Summary by Version ............................... 1
Version 3.1.1 (R2010a) Spreadsheet Link EX
Software
........................................ 4
Contents
Version 3.1 (R2009b) Spreadsheet Link EX Software
Version 3.0.3 (R2009a) Spreadsheet Link EX
Software
........................................ 6
Version 3.0.2 (R2008b) Spreadsheet Link EX
Software
........................................ 7
Version 3.0.1 (R2008a) Spreadsheet Link EX
Software
Version 3.0 (R2007b) Excel
Version 2.5 (R2007a) Excel
Version 2.4 (R2006b) Excel
Version 2.3.1 (R2006a) Excel
Version 2.3 (R14SP3) Excel
........................................ 8
®
Link Software ........... 9
®
Link Software ........... 11
®
Link Software ........... 12
®
Link Software ......... 13
®
Link Software ........... 14
.. 5
Version 2.2 (R14) Excel
®
Link Software .............. 16
Compatibility Summary for Spreadsheet Link EX
Software
........................................ 17
iii
iv Contents
SummarybyVersion
This table provides quick access to new features in each version. For
clarification, see “Using Release Notes” on page 2 .
Spreadsheet Link™ EX Release Notes
Version
(Release)
Latest Versi
V3.1.1 (R201
V3.1 (R2009b)
V3.0.3 (R2009a)
V3.0.2 (
V3.0.1 (R2008a)
V3.0 (R2007b)
(R2007a)
V2.5
on
0a)
R2008b)
Ver sion
New Features
and Changes
No No No
Yes
Details
No No Bug Repor
No No Bug Reports
No No Bug Reports
Yes
ls
Detai
Yes
Details
Compatibility
Considerations
No Bug R eports
No No No
No No No
Fixed Bugs
and Known
Problems
at W eb site
ts
at W eb si
at W eb site
at W eb site
te
Related
Documentation
at Web Site
Printable
Release Notes:
PDF
Current product
documentation
No
No
No
No
V2.4 (R2006b)
V2.3.1 (R2006a)
.3 (R14SP3)
V2
V2.2 (R14)
Yes
Details
No No Bug
Yes
Details
Yes
Details
No No No
at W
No Bug R eports
at W eb site
No No No
Reports
eb site
No
No
1
Spreadsheet Link™ EX Release Notes
Using Release Notes
Use release notes when upgrading to a newer version to learn about:
• New features
• Changes
• Potential impact on your existing files and practices
Review the release notes for other MathWorks™ products required for this
product (for example, MATLAB
bugs, or compatibility considerations in other products impact you.
If you are upgrading from a software version other than the m ost recent one,
review the current release notes and all interim versions. For example, when
you upg rade from V1.0 to V1.2, review the release notes for V1.1 and V1.2.
®
or Simulink®). Determine if enhancements,
What Is in the Release Notes
New Features and Changes
• New functionality
• Changes to existing functionality
Version Compatibility Con si derations
When a new feature or change introduces a reported incompatibility between
versions, the Compatibility Considerations subsection explains the
impact.
Compatibility issues reported after the product release appear under Bug
Reports at The MathWorks™ Web site. Bug fixes can sometimes result
in incompatibilities, so review the fixed bugs in Bug Reports for any
compatibility impact.
2
SummarybyVersion
Fixed Bugs and Known Problems
The MathWorks offers a user-searchable Bug Reports database so you can
view Bug Reports. The development team updates this database at release
time and as more information becomes available. Bug Reports include
provisions for any known workarounds or file replacem ents. Information is
available for bugs existing in or fixed in Release 14SP2 or later. Information
is not avail able for all bugs in earlier releases.
Access Bug Reports using y our MathWorks Account.
3
Spreadsheet Link™ EX Release Notes
Version 3.1.1 (R2010a) Spreadsheet Link EX Software
This table summarizes what’s new in Version 3.1.1 (R2010a):
Version
New Features and
Changes
No No No
Compatibility
Considerations
There are no new features or changes in this version.
Fixed Bugs an d
Known Problems
Related
Documentation at
Web Site
Printable Release
Notes: PDF
Current product
documentation
4
Version 3.1 (R2009b) Spreadsheet Link™ EX Software
Version 3.1 (R2009b) Spreadsheet Link EX Software
This table summarizes what’s new in Version 3.1 (R2009b):
New Features and
Changes
Yes
Details below
Version
Compatibility
Considerations
No Bug Reports
New features and changes follow.
• “New Method for Invoking Excel
®
• “Excel
on page 5
Link Softw are Integrated with Microsoft®Excel Ribbon Interface”
Fixed Bugs an d
Known Problems
at Web site
®
Link” on page 5
Related
Documentation at
Web Site
No
New Method for Invoking Excel Link
Excel®Link™ now supports the ability to highlight columns in Microsoft
Excel®worksheettoinvokeExcelLink.
®
Excel Link Software Integrated with M icrosoft Excel
Ribbon Interface
Excel Link software is now integrated with the Microsoft Excel 2007 ribbon
interface.
5
Spreadsheet Link™ EX Release Notes
Version 3.0.3 (R2009a) Spreadsheet Link EX Software
This table summarizes what’s new in Version 3.0.3 (R2009a):
Version
New Features and
Changes
No No Bug Reports
Compatibility
Considerations
There are no new features or changes in this version.
Fixed Bugs an d
Known Problems
at Web site
Related
Documentation at
Web Site
No
6
Version 3.0.2 (R2008b) Spreadsheet Link™ EX Software
Version 3.0.2 (R2008b) Spreadsheet Link EX Software
This table summarizes what’s new in Version 3.0.2 (R2008b):
Version
New Features and
Changes
No No Bug Reports
Compatibility
Considerations
There are no new features or changes in this version.
Fixed Bugs an d
Known Problems
at Web site
Related
Documentation at
Web Site
No
7
Spreadsheet Link™ EX Release Notes
Version 3.0.1 (R2008a) Spreadsheet Link EX Software
This table summarizes what’s new in Version 3.0.1 (R2008a):
Version
New Features and
Changes
No No Bug Reports
Compatibility
Considerations
There are no new features or changes in this version.
Fixed Bugs an d
Known Problems
at Web site
Related
Documentation at
Web Site
No
8
Versi o n 3.0 (R2007b) Excel®Link™ Software
Version 3.0 (R2007b) Excel Link Software
This table summarizes what’s new in Version 3.0 (R2007b):
New Features and
Changes
Yes
Details below
Version
Compatibility
Considerations
No No No
New features and changes follow.
• “MATLAB Function Wizard for the Excel
• “MATLAB Preferences Pane” on page 9
Fixed Bugs an d
Known Problems
®
Link Software” on page 9
Related
Documentation at
Web Site
MATLAB Function Wizard fortheExcelLinkSoftware
This function wizard enables you to browse MATLAB directories and run
functions from within the Microsoft Excel interface. You can use it to:
• Display a list of all MATLAB function categories or directories.
• Choose a particular directory or category, and list functions available for
that directory or category.
• Parse a specified function signature and enter a formula into the current
spreadsheet cell using
MATLABFCN or MATLABSUB.
• Display online help headers for functions.
For more information, see Using the MATLAB Function Wizard fo r Excel
Link Software in the Excel Link documentation.
MATLAB Preferences Pane
You can set selected MATLAB preferences from within the Excel Link GUI by
using the Preferences dialog box. This new feature enables you to:
9
Spreadsheet Link™ EX Release Notes
• Automatically start a MATLAB session when a Microsoft Excel session
starts.
• Specify the current working directory for your MATLAB session at startup.
• Start the MATLAB desktop, including the current directory, workspace,
command history and command window panes, when a Microsoft Excel
session starts.
• Enable the
MLPutMatrix function to use cell arrays for transfer of data
between a Microsoft E xcel worksheet and the MATLAB w orkspace.
• Set data in missing or empty cells to
NaN or zero.
For more information on Excel Link Preferences, see Setting Excel Link
Preferences in the Excel Link documentation.
10
Versi o n 2.5 (R2007a) Excel®Link™ Software
Version 2.5 (R2007a) Excel Link Software
This table summarizes what’s new in Version 2.5 (R2007a):
New Features and
Changes
Yes
Details below
Version
Compatibility
Considerations
No No No
New features and changes follow.
• “Functions Added” on page 11
• “Excel
®
Link Software Qualified Against Microsoft®Excel Version 2007
Beta” on page 11
Fixed Bugs an d
Known Problems
Related
Documentation at
Web Site
Functions Added
This release supports the following new functions:
•
MLMissingDataAsNaN sets em pty cells to NaN or zero.
MLUseCellArray toggles MLPutMatrix to always use MAT LAB cell arrays.
•
Excel Link Software Qualified Against Microsoft Excel
Version 2007 Beta
Excel Link software has been qualified against Microsoft Excel Version 2007
Beta.
11
Spreadsheet Link™ EX Release Notes
Version 2.4 (R2006b) Excel Link Software
This table summarizes what’s new in Version 2.4 (R2006b):
New Features and
Changes
Yes
Details below
Version
Compatibility
Considerations
No No No
New features and changes follow.
• “New Functions Added” on page 12
Fixed Bugs an d
Known Problems
Related
Documentation at
Web Site
New Functions Added
This releases supports the following new functions:
•
MLGetFigure imports a MATLAB figure into a Microsoft Excel spreadsheet.
MLStartDir specifies the current working directory for a MATLAB session
•
after startup.
•
MLUseFullDesktop specifies whether to use the full MATLAB desktop or
only the Command Window.
•
MLShowMatlabErrors uses MLEvalString to return standard Spreadsheet
Link™ EX errors or full MATLAB errors.
12
Version 2.3.1 (R2006a) Excel®Link™ Software
Version 2.3.1 (R2006a) Excel Link Software
This table summarizes what’s new in Version 2.3.1 (R2006a):
Version
New Features and
Changes
No No Bug Reports
Compatibility
Considerations
There are no new features or changes in this version.
Fixed Bugs an d
Known Problems
at Web site
Related
Documentation at
Web Site
No
13
Spreadsheet Link™ EX Release Notes
Version 2.3 (R14SP3) Excel Link Software
This table summarizes what’s new in Version 2.3 (R14SP3):
New Features and
Changes
Yes
Details below
Version
Compatibility
Considerations
No No No
New features and changes follow.
• “MATLAB Desktop Enabled” on page 14
• “New System Requirements” on page 14
Fixed Bugs an d
Known Problems
Related
Documentation at
Web Site
MATLAB Desktop Enabled
Version2.3oftheExcelLinksoftwareusestheMATLABsoftwareasaCOM
automation server with the full desktop displayed.
New System Requirements
Excel Link softw are requires approximately 202 kilobytes of disk space.
Operating system requirements are:
• Microsoft
®
Windows®XP
14
• Microsoft Windows 2000
Excel L ink software requires one of the following versions of Microsoft Excel
software:
• Excel
• Excel 2000 software
• Excel 2002 software
• Excel 2003 software
®
98 software
Version 2.3 (R14SP3) Excel®Link™ Software
Excel Link software also requires Version 5.1 or later of the MATLAB for
Windows software.
15
Spreadsheet Link™ EX Release Notes
Version 2 .2 (R14) Excel Link Software
This table summarizes what’s new in Version 2.2 (R14):
New Features and
Changes
Yes
Details below
Version
Compatibility
Considerations
No
New features and changes follow.
• “Using Excel
®
Link S oftware i n a N on -English Environment” on page 16
Fixed Bugs an d
Known Problems
No bug fixes
Related
Documentation at
Web Site
No
Using Excel Link Software in a Non-English
Environment
The Spreadsheet Link EX User’s Guide uses the Microsoft Excel
software with an English (United States) Microsoft Windows regional
setting for illustrative purpo ses. If you use E xcel Link software with a
non-English (United States) Windows desktop environment, certain
syntactical elements may not work as illustrated. For example, you may have
to replace the comma (
with a semicolon (
Please consult your Windows documentation to determine which regional
setting differences exist among various international versions.
,) delimiter within Spreadsheet Link EX commands
;) or other operator.
16
Compatibility Summary for Sprea dsheet Link™ EX Software
Compatibility Summary for Spreadsheet Link EX Software
This table summarizes new features and changes that might cause
incompatibilities when you upgrade from an earlier version, or wh en you
use files on multiple versions. Details are provided with the description of
the new feature or change.
New Features and Changes with Version
Version (Re lease)
Compatibility Impact
Latest Version
V3.1.1 (R2010a)
V3.1 (R2009b)
V3.0.3 (R2009a)
V3.0.2 (R2008b)
V3.0.1 (R2008a)
V3.0 (R2007b)
V2.5 (R2007a)
V2.4 (R2006b)
V2.3.1 (R2006a)
V2.3 (R14SP3)
V2.2 (R14)
None
None
None
None
None
None
None
None
None
None
None
17
Loading...