@afitz
Sorry for my confusion. I mean the data of autofitler is like this in html，please prepare them.
We will support reading autofitler in the next version 23.1.
@afitz
You are welcome!
BTW, will you set the filter condition in html ? Now only “All” is supported .
Hi Simon, I want to make sure I am understanding correctly: Currently Aspose.cells does not have an option for x:autofilter=“custom”, but does have functionality for x:autofilter=“all”. When version 23.1 is available we will be have custom “Autofilter” in our reports if we include it in our report HTML, like the example you attached? I will have to test with the x:autofilter=“all” again because I was not able to achieve it.
“CELLSJAVA-45029” we did not get resolve on this issue, but I see its marked as “Resolved”. Can you communicate your determination on the issue? i.e. <x:WorksheetOptions> section where we can define the sheet zoom, freeze panes, and other information for the excel report is not being applied at all…
Both issues (logged as “CELLSJAVA-45029” and “CELLSJAVA-45034”) are resolved now. But the fixes/enhancements would be included in our upcoming release Aspose.Cells for Java v23.1 which will be published in the first half of January 2023.
Moreover, we will also shed lights and explain on what will be supported in upcoming release regarding both tickets.
Hi there, Happy New Year! Checking in on CELLS-JAVA-44907, any insight? Thank you so much!
The issues you have found earlier (filed as CELLSJAVA-45029,CELLSJAVA-45034) have been fixed in Aspose.Cells for Java 23.1.
Thank you for the update on the releases. CELLSJAVA-44907 Is an important feature because it allows redlining in cells, and would definitely motivate an upgrade. Any ETA on that yet?
No ETA on specific issue “CELLSJAVA-44907” yet but you may try latest version of the API which has enhancements. Anyways, please note, we already logged separate (relevant) sub tickets (filed as CELLSJAVA-45029, CELLSJAVA-45034) and fixed them already.
@afitz @mlyra
Have you tried 23.1?
If you still has issues , please share your sample project and files , we will check it soon.
Hello Simon, its been a busy few months. I hope all is well! This is a new question. When creating header and footer data, how should a line break be formatted within the mso-header-data or mso-footer-data string? For example I have line breaks formatted in “\000A” in my input, and I have tried lots of other character entities for line break but cannot get the line break to work:
@page
{mso-header-data:"&L&10Left Top Row\000ALeft Middle Row\000A&11\000A&C&\0022-,Bold\0022Center Top Title\000ACenter Middle Title&R&10Right Top Row\000ARight Middle Row\000ARight Bottom Row";
mso-footer-data:"&L&10Left Top Footer \000ALeft Middle Footer \000ALeft Bottom Footer &C&\0022-,Bold\0022Center Footer&R&10Right Top Footer\000ARight Middle Footer\000ARight Bottom Footer";
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
But the line breaks do not happen in the output and the content overlaps in the header and footer. I have attached the expected output, the input file, and output file. Thank you for your help!
ExcelXLSXHeadersFooters.7z (13.6 KB)
@afitz
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSJAVA-45249
We will fix this issue that NewLine does not work when converting mht to excel
@afitz
Which version are you using?
It works fine with 23.3 with your input file, please check the attached file 23.3.zip (7.5 KB)
Workbook workbook = new Workbook(dir + “InputMHTMLfile.mht”);
workbook.save(dir +“23.3.xlsx”);
Hi, We have version 20.11 of Aspose.cells. I opened the file you attached and I see no header or footer data. Thank you for your help
Please open the Excel file into MS Excel manually. Now take the Print Preview of the sheet or open “Page Layout” view from View menu. You will find those headers and footer are sorted fine.
Thank you Amjad, I see them know, I was in Monday-mode and only looked at the second sheet. I see them on the first sheet. Alright, so we need version 23.3 of Aspose.cells for “\000A” to work as a line break. Thank you!
It is nice to know that you figured it out now. Should you have further queries or issue, feel free to write us back.
Hello Aspose.cells friends! If I were to create an internal link between sheets in a workbook I can achieve it by giving the href the sheet name and cell I want to go to, if I wanted to leave sheet “DiDi” and go to sheet “LaLa” I would do so like:
<a href="#LaLa!A1" target="_parent"> Take me to sheet LaLa</a>
I can achieve this using a format that is not .xlsx and not Aspose.cells, but I cannot achieve it with Aspose.cells .xlsx format and I get error messages, I think my href path changes in the conversion somehow. Perhaps you have some insight? I have attached the Input file, Expected Output, and Actual Output.TakeMeFromSheetToSheet.7z (13.1 KB)