-
Notifications
You must be signed in to change notification settings - Fork 93
Error When Opening Sample2 Created on Ubuntu in Windows Excel #23
Comments
Sorry about not being more specific. I'm referring to this demo. I did a little more work on it. I unzipped the xlsx Sample2 file (added .zip extension and unzipped it). I compared it to the repaired file and found EPPlus did remove some tick marks in workbook.xml and chart1.xml. Example:
I compared the original and repaired files using WinMerge and found the repair process changed 100's of things. I tried manually fixing the tick problem and rezipping it to create the .xlsx file but it still gave the same error. Still not clear why EPPlus is adding tick marks. I'm thinking in Sample2 it is using Sample1 as a template file.
When I get time I'll research this some more. |
I installed EPPlus.Core on Windows and Ubuntu. Made a few changes for compatibility so Windows and Linux source is identical.
Main
string working = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
DirectoryInfo outputDir = new DirectoryInfo(working);
Sample1&2 Used Path.Combine
string outPath = Path.Combine(outputDir.FullName, "Sample1.xlsx");
FileInfo templateFile = new FileInfo(outPath);
Works perfectly on Windows and am able to open in Excel 2010.
Runs perfectly on Ubuntu.
Move Ubuntu output to Windows. Sample1 opens up perfectly.
Sample2 gives an error and prompts me to repair it. It opens perfectly after being repaired and I don't see any issue.
The named range "SubTotalName" is there and correct.
The text was updated successfully, but these errors were encountered: