| Pages in topic: [1 2] > | Red text in xlsx and ignoring html codes Thread poster: Ali Bayraktar
|
|---|
I have 2 questions.
How to ignore red text in an xlsx file in cafetran?
Is there any filter, option or menu for that?
My second question is about ignoring hml codes.
Cafetran automatically reads some of html codes and transforms the texts which nhave html codes automatically.
But I dont want cafetran to do this.
Is there any solution for ignoring all html codes in a text?
Thanks for helps in advance,
Regards,
M. Al... See more I have 2 questions.
How to ignore red text in an xlsx file in cafetran?
Is there any filter, option or menu for that?
My second question is about ignoring hml codes.
Cafetran automatically reads some of html codes and transforms the texts which nhave html codes automatically.
But I dont want cafetran to do this.
Is there any solution for ignoring all html codes in a text?
Thanks for helps in advance,
Regards,
M. Ali ▲ Collapse
| | | | | Clipboard workflow for selected text | Jul 2, 2014 |
Hello Ali,
CafeTran does not ignore either a colored text and a html format as it imports the text from Excel cells for translation. If you wish to translate only selected chunks of text in Excel cells, please consider an alternative Clipboard workflow designed for such scenarios (http://cafetran.wikidot.com/using-the-clipboard-workflow).
Cheers,
... See more Hello Ali,
CafeTran does not ignore either a colored text and a html format as it imports the text from Excel cells for translation. If you wish to translate only selected chunks of text in Excel cells, please consider an alternative Clipboard workflow designed for such scenarios (http://cafetran.wikidot.com/using-the-clipboard-workflow).
Cheers,
Igor ▲ Collapse
| | | |
Ali Bayraktar wrote:
How to ignore red text in an xlsx file in cafetran?
Delete both, using Find/Replace, as described here:
Open the spreadsheet.
Check Track Changes.
Delete the cells you don't want to translate
Save.
Translate in CafeTran
Export.
Open in Excel.
Reject All Changes.
Cheers,
Hans
| | | |
@Igor and @Arkadia,
Thanks for informaton.
Regards,
M. Ali
| | |
|
|
|
Selcuk Akyuz 
Türkiye
Local time: 00:49
English to Turkish
+ ...
What if the file already has tracked changes by other users? I think in that case only the changes made by the last user (translator) should be rejected.
Finding & deleting all red text may be difficult in huge files. ASAP Utilities helps here: Select > Select cells based on content, formatting and more...
But it will be time consuming if different shades of red were used.
ASAP Utilities is great but I still prefer built-in filter options in CAT tools (e.g... See more What if the file already has tracked changes by other users? I think in that case only the changes made by the last user (translator) should be rejected.
Finding & deleting all red text may be difficult in huge files. ASAP Utilities helps here: Select > Select cells based on content, formatting and more...
But it will be time consuming if different shades of red were used.
ASAP Utilities is great but I still prefer built-in filter options in CAT tools (e.g. memoQ, Deja Vu X).
Selcuk ▲ Collapse
| | | | | Too many ifs? | Jul 3, 2014 |
Selcuk Akyuz wrote:
...but I still prefer built-in filter options in CAT tools (Deja Vu X).
But as Igor himself confirmed above, CafeTran doesn't provide this particular filter. And CT doesn't have to, because the procedure I mentioned above will do the trick nicely in almost all cases. And it works for all MS Office files, not only Excel files. And it works for all things you want to hide, including highlighted text, the part another translator will take care of, you name it.
Now if the file is huge, if the file already has tracked changes, if the file shows Fifty Shades of Red, and if you don't want to use other tools, you can decline the job. Not a bad idea to decline Excel files as a rule anyway.
Cheers,
Hans
| | | | 2nl (X)
Netherlands
Local time: 23:49
| Further development of the XLSX filter | Jul 3, 2014 |
Selcuk Akyuz wrote:
ASAP Utilities is great but I still prefer built-in filter options in CAT tools (e.g. memoQ, Deja Vu X).
I would also welcome a new XLSX filter.
What other wishes would you have, regarding CafeTran, Selcuk?
| | | |
Selcuk Akyuz wrote:
ASAP Utilities is great but I still prefer built-in filter options in CAT tools (e.g. memoQ, Deja Vu X).
Dejavu X3 interprets some xml and html codes.
I dont know how to prevent Dejavu from doing this.
Cafetran also interprets xml and html codes itself.
Not all codes but it is enough to ruin the whole coded text.
| | |
|
|
|
Selcuk Akyuz
Türkiye
Local time: 00:49
English to Turkish
+ ...
| new features? | Jul 4, 2014 |
2nl wrote:
Selcuk Akyuz wrote:
ASAP Utilities is great but I still prefer built-in filter options in CAT tools (e.g. memoQ, Deja Vu X).
I would also welcome a new XLSX filter.
What other wishes would you have, regarding CafeTran, Selcuk?
No idea, my version is almost 6 months old and my license expired. I will upgrade but first buy a new computer with 16GB RAM. CT does not work well with limited RAM.
An up-to-date and official help file will be great but there is only one Igor.
Ali Bayraktar wrote:
Dejavu X3 interprets some xml and html codes.
I dont know how to prevent Dejavu from doing this.
Cafetran also interprets xml and html codes itself.
Not all codes but it is enough to ruin the whole coded text.
CafeTran gurus and the developer himself already posted here, perhaps it is better to send Igor a test file.
For DVX3 this video may help: http://www.youtube.com/watch?v=C2PUtObxsp8
Selcuk
| | | |
Selcuk Akyuz wrote:
CT does not work well with limited RAM.
You may want to try again, Selçuk. The trial version will do. Igor "improved memory handling," and now a 2GB DGT TMX file uses 2GB, rather than the 6GB it used to be.
Cheers,
Hans
| | | | | Solution: Given by Igor | Jul 4, 2014 |
Solution in my case given by Igor was:
- While creating project to select Tagged MS Excel (*xlsx) as file type.
This solution coded xlsx files works almost perfect. I can say 99%
When selecting this file type Cafetran shows only texts between the codes.
How ever final file should be checked against any missing parts in codes.
Because some of codes can be interpreted or deleted (in my case Cafetran deleted only 1 html code and I found it by compa... See more Solution in my case given by Igor was:
- While creating project to select Tagged MS Excel (*xlsx) as file type.
This solution coded xlsx files works almost perfect. I can say 99%
When selecting this file type Cafetran shows only texts between the codes.
How ever final file should be checked against any missing parts in codes.
Because some of codes can be interpreted or deleted (in my case Cafetran deleted only 1 html code and I found it by comparing 2 files)
I can say for xml, html coded excels "Tagged MS Excel" file filter works perfectly.
My case is solved 99%.
Thanks Igor for your helps. ▲ Collapse
| | | |
Meta Arkadia wrote:
Ali Bayraktar wrote:
How to ignore red text in an xlsx file in cafetran?
Delete both, using Find/Replace, as described here:
Open the spreadsheet.
Check Track Changes.
Delete the cells you don't want to translate
Save.
Translate in CafeTran
Export.
Open in Excel.
Reject All Changes.
Cheers,
Hans
In excel files with colored texts using find and replace function changes the color of whole cell.
For example if we have a text in blue color, and there is only one word (for example "apple") in red color,
finding and replacing that "apple" will change all text together.
All colors gone and I am getting only black colored text.
Do you have any suggestion for preventing this?
| | |
|
|
|
| Coloured nothingness? | Jul 4, 2014 |
Ali Bayraktar wrote:In excel files with colored texts using find and replace function changes the color of whole cell.
I don't think you can possibly know, Ali. The idea was to delete cells with red text, as per the original question. So replace with nothingness, and nothingness is colourless, as far as I know.
Cheers,
Hans
| | | |
Meta Arkadia wrote:
Ali Bayraktar wrote:In excel files with colored texts using find and replace function changes the color of whole cell.
I don't think you can possibly know, Ali. The idea was to delete cells with red text, as per the original question. So replace with nothingness, and nothingness is colourless, as far as I know.
Cheers,
Hans
Nothingness or not, if you change a part of text in a cell by using find and replace function, the rest part's color also changes.
You may try it yourself.
Take colored text and try to delete part of this text in a cell, and you will see that by deleting you also change the rest part's color.
Regards,
M. Ali
| | | |
Ali Bayraktar wrote:
if you change a part of text in a cell by using find and replace function, the rest part's color also changes.
Yes. You change, I delete.
And thanks for all the fish.
Cheers,
Hans
| | | | | Pages in topic: [1 2] > | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Red text in xlsx and ignoring html codes | Trados Studio 2022 Freelance |
|---|
The leading translation software used by over 270,000 translators.
Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop
and cloud solution, empowering you to work in the most efficient and cost-effective way.
More info » |
| | Protemos translation business management system |
|---|
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
