Text in Excel "Group & Outline" not imported
Thread poster: Marketing-Lang.

Marketing-Lang.  Identity Verified
Local time: 22:50
English to German
+ ...
Apr 14, 2014

Hi Prozzers,
Any idea what to do about text in cells that are "concealed" by the "Group & Outline" feature?

A customer has sent me a large Excel file with significant amounts of text that are concealed from view until you click on the Plus symbol in the header or column. I was hoping that by displaying this text and saving the Excel file, the text would be "seen" and imported by Studio.

No such luck.

Right now I'm working around by cutting & pasting into Word. Is there an alternative?

- SDL Studio 2011
- Office 2010
- Win 7 64-bit


[Edited at 2014-04-14 15:51 GMT]


SDL Community  Identity Verified
United Kingdom
Local time: 22:50
If I understand you correctly... Apr 14, 2014

... then you have two ways at least.

  1. Click in the smallest number in the file in Excel, the one in the outline column on the left. This will expand everything so it’s not hidden
  2. Check the Hidden content (columns, rows, sheets) under Common in the filetype options in Studio

The Groups & Outlines feature is just a way of hiding text automatically based on totalling usually. And Studio hides hidden content by default.




Marketing-Lang.  Identity Verified
Local time: 22:50
English to German
+ ...
Thanks Paul Apr 15, 2014

Fabulous! Step 2 was what I was missing.
Thanks again!


To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Text in Excel "Group & Outline" not imported

Advanced search

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 »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »

  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search