#Workbook to Strict Open XML Spreadsheet

[file-formats-programming]

Save Workbook to Strict Open XML Format & Rendering Comments from ODP using .NET

What's New in this Release?

Aspose team is happy to share the announcement of Aspose.Slides for .NET 18.8. This is primarily a maintenance release whereby Aspose team has added support for some new features as well. This release has introduced some important new features, such as Add support for Strict Open XML format, Rendering of Metafiles ignores fonts loaded with FontsLoader, Rendering comments from ODP format that have no author and support for “purl.oclc.org” namespace in Type attribute in “.rels” parts. There are some important enhancements and bug fixes also part of this release such Rendering presentation with large amount of data in charts consumes all available memory, Existing PPTX table cells changes formatting after assigning text, The embedded data stream is disposed, enhanced PPT to PDF export, Presentation saving in PPS format is fixed, Border around text appears after saving the PPT file, Setting and getting PlotArea X, Y values now working, Data Format label lost when saving pptx, enhnaced rendering of external fonts in SVG, Chart rendering in generated thumbnail is fixed, Chart changes after right click on edit data and many more. This list of new, improved and bug fixes in this release are given below

Add support for Strict Open XML format.

Rendering of Metafiles ignores fonts loaded with FontsLoader.

Rendering comments from ODP format that have no author.

Support for “purl.oclc.org” namespace in Type attribute in “.rels” parts.

Rendering presentation with large amount of data in charts consumes all available memory.

Existing PPTX table cells changes formatting after assigning text.

The embedded data stream is disposed.

PPT to PDF not properly converted.

When PPTX is converted to PDF, picture gets blurred.

An exception PptxReadException raises while loading the presentation.

Exception when cleaning/updating metadata of Strict Open XML Presentation (.pptx).

Presentation is not saved in PPS format.

Corrupt PDF is generated if Small Caps text is used in presentation.

Title text in All Caps is rendered as normal as exported PDF.

Border around text appears after saving the PPT file.

Axis Labels are not showing in the generated PDF file.

EffectTriggerType properties are not working as expected.

Chart failed to get edited in PowerPoint if series names are same.

PPT presentation can’t contains more than 8 placeholders on PPT saving.

Insufficient header length exception on presentation load.

Setting and getting PlotArea X, Y values not working.

Logo of embedded empty equation block rendered incorrectly.

PPTX not converted properly to PDF.

SVGOptions.DeletePicturesCroppedAreas works incorrect.

Set range not working.

Data Format label lost when saving pptx.

Pie chart percentage labels are incorrectly rendered in thumbnail.

Saving PPTX to PDF can cause text in pie chart labels to be lost.

Chart not properly converted to PDF.

Improper render of external fonts in SVG.

Text get missing and overlapped when exporting to PDF Notes.

PPTX not properly converted to PDF.

Chart is improperly rendered in generated thumbnail.

Strikethrough portion rendering issue.

Exception on loading or saving presentation.

Setting data label position is not working in Box and Whisker chart.

Changing of data labels font size and color has no effect in output presentation.

Presentation repair message on opening the Aspose.Slides saved presentation after chart.ChartData.SetRange(range) in PP 2013.

Chart changes after right click on edit data.

Charts or Images are improperly rendered in generated PDF.

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Slides for Java documentation that may guide users briefly how to use Aspose.Slides for performing different tasks like the followings.

Save Workbook to Strict Open XML Spreadsheet Format

Converting ODP PPT to PPTX

Overview: Aspose.Slides for .NET

Aspose.Slides is a .NET component to read, write and modify a PowerPoint document without using MS PowerPoint. PowerPoint versions from 97-2007 and all three PowerPoint formats: PPT, POT, PPS are also supported. Now users can create, access, copy, clone, edit and delete slides in their presentations. Other features include saving PowerPoint slides into PDF, adding & modifying audio & video frames, using shapes like rectangles or ellipses and saving presentations in SVG format, streams or images.

More about Aspose.Slides for .NET

Homepage of Aspose.Slides for .NET

Downlaod of Aspose.Slides for .NET

Online documentation of Aspose.Slides for .NET

[professorexcel]

XLSX, XLSM or XLSB: Which File Type Is the Best for You?

Probably 99% of all Excel workbooks are saved in the XLSX file type these days. But there are various other file extensions available: For example XLSM, XLSB or “older” Excel users might still remember the XLS file type. What are the differences of these file types? And even more important: Which one should you use?

    File types

Excel provides 29 different file types when you save your Excel workbook.

When you save an Excel workbook for the first time or use the “Save As” function, you are asked for a folder, file name as well as the file type. By default, Excel suggests the XLSX file type (unless your file doesn’t have VBA macros). The window looks similar to the screenshot on the right side.

So which file type are you going to use? The answer – like so often: It depends. Before we conclude in a decision tree, we we take a look at the most important file extensions in Excel with their advantages and disadvantages first.

  XLSX

The “default” file extension is XLSX. The large majority of Excel workbooks uses this format these days. Microsoft says in the Excel help text about the XLSX file format:

The default XML-based file format for Excel 2007-2013. Cannot store Microsoft Visual Basic for Applications (VBA) macro code […].

Most of the time you use the XLSX format: It’s save (can’t store malicious code), has the maximum number of rows and columns and is best known. XLSX is available since Excel 2007 and replaces the old XLS file type. It uses the open XML standard so which is documented well.

Knowing these quick facts, there are the following advantages and disadvantages for the XLSX file format:

Advantages Disadvantages

The default file format and because of that the best known and widest spread file type.

Can use up to 2^20 (1048576) rows and 2^14 (=16384) columns.

Uses the open file format and is in general accessible with other applications.

Secure because it can’t save VBA macros.

Can use and save all the functions available in Excel.

A little bit contradicting: But not being able to include VBA macros can be an advantage and disadvantage at the same time.

Needs more disk space than other file formats (e.g. XLSB).

Can’t be opened with Excel versions before 2003 (e.g. 2003, at least without any further conversion of Excel extension/ add-in).

    XLS

The XLS file type has been the default Excel file extension and format before Excel 2007. In Excel 2007, XLSX replaced the XLS format. Therefore, XLS is kind of outdated right now. In the daily life you won’t find it often any more. But some data base tools still export data as XLS files.

The XLS file type has some disadvantages towards the newer file types XLSX or XLSM: It’s rather unsafe as it can contain VBA macros with malicious code. Also, it needs more disk space than the other file types and at the same time has less rows and columns.

On the other side the only advantage: You can easily open XLS files with older versions of Excel.

Advantages Disadvantages

Can be opened with Excel versions before 2007 (e.g. 2003).

Unsafe as it can contain VBA macros.

Needs more disk space than most of the other file formats (e.g. XLSX, XLSB).

Can’t use all newer Excel functions, e.g. formulas or functionality (you will be warned when saving an XLS file though).

Can only use up to 65,536 (2^16) rows and 256 (2^8) rows.

Outdated…

  .aq_block_33554 h3 { color: #2b803f; } .aq_block_33554 p { color: ; }

Save time and impress your co-workers? Become a keyboard shortcut expert! Download our big 45 pages keyboard shotcuts guide!

Get any keyboard shortcut you want. With 2 simple tricks.

Learn 15 most important keyboard shotcuts in detail.

Stick the top 33 keyboard shortcuts under your screen with a handy print out.

That's not enough? Check out the long lists of keyboard shortcuts.

The best: It's free! Just sign up for our free newsletter and you can download the complete keyboard package instantly.

  XLSM

If you include VBA macros in your XLSX file, you will be asked to change the file extension to XLSM. Only that way you can save your macro within the Excel file (there are other file types possible, e.g. XLSB – but you can’t use XLSX for VBA macros). Therefore, it has most of the advantages and disadvantages of the XLSX file type. Positive: You can immediately identify Excel files with VBA macros.

Advantages Disadvantages

The default Excel file type for workbooks with VBA macros.

Can use up to 2^20 (1048576) rows and 2^14 (=16384) columns.

Uses the open file format and is therefore accessible with other applications.

Can use and save all the functions available in Excel.

Uses the open XML standard.

Unsafe: Can contain malicious code within the VBA part.

Needs more disk space than other file formats (e.g. XLSB).

Can’t be opened with Excel versions before 2003 (e.g. 2003, at least without any further conversion of Excel extension/ add-in).

    XLSB

Many people don’t know that there is an actual alternative to the XLSX and XLSM file type: The XLSB file extension. XLSB files store the data a little bit different than the XLSX or XLSM file types: They don’t use the XLM file structure. Instead, XLSB files try to save disk space because the data is stored in the binary structure. The main difference: Binary files are computer- but not human-readable. For more information on binary files in general, please refer to this Wikipedia entry.

The main disadvantage: Binary Excel files can contain VBA macros. So unless you don’t know the origin of a file, please consider well before opening them. Besides that: All the other disadvantages seem minor.

Advantages Disadvantages

Smaller file size.

Faster opening and closing of files.

Formulas with more than 8192 characters allowed.

Can use and save all the functions available in Excel.

Security: Files can contain VBA code whereas XLSX files can’t.

You can’t change the Excel ribbon.

Some third party tools (e.g. OpenOffice) might not be able to open your file.

You can’t open your files with Excel 2003 or earlier (which nowadays should not be a problem any more…).

Not very well known. So people might get confused receiving XLSB files from you.

  CSV

CSV stands for comma separated values. These files are basically plain text – so there are no formulas or formatting. CSV is often used for data exchange. Excel provides the functionality to import or even directly open CSV files.

The basic application for CSV files: Import or export data. Data base programs often export data as CSV files. Also if you want to transport Excel data into a database program, often the CSV file type works.

Advantages Disadvantages

Smaller file size.

Faster opening and closing of files.

Unlimited rows and columns.

No code or macros possible and therefore save to open.

CSV files are basically text documents and therefore can’t contain formulas or formatting, pure data.

No more than one “worksheet”.

  ODS

ODS stands for Open Document Spreadsheet. The file type is designed to work on both Excel and other applications, e.g. LibreOffice. From the Excel point of view, ODS doesn’t support all the features. Text and data is usually saved well though. But formatting and many other features (for example charts, tables, conditional formatting) might run into problems.

Advantages Disadvantages

Can be opened in Excel and LibreOffice.

You might lose formatting or features which are not supported. For a detailed lists of the features supported, please refer to this website.

  XLSX (Strict)

Besides the regular XLSX format, Excel offers to save your Excel workbook as “Strict Open XML Spreadsheet”. So what is the difference between those two? Basically, the two file types use the same structure. But:

The Strict variant has less support for backwards compatibility when converting documents from older formats.

Furthermore:

The Strict variant of XLSX disallows a variety of elements and attributes that are permitted in the more common Transitional variant […]

Advantages Disadvantages

Same as XLSX.

Additionally: Opening in other applications than Excel might work better.

Some backward compatibility problems might occur.

  PDF

As you’ve probably heard of PDF files, we won’t go much into detail here. PDF stands for portable document format and has the reputation of not easily being manipulated. Also, it’s quite save to say that how a PDF file looks on your computer, it will most probably look like this on most other computers.

And that’s it for the advantages. I recommend using it when you present your final results in the following cases:

The recipient of your file should not edit it any more.

Formatting should be exactly preserved.

There is no database included, just the summarized results.

That could be the case if somebody wants to check your results on an iPad or a similar device. But: In many cases it would be professional (and nice) to also send at least parts of your Excel file. That way, your recipient could at least take a look at the calculation process.

Advantages Disadvantages

Static, therefore contents can not (easily) be manipulated.

The document always look the same.

No macros.

Formulas etc. will be lost.

Difficult (and troublesome) to further edit the file.

(Depending on the contents) large file size.

  XLAM

XLAM is the file extension for Excel add-ins. Also our add-ins (for example the popular “Professor Excel Tools“) are XLAM files. They can contain VBA macros, worksheets as well as forms, images and individual ribbons. If you double click on such file, it will open in Excel and you can use the funcationality of the add-in. But next time you open Excel again, it won’t be available any longer. You rather have to enable the add-in within the options (File –> Options –> Add-Ins).

As the XLAM file type is not really an alternative for all the other file extensions above, we skip the advantages and disadvantages.

  Comparison of file types

So if we put all the advantages, disadvantages and facts from above together, we come to the following comparison:

  .aq_block_23038 h1 { color: #2b803f; } .aq_block_23038 p { color: ; }

EXCEL ADD-IN: PROFESSOR EXCEL TOOLS

.aq_block_33038 h1 { color: ; } .aq_block_33038 p { color: ; }

Save a lot of time in Excel!

'Professor Excel Tools' extend your Excel with great new functions. The goal: Make you saving time. Help you with your every day work. Try it for free now - usually it's worth within the first days of use.

Add more than 60 great functions to Excel.

Extremely easy to use, lightweight.

No sign-up, no installation. Try it for free!

.aq_block_43038 h1 { color: ; } .aq_block_43038 p { color: ; }

.aq_block_53038 h1 { color: ; } .aq_block_53038 p { color: ; }

Overview Features Download (No sign-up, download starts directly, no installation)

  Which file type should you use?

Decision Tree

In order to define the best file type for your Excel workbook, please follow the decision tree.

Follow the Professor Excel decision tree for finding the best file type for your Excel workbook.

The first question: Do you just want to display your results only? Then you could also consider the PDF format. But if the recipient of your work wants to edit or follow up your calculations, you shouldn’t use PDF.

Does your file contain VBA macros?

If yes, choose XLSB if you have a large file. Choose XLSM for a file size smaller than app. 10 MB.

If no and you got a large file (larger than app. 10 MB), also choose XLSB.

If no (you don’t have macros) and your file small, follow the tree on the right hand side.

The lower two levels of the decision tree are just about compatibility: If you want to open and edit your workbook with another software, choose the strict XLSX or ODF format.

If you want to make sure that you can open it with versions of Excel 2003 or earlier, go for XLS.

  Summary

In conclusion, you can distill a quite short table (if you don’t need to consider old file types and other applications as LibreOffice). You just have to answer two questions: Do you need VBA macros and do you work with a large amount of data?

Der Beitrag XLSX, XLSM or XLSB: Which File Type Is the Best for You? erschien zuerst auf Professor Excel.

from Professor Excel http://ift.tt/2kGZjx4

[file-formats-programming]

Specify Individual or Private Set of Fonts for Excel Workbook Rendering inside Java Apps

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 18.5. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. We also recommend our clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Sometimes users want to display text in Far East language font e.g. Japanese, Chinese, Thai etc. Aspose.Cells provides TextOptions.FarEastName property that can be used to specify the font name of Far East language. Besides, users can also specify the Latin font name using TextOptions.LatinName property. Aspose.Cells allows developers to save the workbook in Strict Open XML Spreadsheet format. For that purpose, it provides the Workbook.Settings.Compliance property. If users set its value as OoxmlCompliance.ISO_29500_2008_STRICT, then the output Excel file will be saved in Strict Open XML Spreadsheet format. Generally, users specify the fonts directory or list of fonts for all the workbooks but sometime, users have to specify individual or private set of fonts for a desired workbooks. Aspose.Cells provides IndividualFontConfigs class that can be used to specify the individual or private set of fonts for users' workbook.  Below are some important new features, enhancement and bug fixes part of this release.

The concurrent conversion to PDF while each workbook has his own private (exclusive) set of fonts

Detect LoadFormat and FileFormatType of XLAM

Pivot Table's formatting and behavior changed after open/save the template file

Spreadsheet (XLS) becomes corrupted after simple load & save

Aspose.Cells breaks iterator interface when calling Iterator.hasnext() twice

Properties values garbled when extracting document properties

The workbook is corrupted after adding a watermarkhttps://goo.gl/chJgCb

Same code executes slower in new releases

Properties are not be extracted in the template file

NullPointerException when adding HTML to a cell

Lines disappeared from chart when XLSX file is re-saved

Exception "IndexOutOfBoundsException" when merging cells in light-weight mode

Exception "java.lang.IllegalStateException: Invalid encoding: null" when loading an XLS file

ArrayIndexOutOfBoundsException occurs on opening an Excel file

"java.lang.ArrayIndexOutOfBoundsException" occurs on opening an Excel file

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

Save Workbook to Strict Open XML Spreadsheet Format

Specify Individual or Private Set of Fonts for Workbook Renderi

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

Homepage of Aspose.Cells for Java

Download Aspose.Cells for Java

Online documentation of Aspose.Cells for Java

[file-formats-programming]

Save Workbook to Strict Open XML Spreadsheet Format & Enhanced Excel to PDF Rendering using .NET

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 18.5. This release has added a few valuable features, important fixes and other enhancements. Aspose.Cells now allows users to save the workbook in Strict Open XML Spreadsheet format. This feature was demanded by certain users. This can be accomplished by Workbook.Settings.Compliance property. If users set its value as OoxmlCompliance.Iso29500_2008_Strict, then the output Excel file will be saved in Strict Open XML Spreadsheet format. Generally, users specify the fonts directory or list of fonts for all the workbooks but sometime, users have to specify individual or private set of fonts for a desired workbooks. Aspose.Cells provides IndividualFontConfigs class that can be used to specify the individual or private set of fonts for your workbook. Sometimes users want to display text in Far East language font e.g. Japanese, Chinese, Thai etc. Aspose.Cells provides TextOptions.FarEastName property that can be used to specify the font name of Far East language. Besides, users can also specify the Latin font name using TextOptions.LatinName property. There are some other enhancements included and a few exceptions handled in the new release for the users. This release includes several enhanced features and bug fixes as listed below

Implement function CEILING.PRECISE

Support Strict Open XML Spreadsheet format

The color of the image should be black when converting to PDF

Page Setup PrintErrorType not working in Excel to PDF rendering

PageSetup.PrintDraft does not take effect while Saving to PDF

System.OutOfMemoryException while converting Excel file to PDF

Page field named "Absent item Yes" is lost on Refresh

Calculation error when using calculation chain and defined name

A few columns are disappeared when importing an Excel file into GridWeb

Text wrapping is not correct when "Issue2 wrapping-no_custom_page_size.xlsx" is converted to PDF

Text wrapping is not correct when "Issue2 wrapping.xlsx" is converted to PDF

Text wrapping is not correct when "Issue3 wrapping.xlsx" is converted to PDF

Page Setup zoom factor creates incorrect number of pages in PDF

Exception when saving a workbook to MemoryStream

Some of the Gridlines around some cells are not drawn correctly

Chart title is squished where the characters all run together in Excel to PDF rendering

Pie chart legend colors change after saving to PDF and do not match up with Pie chart slices

Saving XLSB to XLSM creates corrupt MS Excel file

Named ranges lost when copying into existing workbook

Embedded drawing objects are too narrow in the output file when re-saving an XLSX file

Aspose.Cells returns blank PDF when saving a SpreadsheetML file as PDF

Data loss occurs while converting ODS to XLSX file format

Named range does not expand with Smart Markers "shift" parameter

Using "shift" parameter in Smart Markers, the generated rows are not rendered with the same style/formatting

Conditional formatting does not work in Smart Markers with shift parameter

Text cropped in MS Excel cells if the document rows are auto sized

Resizing a ListObject/Table does not update its conditional formattings

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

Save Workbook to Strict Open XML Spreadsheet Format

Specify Individual or Private Set of Fonts for Workbook Rendering

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

Homepage of Aspose.Cells for .NET C#

Download Aspose.Cells for .NET

Online documentation of Aspose.Cells for .NET

[file-formats-programming]

Strict Open XML Format Support & Rendering Comments from ODP Files using Java

What's New in this Release?

Aspose team is happy to share the announcement of Aspose.Slides for Java 18.8. It has added support for some of new features in this API along with resolution of incurring issues in API. There are some important new features included in this release such as Add support for Strict Open XML format, Rendering of Metafiles ignores fonts loaded with FontsLoader, Rendering comments from ODP format that have no author, Support for "purl.oclc.org" namespace in Type attribute in ".rels" parts. It also included some important enhancements and bug fixes, such as Border around text appears after saving the PPT file, improved PPTX to PDF conversion, improved rendering of external fonts in SVG, Rendering presentation with large amount of data in charts consumes all available memory, Existing PPTX table cells changes formatting after assigning text, The embedded data stream is disposed and many more. This list of new, improved and bug fixes in this release are given below

Add support for Strict Open XML format

Rendering of Metafiles ignores fonts loaded with FontsLoader

Rendering comments from ODP format that have no author

Support for "purl.oclc.org" namespace in Type attribute in ".rels" parts

Rendering presentation with large amount of data in charts consumes all available memory

Improved PPTX to PDF conversion

Improved rendering of external fonts in SVG

The embedded data stream is disposed

When PPTX is converted to PDF, picture gets blurred

PPT to PDF not properly converted Enterprise Support

Icons are missing in exported PDF for RedHat Linux

Support for "purl.oclc.org" namespace in Type attribute in ".rels" parts

Bar Chart not properly converted to PDF

Improper render of external fonts in SVG

Text get missing and overlapped when exporting to PDF Notes

PPTX not properly converted to PDF

Chart is improperly rendered in generated thumbnail

PPTX not properly converted to PDF

Strikethrough portion rendering issue

Exception on loading presentation

PptxReadException when opening PPTX files on Mac

Exception on saving presentation

Setting data label position is not working in Box and Whisker chart

Exception on using Fonts

Rendering presentation with large amount of data in charts consumes all available memory

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Slides for Java documentation that may guide users briefly how to use Aspose.Slides for performing different tasks like the followings.

Save Workbook to Strict Open XML Spreadsheet Format

Converting Presentation to HTML

Overview: Aspose.Slides for Java

Aspose.Slides is a Java component to create, read, write and modify a PowerPoint document without using Microsoft PowerPoint. It supports PHP applications and provides all advanced features for managing presentations, slides, shapes, tables and supports PPT, POT, POS PowerPoint formats. Now you can add, access, copy, clone, edit and delete slides in your presentations. It also supports audio & video frames, adding pictures, text frames and saving presentations as streams or SVG format.

More about Aspose.Slides for Java

Homepage of Aspose.Slides for Java

Downlaod Aspose.Slides for Java

Online documentation of Aspose.Slides for Java