Search for text part written on specific font (Solved)

Hello there. I have an .ods (libreoffice.calc) file written on Arial font. But when I click on the upper left box so as to select all the cells, the font name bar becomes blank. So, I suppose that somewhere exist characters that are not in arial font. Is there any way to find the “culprit”? Thanks.

Thanks for replies. I followed this method: I selected several rows and looked the bar. If it said “Arial”, I went to the next “pack” of rows. If it said nothing, I selected the half of them etc, until I found the culprits: three cells not Arial, but Sans or Ubuntu.

I corrected the 3 culprits cells to Arial, but the problem remains. First of all, when I corrected each culprit cell, the bar for row containing it remained blank, although every cell of it was Arial, at least the cells I had worked. Is there the possibility there is somewhere (eg at column 800) a cell make the problem?

I corrected the 3 culprit rows in total. Now for every row the bar shows “Arial”. But if I select all the rows together, it shows nothing. I noticed the same paradox even for two specific rows: each one arial, both nothing. Is there the possibility there are two different fonts, both under the label “Arial”? I don’t know what to think.

Do you absolutely have to know the culprit? If you:

  1. Select all text
  2. Select the required font (Arial, if that is what you want)

…then all text will now be in the same font throughout.

I could not find a method within Find nor Find&Replace, so if you really NTK then it will need some programming.

In terms of a ‘suitable font’ I used kCharSelect to check Arial & was surprised to find it short on Greek chars (no Extended & even some Greek & Coptic missing). Try the DejaVu fonts. Open source, continually updated & a perfectly astonishing range of chars. Nice glyphs, too.

If this helps then please tick the answer (:heavy_check_mark:).

Thank you for the reply. I know how to make all text to be in the same font and this is what I’m going to do at the end. But first, I would like to find the culprit, because of the case I have to make corrections (language, encoding, whatever) to the data. There will be a reason it’s in a different font and maybe it’s not unimportant.

If the “culprit(s)” have assigned a named CellStyle you can find them using ‘F&R’ with the option ‘Search for Cell Styles’.

If the cells are formatted to a different font directly you will need a bit of custom programming, I’m afraid. Every cell can be asked by custom code for its property ‘CharFontName’.

The backround of your question might, however, be a wrong expectation. If you once set the ‘Arial’ font for the complete sheet directly (not modifying ‘Default’) you may expect that setting to be persistent except in cases where someone explicitly changed a cell’s font setting. It isn’t.

  1. As soon as you delete columns and/or rows new columns/rows will be created at the end with the ‘Default’ cell style assigned.

  2. If you ‘Drag&Drop’ cells the assigned styles will also be moved and thefore removed from the cells no longer covered by the range. In fact new cells are created which also have assigned ‘Default’ style.

Thanks. It helped me to find three cells that were not Arial, but they were Ubuntu or Sans. I changed them to Arial and repeated the search. This time all the cells looked to be Arial, but when I clicked on the upper-left box to select all cells, the font name bar became blank again. Another one strange thing: when I select two specific rows together, the font name bar is blank. When I select each one of them on its own, it’s Arial. Is it possible to be two different fonts both called “Arial”?

Finally I found out that the method didn’t help to find the three culprits. I had already found them by selecting several rows every time and, if the font name bar was blank, I selected the half of them etc, until every culprit was found. I tried again the “Search for Default” to the original file and I see it selects all the cells, including the culprits (Ubuntu or Sans).

But still there’s the problem that selecting each one row the bar shows Arial, whereas selecting all together bar is blank

Hi

To help find the cells you can do:

  1. Tools Options LibreOffice Fonts, check Apply replacement table
  2. ListBox Font: select Arial, Listbox Replace with: select any font that displays special characters (e.g. for windows wingdings or webdings, or Marlett), do not forget to click on the green :heavy_check_mark:
  3. Select the new line in the replacement table and check Always and Screen only
  4. Close with Ok

All that is not displayed in special characters is not arial

Regards

“All that is not displayed in special characters is not arial”

Wasn’t that an advertising slogan, somewhere? If not, it should have been!

Thank you. The cells contain text in english, text in greek and numbers. I don’t find a font that replaces all of them. But I’m afraid it wouldn’t solve the problem, because of what I wrote as a comment to the previous answer.

Finally I tried on another laptop with Puppy Linux and the webdings got the job done. On Lubuntu webdings were not available. But this method doesn’t help if the culprit is a blank cell.

Would it really important to spend so much energy to empty cells? The problem is even more complex because cells can contain “mixed” text. Simply it starts with Arial for that selection displays this name of font. Regards.

Probably it’s not. It’s rather psychological. Only if I selected all rows and the bar shows “Arial” I would feel that everything was under control. But I understand that is not an important reason to spend more energy. Thanks a lot for your help.