Unexpected font size in text copied from Writer

[White Phoenix]

I am doing some experimenting with words. I created a list of sentences with certain words highlighted in blue. All of the text in Writer was Times New Roman in 10 pt. I wanted to transfer them into a spreadsheet, but when I did, all of the blue text is now in a larger size font than the text using the automatic default. I want to keep the highlighted text but have it at the same size as the default.
First of all, why did this happen in the first place? There is no reason for the colored text to become a different size just because it was transferred into Calc.
Second, how can I keep the font color and change the font size back to the 10 pt text size which is the default in Calc and Writer? I also noticed that the rows are oversized as well. I can do the cells one at a time, but they are still misaligned even though the settings say that everything is as it should be.

Screenshot from 2024-10-30 03-00-24.png (126.75 KiB) Viewed 912 times

Screenshot from 2024-10-30 03-14-21.png (49.67 KiB) Viewed 912 times

[robleyd]

Whilst your screenshots attempt to show what happened, they do not help in diagnosing why. The quality is not sufficient, at least for me, to even see detail of the images.

Can you provide a sample of the source writer document and a destination spreadsheet. And describe exactly how you "transfer them into a spreadsheet".

[Nicholas59]

Dear Mr. Phoenix,
In the past I've been told about OLE features and facilities within Office.
Surprised by your announcement, I have on my turn tried a simple text transposition from Writer throung Calc AND I encountered what I was expecting.

As Mr. Robley stated, BE so kind to post an example.

Regards

[Hagar Delest]

Just guessing: it may be related to the way you applied the highlighting. If it is a style or a direct formatting, there may be some settings that triggers the difference in CalC;
I just tried with an AOO 4.1.3 on Windows and there is no change of font size in Calc when pasting sentences from Writer with words highlighted.

[White Phoenix]

First of all, there isn’t much else to see. There isn’t any way to create a style where certain words are in a different color that the automatic color, is there? So of course I had to do it directly.
Actually what I did in Writer was go down my word list and did a “Find All” for each word. Then I changed the font color of each highlighted word to blue 3. The font size in Writer was not affected. So it doesn’t seem that the font size of the words in blue should change after the sentences were pasted into Calc. They didn’t even change size consistently. I had to do the highlighting in Writer since you cannot highlight individual words in Calc, can you?
About the detail of the images, in order to show detail and being limited by the size of the image to upload, I would only be able to show a section. So rather than do that, I will upload my spreadsheet.
I will need to redo the highlighting in Writer then upload that file. Also it may be a thing that only occurs in Linux.
In any event, since I abandoned the way I was going to do a word count, I now have the problem of counting the number of times each key word is repeated in Writer. The Properties only shows the overall word count. The sheet in Calc that’s messed up is “Words”. The next sheet, WrdCt, is the redo.

Phrase List.ODT

(19.1 KiB) Downloaded 8 times

Diacritics Test.ODS

(92.62 KiB) Downloaded 8 times

[White Phoenix]

Just guessing: it may be related to the way you applied the highlighting. If it is a style or a direct formatting, there may be some settings that triggers the difference in CalC;
I just tried with an AOO 4.1.3 and there is no change of font size in Calc when pasting sentences from Writer with words highlighted.

Well, Hagar, since I am using 4.1.15, that might mean something went wrong since 4.1.3. I also noticed Writer behaves differently on Linux than it does on Windows. On Windows the pages scroll from the top down. In Linux, the pages are presented like book pages with the first two pages being followed by the next two below them.

[Nicholas59]

Dear Mr. Phoenix,

Sorry, but I couldn't read too good your sentence, especially when you say that Writer does not allow the scroll Page by Page.
If you spend your time in "customizing" your Text, you should also bear in mind the changes you have made.
Regards

[robleyd]

Writer behaves differently on Linux than it does on Windows

https://wiki.openoffice.org/wiki/Settin ... _documents - see section 3 View layout.

[Hagar Delest]

I made some tests with your file and with LO 24.8.2.1 on my Xubuntu box, there is no problem when pasting from your .odt file to your .ods file. It is the last line shown in my screenshot below.

Note that not only the blue words have the font changed, some of the black words do show the change too:

Calc_paste.png (13.71 KiB) Viewed 557 times

[Nicholas59]

Have made an aside test too, to prove that machine only executes what the user does. In such case no changes were made either.

[White Phoenix]

So my images were faked and I’m a liar. Remember, Hagar, you are using an older version, while I am using the current version. On the other hand, maybe I should downgrade.
Nicholas59 you are changing the entire line, not just some words of the line. And why is “Am” being flagged as misspelled? Plus are you using LibreOffice or OpenOffice? I did not change the font size or use a different font.
I only changed the color and only on certain words in Writer. You should be able to see that. The text was all in Times New Roman font size 10. Same as Calc. Even though the text is different font and size the toolbar in Calc says it is all the same font and size. 10 pt Times New Roman. Normally when things are mixed that part goes blank. That isn’t happening in my spreadsheet. Apache OpenOffice 4.1.15 on Linux Mint 21.3.
robleyd, ever since I upgraded Mint I noticed that several settings were changed to default on my system and applications. I hardly ever use Writer and have used the same settings for so long I don’t even remember having the choice that your link shows. So now I’ll have to go through all of my AOO settings and put them back the way I had them. Although, I kind of like seeing two pages at a time. So I will keep that setting.

[Hagar Delest]

So my images were faked and I’m a liar.

That is your own conclusion, I never said so. I just showed what I saw.

Remember, Hagar, you are using an older version, while I am using the current version.

Please read again. I made a test on a Windows machine with an old version of AOO in my first post (I was not at home) and then on my second attempt on my Xubuntu box with LibreOffice, giving a result that seems slightly different than yours (your screenshot is too fuzzy to be sure).

But well, I don't like how this discussion is going, thus I'll leave it here.

[Nicholas59]

@Phoenix

Am is flagged because the dictionary is in Italian. You can read my signature at the bottom line.
Am afraid a single cell cannot have two different sizes at once, but it might be possible as you can see hereafter.

[Hagar Delest]

Am afraid a single cell cannot have two different sizes at once, but it might be possible as you can see hereafter.

Of course it can.
Done with LO but I'm sure AOO can do that too, proof is OP first screenshot (even if blurry):

Colors_in_cell.png (11.9 KiB) Viewed 395 times

[Nicholas59]

Thank you Mr. Delest, i was uncertain about that.
Regards

[Alex1]

I see these font changes too. I suspect an error. To be sure, I created some examples from scratch.
LibreOffice has problems with it too, though the effect isn't exactly the same.

[White Phoenix]

Am afraid a single cell cannot have two different sizes at once, but it might be possible as you can see hereafter.

Of course it can.
Done with LO but I'm sure AOO can do that too, proof is OP first screenshot (even if blurry):
Colors_in_cell.png

i apologize for sounding petulant. I was trying for irony. The alternative was that I was just imagining it. Now people are seeing that there is a problem, even in LibreOffice. Well, if earlier versions of OpenOffice didn’t have this problem, I can go back to the earliest version in my collection 4.1.5. I never saw much in the way of improvements since Apache took over. Of course having experienced programmers quit the project didn’t help. So it isn’t completely Apache’s fault. Oracle dropped it in their lap and that’s all to it.

Of course, like I said earlier, the reason I was highlighting the text was to make it easier to do a word count of individual words. So its a moot point now except for reporting a bug.