Noted in passing...
Apr. 29th, 2007 04:31 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
alexpgpSearch-and-replace in Excel is limited by the length of the "formula" in a cell, even if the entire formula is text. I haven't investigated what that length is, but I've run across it several times in the translation that I'm fixing.
It would appear that one can exceed the maximum formula length, but not the maximum row height (409 units), which cuts off some information in a few cells. Looks like I'm going to have to shrink the font to make the information fit.
The spell check is um, slow, since there does not seem to be any way of distinguishing text as "Russian" and "English," so that the checker stops to inquire about every newly encountered "English" word such as питание and блок. Such is the fruit of requiring the translation to appear together with the source text. (And to be quite frank, given the number of words in the assignment, the spell check is also not being done.)
I note this purely from a technical standpoint (though I must confess to a hint of Schadenfreude when I reduced the font size of those ginormous text blocks), and not from the perspective of the counterproductive rant from the other day.
I must get to bed within the next 30 minutes and try to get 5 hours of uninterrupted sleep. I start work at midnight.
Cheers...
It would appear that one can exceed the maximum formula length, but not the maximum row height (409 units), which cuts off some information in a few cells. Looks like I'm going to have to shrink the font to make the information fit.
The spell check is um, slow, since there does not seem to be any way of distinguishing text as "Russian" and "English," so that the checker stops to inquire about every newly encountered "English" word such as питание and блок. Such is the fruit of requiring the translation to appear together with the source text. (And to be quite frank, given the number of words in the assignment, the spell check is also not being done.)
I note this purely from a technical standpoint (though I must confess to a hint of Schadenfreude when I reduced the font size of those ginormous text blocks), and not from the perspective of the counterproductive rant from the other day.
I must get to bed within the next 30 minutes and try to get 5 hours of uninterrupted sleep. I start work at midnight.
Cheers...
