HI,
We were using Aspose cells 17.8 and PIVOT and FORM functionality is not working with Office 365.
So we decided to upgrade the Aspose cells to 20.6 and its working for PIVOT now but still its failing for FORM.
Could you please take a look and share your inputs.
Thanks,
Ritesh
+91 9422759997
Please provide more details, sample code (runnable) and sample files to show the issue using v20.6, we will check it soon. Also attach some screenshots (taken in Office 365) to highlight the issue. This will help us to evaluate your issue precisely to figure it out soon.
Hi,
Please find the attached template and try to open it in two different version of office 365.
If we open it in office 365 Version 1908 (Build 11929.20838) then its working fine.
Screenshot 1:Working FORM
Office-365_v1908 (Build 11929.20838)_FORM.png (69.5 KB)
Screenshot 2: FORM properties
Office-365_v1908 (Build 11929.20838)_FORM_SETTING.png (5.7 KB)
If we open it in office 365 version 2005, Build:12827.20268 then its not working.
Screenshot 1: FORM with empty values
office 365 version 2005 Build 12827.20268_FORM_NOT WORKING.PNG (14.9 KB)
Screenshot 2: FORM properties
office 365 version 2005 Build12827.20268_FORM VALUES.png (134.1 KB)
If we open the attach template in shared excel versions then you can find the same difference. Please unzip TEST (1).zip
TEST (1).zip (14.9 KB)
Generally, we follow MS Excel standards and specifications for Excel file formats. So if the generated file does not work in Ms Excel (2007 - 2019) or gives some issue in it, we fix the issue as soon as possible. Excel 365 is just a subset of MS Excel, Excel 365 may have some limitations and other differences. I simply opened your .XLSM file into MS Excel (2013, 2010 and 2007), it works fine, see the screenshot attached.
sc_shot1.png (40.9 KB)
How did you create the file, could you share the sample code (runnable), we will check it further by evaluating older and newer versions of Aspose.Cells and test the output into Office 365 as well.
We created a excel template on top office 365 latest version. We are using excel template to render the data generated through application.
We didn’t make any code changes to support excel 365 as extension is same for Excel 2016 and Excel-365 (On premise vs On cloud).
Code snippet :
package demo;
import com.aspose.cells.Cell;
import com.aspose.cells.FileFormatType;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
public class PrintWriterExample {
public static void main(String[] args) throws Exception {
String filename=“TEST2.xlsm”;
Workbook wb = new Workbook(filename);
//Get the first worksheet.
Worksheet worksheets = wb.getWorksheets().get(“Data_Sheet1”);
Cell cell = worksheets.getCells().get(“A1”);
cell.setValue(“Hello World!”);
wb.save(filename);
}
}
Please let us know, how can we fix this gap.
We reproduced the issue as you described in Office 365. We have logged a ticket with an id “CELLSJAVA-43213” for your issue. We will look into it soon to figure it out soon.
Once we have an update on it, we will let you know.
Thanks you ! for sharing quick inputs.
Can I view CELLSJAVA-43213 or its for internal purpose ?
No, we have our internal issue tracking system, so you always need to ask us to get latest updates on the issue.
Please spare us little time, hopefully your issue will be fixed in the next week.
This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-43213”) now. We will provide you the fixed version in the next week after performing QA and incorporating other enhancements and fixes.
Thanks for the quick solution. 
Could you please share date on which will get latest jar.
It will be helpful for us to schedule the next release.
Hopefully, we will provide you the fix in this week (the date/day is not final as fixes are available when ready (after QA test)), so stay tuned.
Please try our latest version/fix: Aspose.Cells for Java v20.6.2:
aspose-cells-20.6.2-java.zip (7.1 MB)
Let us know your feedback.
Thanks! We will integrate it now.
The issues you have found earlier (filed as CELLSJAVA-43213) have been fixed in Aspose.Cells for Java 20.7. This message was posted using Bugs notification tool by Amjad_Sahi