New Windows fonts and Word wrapping for text cells

Posted by: abrahampetit on 28 October 2019, 12:32 am EST

  • Posted 28 October 2019, 12:32 am EST

    Hi,

    Old fonts such as Arial Sams Serif, Courier, etc. work fine with the spread 8. But the new ones like calibri, candara etc, although they can be used in a spread sheet, they dont inherit certains behaviours like "word wraping".

    Look at this example:

    "This is the title for column 1"

    If using "arial" you can get a word-wrapped text cell as

    | This is the title |
    |for column 1 |

    But if you use calibri you will get

    | This is the tit|
    |le for column 1|


    In the second example, the word : "title" is cut as "tit" and the next line will start with "le"


    Is it possible to fix this for Spread8?


    Thanks?








  • Replied 31 October 2019, 3:23 pm EST

    Hi,

    I could not replicate the issue using the latest version of Spread. The wrapping works fine for the said fonts: Calibri and Candara. Can you please try using the latest Spread 8 COM version and see if that makes a difference? You can download it from here:
    https://www.grapecity.com/spreadcom

    In case the problem persists at your end, please share a small sample demonstrating the same. I would like to investigate it further.

    Thanks,
    Pragati
  • Replied 1 November 2019, 4:31 pm EST

    I can also confirm the problem with Calibri and word wrapping.
    I am using the latest vesrion .

    Regards

    Yiannis
  • Replied 3 November 2019, 7:21 pm EST

    Hi Yiannis,

    As I mentioned, can you please share a small stripped down sample demonstrating this?

    ~Pragati
  • Replied 3 November 2019, 7:50 pm EST

    Hi,

    I am attaching a workbook where you can see the problems in the text in column 2.
    If you change the font to Arial 11 for example (instead of Calibri 11) the word wrapping behaves as it should.

    I want to emphasize that many issues have been given a case number and the answer is always that "the development team is looking into it" but months and years go bye and I have not seen any issues or request to be solved/implemented.

    It is a shame!. If you have kill Spread 8 and no updates are planned please let us know!.

    Regards

    Yiannis
  • Replied 4 November 2019, 4:38 pm EST

    Hi Yiannis,

    I am sorry but the workbook did not get through with your last post. Please zip the sample (needed to investigate the issue further) and workbook together and then, upload here.

    Regarding the escalations, I would like you to know that Spread COM is in maintenance mode. I have still forwarded your feedback to the Product Management team and will share their insights soon.

    Thanks,
    Pragati
  • Replied 4 November 2019, 5:40 pm EST

    Please see attached.
    DEMO1_BILL2_word_wrapping.zip
  • Replied 4 November 2019, 9:41 pm EST

    Yiannis,

    Thank you for sharing the file.
    However I could not replicate the issue on loading the file in Spread designer at my end. The text "this is a demo with Calibri 11 font..." in second column of the sheet wraps correctly.
    Please refer the attached video demonstrating the same.

    Kindly check Spread version at your end and make sure that you are using the latest, as suggested earlier.

    ~Pragati
    Wrapping.zip
  • Replied 4 November 2019, 10:22 pm EST

    Hi,
    I am using version 8.28.
    For me it does give erroneous wrapping!.
    Maybe it has something to do with windows language settings ?

    Please see attached video

    Regards

    Yiannis
  • Replied 4 November 2019, 10:23 pm EST

    Video
  • Replied 4 November 2019, 10:25 pm EST

    Video...again
  • Replied 5 November 2019, 3:22 am EST

    https://www.dropbox.com/s/w45bo6z79r4glqi/Recording%20%23172.zip?dl=0

  • Replied 5 November 2019, 9:00 pm EST

    Thanks, Yiannis.
    I could see the issue occurring at your end even with the same latest version.
    What is the language of your OS? I will check with the same locale at my end.

    ~Pragati
  • Replied 5 November 2019, 9:08 pm EST

    Hi,
    language = english (US)
    language for non unicode programs = Greek

    I am using unicode fonts.

    Regards

    Yiannis
  • Replied 6 November 2019, 7:49 pm EST

    Yiannis,

    I checked with Greek set as the language for non-unicode programs on a Windows XP machine at my end. However, the issue still does not replicate.
    What is the OS that you are using at your end? Is there any other environment specific information that would help me in reproducing the issue here? Please confirm.

    ~Pragati
  • Replied 6 November 2019, 9:24 pm EST

    Hi,

    I am using Windows 10 but it has been reported to me by others using Windos 7.
    It is really an enigma!
    I watched your video and I can not udnerstand why the differences. After all you are using my workbook!
    Thank you for the effort you are putting in this issue.

    Regards

    Yiannis
  • Replied 7 November 2019, 7:34 pm EST

    Hi Yiannis,

    Thanks for the kind words :)
    I could replicate the issue on a Windows 8.1 machine at my end. I have escalated it to the developers (internal tracking ID: 277396) and will update this case as soon as there is any information from them.

    Thanks,
    Pragati
  • Replied 14 November 2019, 1:32 am EST

    Thanks!

    Please keep us informed about this issue, thank you for the help, and also thanks to "yianeco" for explaining very well the issue...
  • Replied 17 November 2019, 9:28 pm EST

    Sure.
  • Replied 6 January 2020, 1:21 am EST

    Hi!

    We keep am old VB6 legacy App and our users need to import some Word documents to a Spread 8 COM Sheet, all is fine so far thanks God, however most of these documents use Microsoft CALIBRI font, thus the problem explained in this discusion still bother them. Could you please prioritize this fix for the Spread8?

    Thanks!




  • Replied 6 January 2020, 4:16 pm EST

    Hi,

    I have asked the developers to look into the same on priority. Will let you know once there is any information from them.

    Thanks,
    Pragati
  • Replied 6 January 2020, 6:22 pm EST

    I am afraid that Spread com has been dropped by Grapecity but you decline to make it official.
    It is not the first time that you have given us a number and say that developers are looking into it but months and yeras go by and nothing is done.
    So I am not expecting any update or fixes by Grapecity. Spread com is dead. At least make it official!

    Yiannis
  • Replied 6 January 2020, 8:06 pm EST

    Hi,

    I think Spread COM/DLL is not dead because you can have an online support on it.
    3 years ago, I have reported a problem with the "Calibri" font which has been corrected... but 6 months after.
    Yiannis : send a message regularly and you may have a correction in several weeks ... or several months!

    Yves
  • Replied 6 January 2020, 8:21 pm EST

    What fix are you refering to ?
    Calibri font problem is still alive!

    Yiannis
  • Replied 6 January 2020, 9:04 pm EST

    Spread 8.0.24 : Importing Excel-formatted files that use the Calibri font now works correctly. [130276]

    Yves
  • Replied 7 January 2020, 7:45 pm EST

    Hi Yiannis,

    SpreadCOM is certainly not dead. Since the product is in maintenance mode from a long time now, the development process has slowed down.

    The developer is currently looking into your issue and I will update this thread as soon as there is some conclusion.

    Thanks,
    Pragati
  • Replied 7 January 2020, 8:47 pm EST

    Good to know!
    But please also look other requests for upgrade and other issues which have been reported/requested over a year ago!

    regards

    Yiannis
  • Replied 8 January 2020, 4:34 pm EST

    Hi Yiannis,

    The developer investigated this issue more thoroughly, and it appears to be working as designed.

    The EDIT cell type does not have support for word wrap - it supports only 2 modes of drawing the text: (1) single-line and (2) multiline with character-based wrapping.

    Adding support for drawing the content of the EDIT cell type with correct word wrap that breaks on the word instead of the character would require enhancing the code handling the wrapping, and also require adding new API to enable this new drawing option (to avoid breaking code by changing the default drawing for the EDIT cell type). This beyond the scope of bug fixing and into "new feature enhancement" instead. All versions of Spread COM have painted the EDIT cell type this way (with character-based wrapping for MultiLine) so simply changing it would break your code.

    The logic handling the wrapping does account for hard-breaks in the cell content, so as a workaround, you can edit the cell and insert hard line breaks before the words that are split by the character wrapping, or the application can insert those CR/LF in the text.

    Note: Can you please share the threads where you still wait for the reply from our side? I will look into them further.

    Thanks,
    Pragati
  • Replied 8 January 2020, 5:10 pm EST

    I have to disagree with developers!
    EDIT cell dows support word wrap and not only characted based wrapping.
    I use it all the time and it fails only with Calibri font.
    Please see attached video

    Regards

    Yiannis
  • Replied 8 January 2020, 5:11 pm EST

    It seems the video could not be uploaded. Please share it again.
  • Replied 8 January 2020, 5:15 pm EST

    Recording #174.zip
  • Replied 9 January 2020, 8:08 am EST

    Hi,

    You have written...

    "The EDIT cell type does not have support for word wrap..."


    Hey! my fields are not type EDIT, they are "CellTypeStaticText"...

    Look what happens If I set to a text cell "My name is Tonny" with an old Microsoft Font, such as Ms Sans Serif, Courier New, Arial, etc....


    My name
    is Tonny


    If the user shorten the column manually, it will show

    My
    name
    is
    Tonny


    Which is perfect!!!



    Now look at this, please....

    The user changes the font to "CALIBRI", look what happens in the first case


    My nam
    e is Tonn
    y

    Now the user changes the column width manually, look what happens

    M
    y n
    am
    e i
    s T
    on
    ny

    You see?

    Again, these are not EDIT cells, these are normal STATIC TEXT CELLS


    I do appreciate your effort to understand and address the problem, but we need an effective solution.


    Thanks and happy New Year!!!








  • Replied 9 January 2020, 4:01 pm EST

    Hi,

    A Very Happy New Year to you too!

    I have notified the developer regarding your comments. Will get back to you once he shares his insights on this.

    Thanks.
  • Replied 16 January 2020, 5:26 am EST

    Hi,

    I can reproduce this issue with both static text and edit cell types now -- it appears that the code is drawing the text and computing the wrapping differently for those fonts, and that looks like a bug: the word wrapping should be consistent regardless of the font applied in the cells, and it looks wrong for some fonts to do the word wrapping correctly and break on the word, and for other fonts to instead break on the character instead.

    I will need to debug the issue this weekend and reply again next week with the result.

    Regards,
    -Sean
  • Replied 19 January 2020, 10:59 am EST

    Thank you Sean,

    We appreciate you help. I cant wait to see an update....
  • Replied 2 March 2020, 9:18 am EST

    Hi,

    Its been some months since I reported a bug with the calibri font on spread8. Did you include this bug in your log of bugs to fix? or did you totally discarded it? I think that most users do not care about look and feel, but this is not the case. Please keep us informed.

    Thanks
  • Replied 2 March 2020, 8:58 pm EST

    Hi,

    The developers have added the bug in their to-do list. Let me ask them about this. Will get back to you soon.

    Thanks,
    Pragati
Need extra support?

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

Learn More

Forum Channels