Font and format commands fail to take effect (.ODS file provided)
Steps to Reproduce:
1. open the .ods file attached (name will be the same as the bug number)
2. note that the font is Prestige Elite
3. select one or more cells and try to change the font
4. try to change to bold or italic or superscript
None of the commands take effect
User should be able to select a range of cells and apply formatting.
User Profile Reset: No
WORKAROUND: You can double click each cell individually and then editing is allowed. Needless to say, this is a crippling limitation when dealing with this bug on a repeated basis.
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36
Created attachment 133654 [details]
file to reproduce bug of same name
I don't have a way to reproduce this from scratch but it occurs over and over in a large spreadsheet containing many unwanted instanced of Prestige Elite that I wish to change to Courier New and am unable to do so en masse.
I can't remember if these cells were originally set to Prestige Elite in Calc or in Excel before I switched to Calc. I hope you realize that being able to import Excel files is not a minor or trivial feature. The great majority of your user base learned how to use spreadsheets with Excel and have many Excel-created spreadsheets. All that said, it's equally possible that these corrupted cells began life in the release version of Calc I was using prior to switching to 18.104.22.168.
Created attachment 133655 [details]
try this one first
I think I may be missing a step.
Try this file instead (108185-b.ods) and add these steps at the beginning
1. select all the cells with contents
2. note that while there are superscript characters, the superscript button is greyed out
3. click bold or italic or the font size (nothing happens)
4. the font is shown as Prestige Elite - try to change to Courier New (nothing happens except that now the font is designated as Courier New in the formatting box (while the font shown in the cell continues to be Prestige Elite).
NOTE!: The funny looking superscripts in the spreadsheet when you first open it were NOT entered that way by the user. That was a bit of corruption that occurred at some point in the history of the spreadsheet, probably going from the release version of Calc I was using before 22.214.171.124.
Created attachment 133656 [details]
screenshot in case you can't repro
this screenshot shows the bug in action
1. cell C2640 is selected
2. the Formatting toolbar shows Courier New
3. you can see that the font displayed in the selected cell is not Courier (it's Prestige Elite) - so even before trying to apply formatting you can see that something is wrong - somewhere in the cells internal header or whatever is something that tells the toolbar to display an incorrect font.
Created attachment 133662 [details]
screenshot 1 after new user profile
Created attachment 133663 [details]
screenshot 2 after new profile
(In reply to Kevin from comment #2)
> 4. the font is shown as Prestige Elite - try to change to Courier New
> (nothing happens except that now the font is designated as Courier New in
> the formatting box (while the font shown in the cell continues to be
> Prestige Elite).
Something does happen: B and D columns get their font changed.
But I guess this is the same root issue as your bug 108041, right?
> But I guess this is the same root issue as your bug 108041, right?
I'm not an engineer, but I think the root issues are that:
1. whatever internal header or xml data or whatever the UI looks at to know what the font and font attributes gets set to some form that makes the UI display false information
2. however the code is written for the formatting commands, it fails to see that the format is wrong and fails to clear it and rewrite it properly
Based on a comment from someone who is an engineer I tried to view the XML but was unable to do so. If I could see that, I could try each command and see how the UI writes the internal XML (I only say XML because that term was used in the comment). If I could see what happens to that when the bug occurs I might be able to come up with steps to cause the problem without having to use data from the imported Excel file. But to repeat, being able to smoothly handle Excel files has got to be right at the top of the list of things this program needs to do, right?
I looked up XML and found this:
<font face = 'Tahoma' size = '19' hatch = 'largecheckerboard, white, red'>TAHOMA FONT</font>
I'm guessing that Calc is storing something like that for each character, right? And I'm guessing that one part of the UI writes this with bad syntax and the other part of the program doesn't know how to read it so it does nothing or shows the user the wrong info.
What I'm saying is that all this bugs are really happening - over and over - and they're not "trivial" - they're crippling.
(In reply to Kevin from comment #7)
> Based on a comment from someone who is an engineer I tried to view the XML
> but was unable to do so. If I could see that, I could try each command and
I'm not an engineer, but an ordinary user like you. I don't have any higher education, just high school.
You can rename the .ods to .zip and perhaps WinRAR will accept it. 7-zip is smarter in this regard.
>You can rename the .ods to .zip and perhaps WinRAR will accept it.
very clever - that worked - thanks - I've uploaded a screenshot of what WinRAR shows me. I tried extracting content.xml. I can view it in notepad but I haven't been able to see how the formatting is represented. I'm uploading that file as well.
Created attachment 133857 [details]
Created attachment 133858 [details]
screenshot of WinRAR's extraction of .ods renamed .zip
> I'm not an engineer, but an ordinary user like you.
Maybe you should become one - somebody's got to fix this thing before I lose my mind! I just got so mad that I downloaded Apache Open Office and found the most curious thing - almost all of my Calc bugs behave exactly the same way in Open Office. I guess the bugs are at some deeper level of whatever code base the two share. So then I tried google docs spreadsheets - a total joke - even worse than Excel. There must be some program that will let you make good looking charts. I can't believe how bad all four of these programs are.
I created two similar reports based on this bug (with steps to create the problem. See bug 108391 and bug 108394
(In reply to Kevin from comment #0)
> Steps to Reproduce:
> 1. open the .ods file attached (name will be the same as the bug number)
> 2. note that the font is Prestige Elite
Only cell D2 is Prestige Elite in the file I downloaded (under the try this one first link).
> 3. select one or more cells and try to change the font
Selected D2 and E2, changed font to Courier New - change successful, cell D2 font was changed to Courier New.
> 4. try to change to bold or italic or superscript
Selected D2 and E2, changed attribute to bold. Both cells individually now have the bold attribute.
Works for me.
Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU Threads: 2; OS Version: Mac OS X 10.12.4; UI Render: default; Layout Engine: new;
Locale: fr-FR (fr_FR.UTF-8); Calc: group
@Kevin : note that if Prestige Elite is a postscript Type 1 font, it is no longer supported. LibreOffice will try and use a fallback font instead, and perhaps this (or a related bug) is causing the issue you are experiencing.
@Kevin : please specify which version of macOS you are using, as this bug is reported as affecting macOS, yet your reporting browser indicated WinNT6.1, with Chrome and Safari browsers.
If you are not using macOS, please correct the system hardware dropdown choice.
(In reply to Alex Thurgood from comment #16)
Sorry - I chose the wrong OS. I use Windows 7 - changed the drop-down accordingly.
Alex: it says here it is from URW++: https://www.myfonts.com/fonts/urw/prestige-elite/
Doesn't that mean it is indeed Type 1?
Kevin: can you please check it by looking at the font properties.
Created attachment 133994 [details]
prestige elite font
It appears to be an open type font (otf)
The problem of font types and attributes not being editable happens with all sorts of fonts.
The content of attachment 133994 [details] has been deleted for the following reason:
It is illegal to distribute commercial fonts
I didn't go into this bug, but with what Alex wrote and little search leading to Bug 37453, I'll close as WF.