I’m trying to solve a problem I have. I’m learning Russian and have over 50 pages in a Writer .odt document where I list Cyrillic Russian words with their English meanings. I should have thought this out from the start but I now want to be able to use a LO text to speech extension to pronounce the Russian words. I should have saved them in a table or a spreadsheet where I kept all the Russian words in a column and the English translations in a second column. Instead, I have them alternating Russian word, English translation one line (paragraph) after another for over 50 pages. I’ve tried setting the language so I can have the Russian pronunciations ignore the English translation lines, but I want the translations because I have not yet memorized all the meanings.
I tried to get Gemini AI to help me with that and it took me on the most incredibly long, circuitous, mind boggling variations and attempts that ALL failed. The one that seemed to me like it might possible be workable was copying all the pages into a Calc spreadsheet into the A1 cell. Then in the B1 cell I used this formula. =OFFSET($A$1,(COLUMN()-1)+(ROW()-1)2-1,0) then in the C1 cell I used this one =INDEX($A:$A, 2ROW())
I tried to copy them to the end of the document (over 50 pages) but it died out on about row 1457 then began filling in the rest with zeros. I tried forcing recalculations using Ctrl+Shift+F9, but that did not work. Can anyone help me with this? I tried writing a macro, running Ctrl-H Find and Replace, and a ton other things. I’m stuck.
I don’t want to manually find and replace anything on a document over 50 pages long (and I have multiple such documents). I want to keep the ability to listen to correct pronunciations but need also to keep English translation meanings. I don’t wan to have to sign up for a paid service.