FindText using Regex not finding all instances of string

[Lisa.Li]

Hello,

Thanks for your feedback.
Our Test Team is compiling a temporary Spire.Office version for you. Once it is available, I will inform you at the first time.

Sincerely,
Lisa
E-iceblue support team

[wraydc]

Thank you, much appreciated - Sorry to be the one chasing again but I'm back to not being able to release to my client, who is chasing me twice a day for a fix. Anything you can do to get the Hot Fix out asap would be greatly appreciated

I'm sure this is another expression of the same issue, but I'm getting an exception when loading an Excel document when using the patched version, I include this just in case it is helpful:

System.TypeInitializationException: The type initializer for 'sprួ' threw an exception. ---> System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
at System.Reflection.Assembly.GetTypes()
at sprួ..cctor()

[Lisa.Li]

Hello,

Sorry for the inconvenience caused. Considering your urgent situation, we quickened the process and prepared a temporary version (spire.office_5.6.9.zip) for you. Please download and test it firstly.

Sincerely,
Lisa
E-iceblue support team

[wraydc]

Hi Lisa, I'm back

The FindText method using TextFindParameter.Regex still doesn't seem to be working correctly with certain files

The attached file is an excel file that was converted to a PDF (using Spire.Xls and save as a PDF). If I then run the code below nothing gets highlighted when Co-Founder should be highlighted.

Code: Select all

        public void SpreadsheetPDFTest()
        {
            string strFileName = @"\\Mac\Dropbox\Source\source\Grain Silo\Test Data\staff list.xlsx.pdf";
            string strTarget = @"\\Mac\Dropbox\Source\source\Grain Silo\Test Data\Redacted\staff list.xlsx.pdf";
            string strSearchText = @"(\b)(Co-Founder)(\b)";
            Spire.Pdf.PdfDocument pdf = new PdfDocument(strFileName);
            TextFindParameter tfp = new TextFindParameter();

            tfp = TextFindParameter.Regex;

            foreach (PdfTextFind text in pdf.Pages[0].FindText(strSearchText, tfp).Finds)
            {
                text.ApplyHighLight(System.Drawing.Color.Gold);
            }

            pdf.SaveToFile(strTarget);

            pdf.Dispose();
        }

Can you get the devs on the case urgently again.

Many thanks in advance,

Darren

[rachel.lei]

Hi Darren,

Thanks for your feedback.
I tried to open you file in Adobe and then find the word "Co-Founder" but no matches were found. Then I copied and pasted it into a Word document but found that it garbled, as shown below. This is a problem with the PDF itself, hope you can understand.

Find_in_Adobe.png

Besides, you mentioned that this PDF document was generated using our Spire.XLS, you can directly provide your Excel document to us, then we will further investigate if there is any solution for you.

Sincerely,
Rachel
E-iceblue support team

[wraydc]

Rachel,

Thanks for the prompt response, attached are the files for the code below:

Code: Select all

        public void SpreadsheetPDFTest()
        {
            string strXLSFileName = @".\staff list 2.xlsx";
            string strFileName = @".\staff list.xlsx.pdf";
            string strTarget = @".\staff list.xlsx.pdf";
            string strSearchText = @"(\b)(Co-Founder)(\b)";
            Spire.Xls.Workbook workbook = new Workbook();

            // Convert XLSX to PDF
            workbook.LoadFromFile(strXLSFileName);
            workbook.SaveToFile(strFileName, Spire.Xls.FileFormat.PDF);
            workbook.Dispose();

            // Highlight PDF
            Spire.Pdf.PdfDocument pdf = new PdfDocument(strFileName);
            TextFindParameter tfp = new TextFindParameter();

            tfp = TextFindParameter.Regex;

            foreach (PdfTextFind text in pdf.Pages[0].FindText(strSearchText, tfp).Finds)
            {
                text.ApplyHighLight(System.Drawing.Color.Gold);
            }

            pdf.SaveToFile(strTarget);

            pdf.Dispose();
        }

[rachel.lei]

Hello,

Thanks for your response.
I converted your Excel file to PDF using the temporary version spire.office v5.6.9, but found that some words were cut off, as shown below. However the PDF file you provided is correct. Which version of Spire.Office are you using? And please also tell us your OS information (E.g. Windows 7, 64 bit) and region setting (E.g. China, Chinese). Thanks in advance.

comparison.png

Meanwhile, regarding the new PDF file you provided, I have verified that the word "Co-Founder" can be found in Adobe. But using our product to find it failed. This issue has been logged in our bug tracking system with ticket SPIREPDF-3374 for further investigation. If it is fixed, we will let you know ASAP. Sorry for the inconvenience caused.

Sincerely,
Rachel
E-iceblue support team

[wraydc]

Rachel,

Thanks for raising the ticket. Can you make sure that this has a high priority because the FindText issues continue to hold up a client release.

In respect to systems settings: Windows 10, 64bit, UK/English region. Through those regional settings, my standard page size is A4, I don't know if that may be a difference between our configurations which may cause the bunching up of the columns in the PDF version.

I hope that helps,

Darren

[rachel.lei]

Hi Darren,

Thanks for your response and sorry for the late reply as weekend.
Yes, I have given your issue the highest priority and forwarded your urgent situation to our Dev team. Once there is any progress, we will notify you ASAP.
In addition, regarding the conversion issue I mentioned, I tested it in an environment similar to yours, and did find the content of generated PDF is correct. Thank you so much for providing more information to help me investigate further!

Sincerely,
Rachel
E-iceblue support team

[wraydc]

Rachel,

Thanks for the update - Do let me know as soon as there is any progress, or if there is anything else that I can provide to help the devs recreate/fix the issue.

Many thanks in advance,

Darren

[rachel.lei]

Hi Darren,

Thanks for your following up.
I just checked the status of this issue and found that is has been resolved! Now it is under the testing phase, once it passes the test, we will prepare a hotfix for you ASAP.

Sincerely,
Rachel
E-iceblue support team

[wraydc]

Hi Rachel, just a quick check-in. Any news on the hotfix.

Many thanks in advance,

Darren.

[rachel.lei]

Hi Darren,

Thanks for your following up.
Your issue is now resolved, our Test Team is compiling a temporary Spire.Office version for you. Once it is available, I will inform you at the first time.

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hi Darren,

Thanks for your patient waiting.
Here we prepared a temporary version for you, please download it from the following link and test. If there is any question, please get back to us ASAP.
http://www.e-iceblue.com/downloads/Temp ... _5.7.0.zip

Sincerely,
Rachel
E-iceblue support team

[wraydc]

Thanks Rachel, I'll try and get this tested today muy time.