OpenExcel with stream and conditional formatting

Posted by: petrir on 8 September 2017, 3:20 pm EST

  • Posted 8 September 2017, 3:20 pm EST

    Hi!

    We have problem with opening Excel file with conditional formatting with formulas. If Excel file is opened from file everything works fine, but when opening Excel from stream (we have excel files in database) the conditional format does not work. Also merging cells disappears. Check the attached excel file to see the problem.
    2015/11/Conditional-formatting-with-formula.zip
  • Replied 8 September 2017, 3:20 pm EST

    We are using version 8.35.20151. With previous version 7.35.20132.1 there was no problem opening this file with stream.

    Br, Petri
  • Replied 8 September 2017, 3:20 pm EST

    Hello,

    Unfortunately, we are unable to replicate the issue at our end with the given information.

    We created a sample application for the same but we are unable to replicate the issue.

    We request you to send across a sample application or modify our application and send it back so that we can investigate the issue further.

    We are sorry further investigation of the issue is not possible with the provided information. We request you to send across additional information if you wish to continue the investigation.

    Thanks,
    Reeva

    2015/11/Spread_Win_OpenExcel_Stream.zip
  • Replied 8 September 2017, 3:20 pm EST

    Hi!

    I could replicate the issue with your sample application. Check the the attachment. Did you see the condinitional formatting on rows 10 and 11 ?
    Reference to Farpoint.Excel is to version 8.35.20151.0.

    Br,
    Petri
    2015/11/Result-pictures.zip
  • Replied 8 September 2017, 3:20 pm EST

    Unfortunately, we are still unable to replicate the issue at our end with the given information using same build as that of yours.

    Please go through the attached image for the same and let us know what are we missing to replicate the issue at our end.

    Thanks,
    Reeva

  • Replied 8 September 2017, 3:20 pm EST

    Hi!

    Now we are using version 9.35.20153.0 and still having the same problem with opening from file stream.
    See the attached project and picture.

    Br,
    Petri
    2015/11/Spread_Win_OpenExcel_Stream1.zip


  • Replied 8 September 2017, 3:20 pm EST

    Hello,

    Unfortunately, we are still unable to replicate the issue at our end with the given sample and using same build as that of yours which is 9.35.20153.0

    Please go through the attached image for the same and let us know what are we missing to replicate the issue at our end.

    Thanks,
    Reeva

  • Replied 8 September 2017, 3:20 pm EST

    Hi

    We have been able to pinpoint the problem. We are having Regional Settings to 'Finnish' which seems to couse the problem. (works with US) I have imroved the test program where now it is giving a excel warning "Code: CannotOpen Message: Failed on File Open - OpenXmlOperator.Load"

    Hope you manage to reproduce it now.
    Thanks,
    Mikael

    2015/12/Spread_Win_OpenExcel_Stream.zip
  • Replied 8 September 2017, 3:20 pm EST

    Hello,

    We are able to replicate the issue with "Finnish" Regional Settings and hence we are escalating the same to the concerned team for the fix.

    #139768 is tracking id of your issue.

    We will update you once we hear anything from them.

    Thanks,
    Reeva
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels