Smart Marker Question

Hi,

Thanks for following up.

We will get back to you soon.

Thank you.

We will release a public version within one week.

Hi Laurence,

Thanks! Your team is the best! Aspose has the best support & functionality.

Keep it up!

Hi,

Do you have a date when this will be out of beta? (no pressure :))

Thanks!

Hi,

Thanks for following up.

Well, our next public release has been delayed due to some urgent tasks (to be performed) and extended testing of the component. Hopefully we can release our next version for .NET within 10 days or so.

Thank you.

Hi,

I see the new version was released! Yay!!!

Can someone quickly jot down the updates for each of these-

What's New?
  • Convert Worksheet to image.
  • Support to convert Excel file to HTML file format.
  • Support to sort the data from left to right.
What's Improved?
  • Supported more functions in formula calculation engine
  • Supported more custom filters in autofilter.
  • Enhanced Excel2007 Xlsx support
  • Enhanced SpreadsheetML support
  • Enhanced xls2Pdf conversion
  • Enhanced Charts2Image conversion.
  • Enhanced smart marker
  • Supported getting linked cell of radio button from template file.

I don't see the documentation for any of these changes.

Thanks!

Hi,

Well, we are working on some new documenation topics for some new sets of APIs that are added in this version. Hopefully, we can upload / update the Aspose.Cells documenation with its API reference in 1-2 days. But When you install the latest version (4.5.0.0) using its Aspose.Cells.MSI installer, Aspose.Cells.chm help file is there, so, you may check the file for the new sets of APIs that are included.

What's New?
  • Convert Worksheet to image.

Worksheet.SheetToImage() overloaded method is added.

  • Support to convert Excel file to HTML file format.

FileFormatType.Html member is included.

  • Support to sort the data from left to right.

DataSorter.SortLeftToRight() attribute is added for the class.

What's Improved?
  • Supported more functions in formula calculation engine

We have enhanced formula calculation list and add some more formulas, the list would be updated in the documenation soon.

  • Supported more custom filters in autofilter.

We have supported custom filterization now, AutoFilter.Custom method is introudced.

  • Enhanced Excel2007 Xlsx support

We did some enhancements related formattings for .xlsx files.

  • Enhanced SpreadsheetML support

We did some enhancements for SpreadsheetML format in Excel 2007 .xlsx files.

  • Enhanced xls2Pdf conversion

We did some improvements for Excel 2 Pdf conversion to make it more precise and accurate.

  • Enhanced Charts2Image conversion.

We improved Chart2Image conversion to make it more precise.

  • Enhanced smart marker

We introduces Smart markers's grouping options for inserting summary rows into the data sets. I think you better know about this feature because this thread tells all about it and this functionality is included in the latest version.

  • Supported getting linked cell of radio button from template file.

We supports to retrieve the linked cell's info for a radio button control in the designer file.

Hopefully, it would help you.

Thank you.

Hi,

Please check the following Aspose.Cells documenation links for the new enhancements / updatation.

What's New?
  • Convert Worksheet to image.
Converting Worksheet to Image: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/converting-worksheet-to-image.html
  • Support to convert Excel file to HTML file format.
Saving files: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/saving-files.html ..... I have included FileFormatType.Html info in it.
  • Support to sort the data from left to right.
Data Sorting: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/data-sorting.html ... I have introduced new API i.e. DataSorter.SortLeftToRight member.

What's Improved?

  • Supported more functions in formula calculation engine
Updated Supported Formulas / Functions: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/supported-formulas-functions.html
  • Supported more custom filters in autofilter.

We have supported custom filterization now, AutoFilter.Custom method is introudced.

Auto-Filtering and Validation: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/data-filtering-and-validation.html .

  • Enhanced smart marker

We introduces Smart markers's grouping options for inserting summary rows into the data sets. I think you better know about this feature because this thread tells all about it and this functionality is included in the latest version.

Smart Markers: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/smart-markers.html ..... I have added a subtopic with all the details with examples to demonstrate new grouping feature related Smart Markers.
Thank you.

Hi,

Thanks for your detailed descriptions. It is much helpful.

I believe there is a bug with the new version -

It used to be that when we didn't have any data in the DataTable, the tags would disappear. Now, they are still there after running the report - do you know why?

Thanks!

Hi,

No, it's not a bug. Actually, now, the valid markers would remain placed into the worksheet whether the source datatable is empty. I think we did support this feature upon some user's request and is worthwhile for some reason you know.

Thank you.

Hi,

It is a bug for us - we don't want the tags there because it doesn't make sense for the end user.

How can we get rid of them??

Hi,

We would like to give this DLL with the new features to our clients, but cannot since all the tags remain if the dataset is empty.

Can you please provide a fix to this please?

Thanks!

Hi,

OK, we will check the feasibility to erase them if the source datatable is empty. And by the way, in the mean time, you may try to ease them using Aspose.Cells APIs (if the related datatable is empty). e.g., Cells.DeleteRange() method.

Thank you.

Hi,

1. We cannot erase them

2. We are going to production any day and just found this bug with the new version of Aspose.Cells - all the previous version were working well.

3. Please let us know when you have a fix

Thanks!

Hi,

We will get back to you soon.

Thank you.

Hi,

Please try this fix.

Hi,

Thanks - it seems to work!

Will this be the way going forward? Maybe this can be the default way, but if a user wants to leave the tags there, they can pass in a parameter?

Thanks!

Hi,

If you want to leave the tags, please use WorkbookDesigner.Process(true) method.

Hi,

Thanks for the fix.

In this fix, does the Smart Markers Grouping functionality work? I can't get it to work.

Thanks!

Never mind, I figured it out!

Thanks for the fix!