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

Marketing-Lang.  Identity Verified
Germany
Local time: 11:46
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

Thanks,
-Mike-



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


Direct link Reply with quote
 

SDL Community  Identity Verified
United Kingdom
Local time: 11:46
English
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.

Regards

Paul


Direct link Reply with quote
 

Marketing-Lang.  Identity Verified
Germany
Local time: 11:46
English to German
+ ...
TOPIC STARTER
Thanks Paul Apr 15, 2014

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


Direct link Reply with quote
 


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







PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
SDL Trados Studio 2017 only €415 / $495
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €415 / $495 / £325 / ¥60,000 You will also receive FREE access to our getting started eLearning program!

More info »



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