+ Reply to Thread
Results 1 to 14 of 14

Single character deletes your entire post.

  1. #1
    Registered User
    Join Date
    06-06-2006
    Location
    English(UK)
    MS-Off Ver
    2019
    Posts
    93

    Single character deletes your entire post.

    Try to write a post that includes
    Please Login or Register  to view this content.
    If you try to preview the post or you edit the post afterwards, all post text will vanish. Entirely.

    That's a terrible bug.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Single character deletes your entire post.

    A bc def ƒ abcd
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Single character deletes your entire post.

    It certainly seems to be the case. That said, there have been many occasions in the past when I, and many others, have experienced content vanishing when editing a post. Not sure if this is a specific example of that issue or if there are other characters and character combinations that cause this effect.

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Single character deletes your entire post.

    You seem to have managed it here OK: https://www.excelforum.com/excel-for...summation.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Single character deletes your entire post.

    Yes, but you cannot edit the post afterwards..

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Single character deletes your entire post.

    Formula for inverse of summation

    Well, this will probably be looooong shot, but I figure it's worth a try.

    I need an excel formula that inverses of this function:


    ƒ(x) =∑(mm+ i)2π2(x-s*i)3, i=0 to k


    I need ƒ-1(y)
    Now, the best I could manage is hitting the character limit for formulas in excel...

    P.S. LaTeX is a truly wonderful invention.

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Single character deletes your entire post.

    I have copied and pasted the text from that thread, barring the formatting. The issue is that you cannot subsequently edit the content. Even if you were to adopt the belt and braces approach of copying the text (just in case), you then lose any formatting ... as I did above.

  8. #8
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Single character deletes your entire post.

    Quote Originally Posted by Pepe Le Mokko View Post
    Yes, but you cannot edit the post afterwards..
    But the post in the link has been edited afterwards...

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Single character deletes your entire post.

    I understand what you are saying ... but maybe the content needed to be retyped from scratch.

    I cannot edit post #2 or post #6.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Single character deletes your entire post.

    Content doesn't need retyping from scratch: you do not need to hit the edit button to copy the original text. That's what I do when this happens to me: copy the text and THEN hit edit, paste and edit, then save.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  11. #11
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Single character deletes your entire post.

    Perhaps, lacking our experience of the foibles of the forum, the OP was not aware of the options available. However, copying the content, going into edit the post, and then reposting the content before actually attempting to edit it does lose any formatting. Compare the content I copied into post #6 to the original to observe the difference.

  12. #12
    Registered User
    Join Date
    06-06-2006
    Location
    English(UK)
    MS-Off Ver
    2019
    Posts
    93

    Re: Single character deletes your entire post.

    Quote Originally Posted by TMS View Post
    I understand what you are saying ... but maybe the content needed to be retyped from scratch.

    I cannot edit post #2 or post #6.
    Effectively. I had it copied over from a text editor. Precautionary habit I have.

    And as noted time and time, the problem with copying the text is, you lose formatting.

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Single character deletes your entire post.

    Perhaps, lacking our experience of the foibles of the forum, the OP was not aware of the options available.
    I would say so.

    Yes, you lose formatting, I know that, but at least you don't have to start from scratch. You don't, however, lose any attachments.

    The reason for making my post was to advise anyone reading this thread for the first time that all is not lost. There's not much value in a thread such as this one unless we point out the workarounds (or 'foibles') for those who don't already know. It's not something that is ever going to be fixed, sadly.

  14. #14
    Registered User
    Join Date
    06-06-2006
    Location
    English(UK)
    MS-Off Ver
    2019
    Posts
    93

    Re: Single character deletes your entire post.

    Quote Originally Posted by AliGW View Post
    It's not something that is ever going to be fixed, sadly.
    That is quite unfortunate.

    In the mean time I have discovered a workaround for not losing anything, even formatting - you just quote the post. The text, formatting and all appears in the "Quick Reply" box, without having any page loads, which is what causes the issue.

    Something is broken in the cross-page storage mechanism. The data isn't stored client-side, I checked at DOMContentLoaded, nothing in session/localstorage/cookies or anywhere. There must be something wrong with the server-side, encoding maybe? Prob not with db, since post gets made, handling unicode on php side maybe?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 09-26-2019, 03:13 PM
  2. Split text in a column using an entire word and not just a single character
    By hisuh1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2019, 02:31 PM
  3. [SOLVED] Find and Replace value deletes entire cell contents
    By patb in forum Excel General
    Replies: 5
    Last Post: 09-25-2018, 10:27 AM
  4. VBA that deletes entire rows if value is NOT found in part
    By Andrewstupendo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-21-2018, 03:01 PM
  5. [SOLVED] vba code that deletes entire row if there is a zero in that row of my highlighted area
    By gt4udish in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2015, 03:39 AM
  6. Useful code that deletes entire rows based on formatting
    By Ralfie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2007, 01:02 PM
  7. hitting spacebar in excel deletes last character entered.
    By badgercat in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-14-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1