NPOI 2.5.2 Release Notes

[tonyqus]

We are going to release 2.5.2 soon. Here is the release notes

#448 Add ifs, maxifs, minifs functions to analysis tool pack
#410 fix Match function for compatible
#423 AddPicture doesn't work, corrupts DOCX file
#397 LocalUtil.GetUserTimeZone NullReferenceException
#167 Unable to add image to a word document header or footer using XWPF
#346 NullReferenceException when copying sheet in some Excel files
#413 fix: Rich strings hash for texts with the color set as RGB
#444 Update RANDBETWEEN
#158 NPOI Excel Merging Causing “Repaired Records”
#345 Excel unreadable content error after editing existing file
#358 Remove static locale state
#367 fix incorrect footnote handling
#372 NPOI requires GDI+ dependency even on sheet creation without using column auto-sizing
#281 InvalidOperationException on XSSFSheet.GetColumnStyle
#377 AutoSizeColumnTracker to Lazy, fix build errors
#339 improve performance of CreateRow for bigger excel sheets

[fu827707013]

Please,When will the next official version be released

[tonyqus]

@fu827707013 very soon. I'm trying to build since tonight. The release candidate will be ready in 2 days.

[yafeiguo888]

please let's know when it is ready in nuget.org

[tonyqus]

NPOI 2.5.2 released on nuget! Please help test this nuget package. Thank you!

[tonyqus]

@yafeiguo888 I did test SetFormula. It works fine on my box. Please create new issue for your case. This issue will be closed.

[wangafei]

#373 add and fix？nuget 2.5.2 Run.AddPicture() still unfix

[WagnerSereia]

Hi Tonyqus,
I still the same problem that @wangafei told to you.
I can add an image in the header OR in the body (content) of the document, however when I try to put the same image in the header AND in the body of the document, it displays the error.

Look a litle bit of the code:
`

                        uint numImage = 0;

                        foreach (var p in list_XWPFParagraph)
                        {
                            var runs = p.Runs;
                            foreach (var run in runs)
                            {
                                using (FileStream picData = new FileStream(@"C:\Images\myImage.jpg", FileMode.Open, FileAccess.Read))
                                {
                                    numImage++;
                                    run.AddPicture(picData, (int)PictureType.JPEG, $"{tag.Tag + numImage}", largura, altura);
                                    var docPr = ((NPOI.OpenXmlFormats.Dml.WordProcessing.CT_Drawing)run.GetCTR().Items[run.GetCTR().Items.Count - 1]).inline[0].docPr;
                                    docPr.id = numImage;
                                }
                            }
                        }

`