HarfBuzzSharp -> 8.3.0.1, SkiaSharp -> 3.116.1

<PackageReference Include="HarfBuzzSharp" Version="8.3.0.1" />

<PackageReference Include="SkiaSharp" Version="3.116.1" />

<PackageReference Include="System.Buffers" Version="4.5.1" />

<PackageReference Include="System.Memory" Version="4.5.5" />

<PackageReference Include="Microsoft.Win32.Registry" Version="4.5.0" />

<PackageReference Include="System.Security.Cryptography.Pkcs" Version="4.5.0" />

<PackageReference Include="System.Security.Cryptography.Xml" Version="4.7.1" />

<PackageReference Include="System.Security.Permissions" Version="4.5.0" />

<PackageReference Include="System.Text.Encoding.CodePages" Version="4.5.0" />

System.Drawing.Common >= 9.0.0

System.Security.Permissions >= 9.0.0

System.Text.Encoding.CodePages >= 9.0.0

System.Security.Cryptography.Pkcs >= 9.0.0

System.Security.Cryptography.Xml >= 9.0.0

HarfBuzzSharp >=8.3.0.1

workbook.Worksheets[0].Range["E9"].Formula = "=RANK.AVG(10,A1:A6)";

//Default descending order

workbook.Worksheets[0].Range["E9"].Formula = "=RANK.EQ(10,A1:A6)";

workbook.Worksheets[0].Range["D2"].Formula = "=PERCENTILE.INC(\"\", 0.3)";

workbook.Worksheets[0].Range["D2"].Formula = "=PERCENTILE.EXC(\"\", 0.3)";

workbook.Worksheets[0].Range["D2"].Formula = "=BINOM.DIST(A7, A11, A12, FALSE)";

workbook.Worksheets[0].Range["D2"].Formula = "=BINOM.INV(A7, A12, A13)";

workbook.Worksheets[0].Range["C10"].Formula = "=NEGBINOM.DIST(10,5,1,TRUE)";

workbook.Worksheets[0].Range["C6"].Formula = "=BINOM.DIST.RANGE(10, 2, 5)";

workbook.Worksheets[0].Range["C7"].Formula = "=BETA.DIST(3, 0, 5, TRUE, 1, 5)";

workbook.Worksheets[0].Range["C7"].Formula = "=BETA.INV(0.685470581, 8, -1, 1, 3)";

workbook.Worksheets[0].Range["B3"].Formula = "=ROUNDBANK(1245585, -1)";

workbook.Worksheets[0].Range["B3"].Formula = "=GAMMA(ss)";

workbook.Worksheets[0].Range["B10"].Formula = "=GAMMA.DIST(10.0001131, 9, 0, TRUE)";

workbook.Worksheets[0].Range["B10"].Formula = "=GAMMA.INV(0.068094, 0, 2)";

workbook.Worksheets[0].Range["J16"].Formula = "=TAKE(A1:F6,3)";

workbook.Worksheets[0].Range["G26"].Formula = "=HSTACK(E1:F7,G1:G6)";

Workbook workbook = new Workbook();

workbook.LoadFromFile(@"in.xlsx");

Worksheet sheet= workbook.Worksheets[0];

AutoFitterOptions options = new AutoFitterOptions();

options.AutoFitMergedCells = true;

//the first parameter is the merged row

sheet.AutoFitRow(9, 1, sheet.LastColumn, options);

workbook.SaveToFile(@"out.xlsx", Spire.Xls.FileFormat.Version2016);

workbook.Dispose();

sheet.Range["C2"].Formula = "=GAUSS(A1)";

sheet.Range["C3"].Formula = "=LOGNORM.DIST(A2, A3, A4, A5)";

sheet.Range["C4"].Formula = "=GAMMALN.PRECISE(1.5)";

sheet.Range["C5"].Formula = "=LOGNORM.INV(0.5, 0, 1)";

// Remove duplicate rows in the worksheet

sheet.RemoveDuplicates();

// Remove duplicate rows within specified range

sheet.RemoveDuplicates(int startRow, int startColumn, int endRow, int endColumn);

// Remove duplicate rows based on specific columns and headers

sheet.RemoveDuplicates(int startRow, int startColumn, int endRow, int endColumn, boolean hasHeaders, int[] columnOffsets)

sheet.Range["A45"].Formula = "=TRIMRANGE(A1:H10, 1, 1)";

sheet.Range["B4"].Formula = "=ERF.PRECISE(1)";

sheet.Range["B4"].Formula = "=ERFC.PRECISE(NULL)";

sheet.Range["B9"].Formula = "=PERMUTATIONA(A5,A5)"

//Initialize an instance of the PdfDocument instance

PdfDocument doc = new PdfDocument();



//Load a PDF document

doc.LoadFromFile(inputFile);



//Initialize an instance of the StringBuilder class

StringBuilder sb = new StringBuilder();



//Get the form from the document

PdfFormWidget formWidget = doc.Form as PdfFormWidget;



//Iterate through all fields in the form

for (int i = 0; i < formWidget.FieldsWidget.List.Count; i++)

{



    PdfField field = formWidget.FieldsWidget.List[i] as PdfField;



    //Get the ButtonField

    if (field is PdfButtonWidgetFieldWidget)

    {

        PdfButtonWidgetFieldWidget buttonField = field as PdfButtonWidgetFieldWidget;

        // Get the field name

        string filename = buttonField.Name;



        // Get the action

        PdfAction action = buttonField.Actions.MouseDown;

        if (buttonField.Actions.MouseDown != null && buttonField.Actions.MouseDown is PdfHideAction)

        {

            var btnAction = (PdfHideAction)buttonField.Actions.MouseDown;

            sb.AppendLine(filename + "-MouseDown-Hide-" + btnAction.IsHide.ToString());

            sb.AppendLine(filename + "-MouseDown-fname-" + btnAction.FieldName[0].ToString());

        }

    }

}

File.WriteAllText(outputFile, sb.ToString());

doc.Dispose();

    PdfDocument doc = new PdfDocument();

    doc.LoadFromFile(pdffile);

    doc.PrintSettings.SelectPageRange(1, 5);

    if(doc.PrintSettings.CanDuplex)

    {

        doc.PrintSettings.Duplex = PdfDuplex.Vertical;

    }

   doc.Print();

Presentation ppt = new Presentation();

ppt.LoadFromFile(inputFile);

List dataList = ppt.Slides[0].Shapes[1].CustomerDataList;

Console.WriteLine(dataList.Count);

for(int i = 0; i < dataList.Count; i++)

{

   string name = dataList[i].Name;

   string content = dataList[i].XML;

    File.WriteAllText(outputFile + name, content);

}

//Create a PPT document

Presentation presentation = new Presentation();





Double[] widths = new double[] { 100, 100, 150, 100, 100 };

Double[] heights = new double[] { 15, 15, 15, 15, 15, 15, 15, 15, 15, 15, 15, 15, 15 };



//Add new table to PPT

ITable table = presentation.Slides[0].Shapes.AppendTable(presentation.SlideSize.Size.Width / 2 - 275, 90, widths, heights);



String[,] dataStr = new String[,]{

{"Name",    "Capital",  "Continent",    "Area", "Population"},

{"Venezuela",   "Caracas",  "South America",    "912047",   "19700000"},

{"Bolivia", "La Paz",   "South America",    "1098575",  "7300000"},

{"Brazil",  "Brasilia", "South America",    "8511196",  "150400000"},

{"Canada",  "Ottawa",   "North America",    "9976147",  "26500000"},

{"Chile",   "Santiago", "South America",    "756943",   "13200000"},

{"Colombia",    "Bagota",   "South America",    "1138907",  "33000000"},

{"Cuba",    "Havana",   "North America",    "114524",   "10600000"},

{"Ecuador", "Quito",    "South America",    "455502",   "10600000"},

{"Paraguay",    "Asuncion","South America", "406576",   "4660000"},

{"Peru",    "Lima", "South America",    "1285215",  "21600000"},

{"Jamaica", "Kingston", "North America",    "11424",    "2500000"},

{"Mexico",  "Mexico City",  "North America",    "1967180",  "88600000"}

};



//Add data to table

for (int i = 0; i < 13; i++)

    for (int j = 0; j < 5; j++)

    {

        //Fill the table with data

        table[j, i].TextFrame.Text = dataStr[i, j];



        //Set the Font

        table[j, i].TextFrame.Paragraphs[0].TextRanges[0].LatinFont = new TextFont("Arial Narrow");

    }



//Set the alignment of the first row to Center

for (int i = 0; i < 5; i++)

{

    table[i, 0].TextFrame.Paragraphs[0].Alignment = TextAlignmentType.Center;

}

string latexMathCode = @"x^{2}+\sqrt{x^{2}+1}=2";

table[2, 3].TextFrame.Paragraphs.AddParagraphFromLatexMathCode(latexMathCode);

//Set the style of table

table.StylePreset = TableStylePreset.LightStyle3Accent1;



//Save the document

presentation.SaveToFile("Output.pptx", FileFormat.Pptx2010);

Presentation ppt = new Presentation();

ppt.Slides[0].Shapes.AddFromSVGAsShapes(file.FullName);

ppt.SaveToFile(fileName + ".pptx", FileFormat.Pptx2013);

ppt.Dispose();

HarfBuzzSharp->8.3.0.1、SkiaSharp->3.116.1

HarfBuzzSharp->8.3.0.1、SkiaSharp->3.116.1


The Netstandard reference adjustment is as follows:


<PackageReference Include="HarfBuzzSharp" Version="8.3.0.1" />

<PackageReference Include="SkiaSharp" Version="3.116.1" />

<PackageReference Include="System.Buffers" Version="4.5.1" />

<PackageReference Include="System.Memory" Version="4.5.5" />

<PackageReference Include="Microsoft.Win32.Registry" Version="4.5.0" />

<PackageReference Include="System.Text.Encoding.CodePages" Version="4.7.0" />

<PackageReference Include="System.Security.Cryptography.Pkcs" Version="4.7.0" />

<PackageReference Include="System.Security.Cryptography.Xml" Version="4.7.1" />

<PackageReference Include="System.Security.Permissions" Version="4.7.0" />

HarfBuzzSharp->8.3.0.1、SkiaSharp->3.116.1