[libreoffice-users] Clearing formatting.
Hi, just wondering if there is an easy way to clear formatting of the style '2892 where the apostrophe is used. When I paste data from a web page LO inserts the apostrophe by default. I realise there are options on pasting to have numbers pasted as text, but my query is in regards converting '2892 to the number 2892. I cannot Format Cells... format as number or clear direct formatting or find and replace the '. I can Ctl-x, Ctl-Shft-v and paste and the ' is cleared. Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Spell check broken in 7.3.2
I have some documents that contain certain special wods (I write epic fantasy novels and create words that I use in the books), and I tried to do a number of things with these regarding the spell-checker: 1) I tried to delete my old 'stanard.dic', but it keeps coming bak on its own as if I never said to delete it. 2) I added a new custom dictionary with a different name, and that seemed to work. 3) However, when I run the spekk checker, after a few words I add to the new custom dictionary, if I click "Ignore Once", it wants to resume and won't let me go any further. I have to quiet the spell check and start over. At this rate it would take me weeks to go through one document. I haven't run a full spell-check on the book recently, but it never behaved like this before. This is a .docx file - could that be art of it? 7.3 was supposed to be more compatible with MSO, not less. WTF??? Mark LibreOffice fan/user since it took over OO's app and moved further better - until now? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Clearing formatting.
=On 6 Apr 2022 at 10:13, Steve Edmonds wrote: Date sent:60;Wed, 6 Apr 2022 10:13:51 +1200 To: 0;users@global.libreoffice.org From: Steve Edmonds Subject: ;[libreoffice-users] Clearing formatting. > Hi, just wondering if there is an easy way to clear formatting of the > style '2892 where the apostrophe is used. > When I paste data from a web page LO inserts the apostrophe by default. > I realise there are options on pasting to have numbers pasted as text, > but my query is in regards converting '2892 to the number 2892. > Not sure this would work. Assuming you are using text formatting dialog option. You could click on the other option in addition to whatever filtering options you are using. Then put the apostrophe in the position after the other. You will end up with a column with the blanks where the apostrophy was. Would then just delete that column. That does assume that all numbers in column have apostrophy and that other cells don't have apostrophy's? Another option that might work for you. Past data as currently done. In another column to right put formula No leading " an assuming D1 is cell with '2982 format numbers. Tried to match with "`" but it didn't work?? Had to use code and ascii value for `' \u201c=IF(CODE(LEFT(D1,1))=39,VALUE(MID(D1,2,20)),d1) If all numbers have ` you could just use. No leading " \u201c=VALUE(MID(D1,2,20)) Then copy the formula going down. Then highlight. Ctrl-C, and the Shift-Ctrl-V over original data, rather than doing one cell at a time. Perhaps one of those would work with your data. Good Luck. Have a nice day. > I cannot Format Cells... format as number or clear direct formatting or > find and replace the '. I can Ctl-x, Ctl-Shft-v and paste and the ' is > cleared. > > Steve > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/> Privacy > Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net ; mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Clearing formatting.
On 06/04/2022 15:03, Brian Barker wrote: At 10:13 06/04/2022 +1200, Steve Edmonds wrote: ...just wondering if there is an easy way to clear formatting of the style '2892 where the apostrophe is used. When I paste data from a web page LO inserts the apostrophe by default. I realise there are options on pasting to have numbers pasted as text, but my query is in regards converting '2892 to the number 2892. Are we talking spreadsheets? I don't think you mean formatting at all. At least, I suspect those apostrophes do not appear in the spreadsheet cells but instead only in the Input Line when you select a relevant cell. The apostrophe is just an indication - a warning - that what looks like a number in the cell is actually text. (Another indication may be that the values are left- rather than right-aligned by default.) I cannot Format Cells... format as number or clear direct formatting ... Well, you can do all of those things, but none of them will change the values you have in the cells, which is what you need to do - to convert text to the numerical value of that text, to convert two-eight-nine-two to two thousand, eight hundred and ninety-two. ... or find and replace the '. You certainly cannot do that, as there is no apostrophe in the cell value to be found! Here's an easy way: o Select the column of values. o Go to Data | Text to Columns... . o OK. I trust this helps. Thanks Brian, the above worked. Steve Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy