+ Reply to Thread
Results 1 to 6 of 6

Thread: Filters in MS Excel

 
  1. #1
    Moderator
    Join Date
    Jul 2007
    Posts
    1,403
    Rep Power
    1246

    Default Filters in MS Excel

    Hi Memsource people!

    I´m working on a huge excel file, with many tabs and each tab having many filters.
    I´ll be doing some tests before confirming wordcount... but I thought it would be a good idea to double check here with you as well.

    When you have the filters applied, I guess Memsource does not include that hidden text, right? Let´s say Memsource works same way as with hidden tabs, rows, etc, correct?

    So, if I wanted to make sure all text to be translated, I should go ahead and uncheck all filters...




  2. #2
    Moderator
    Join Date
    Mar 2012
    Age
    37
    Posts
    989
    Rep Power
    1010

    Default Re: Filters in MS Excel

    If you want to translate all you don't need unhide/unfilter all. you can check "Import hidden columns, hidden rows, and hidden sheets" option under "MS Excel".

  3. #3
    Senior Member
    Join Date
    May 2006
    Posts
    968
    Rep Power
    100

    Default Re: Filters in MS Excel

    I know that you can hide either columns or rows and leave that box Salvadorm mentions unchecked if you want text not display in the MemXliff file (and, therefore, not accounted for). However, I'm not sure what happens if you have an Excel spreadsheet with filters. I'm afraid MemSource may turn those filters off when converting the file into MemXliff format...Have you tried doing so? Did it work?

  4. #4
    Moderator
    Join Date
    Jul 2007
    Posts
    1,403
    Rep Power
    1246

    Default Re: Filters in MS Excel

    Hi gentlemen
    No, I haven´t tried that.
    So, Salvador, what you are saying is that keeping the filters applied but checking for the hide rows, etc does the same thing as if I unchecked all filters?
    Im not sure whether that option for hide cells, rows, tabs applies for filters, because they are not being mentioned in the given options...

  5. #5
    Forum User
    Join Date
    Aug 2015
    Posts
    78
    Rep Power
    122

    Default Re: Filters in MS Excel

    Well, I happened to work with an Excel file with filters. I did not unfilter anything, but when I uploaded it to Memsource, I got a full word count (including filtered/unfiltered cells). When you hide/unhide columns and rows the WC changes as usual.

  6. #6
    Moderator
    Join Date
    Jul 2007
    Posts
    1,403
    Rep Power
    1246

    Default Re: Filters in MS Excel

    mmmm, aha...
    So, Daniel, you mean that Memsource counted all full wordcount even though you had some filters applied? So, word count is independent of filters then? and what should we do if we need to exclude part of that text in the filters?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MS Excel and RTL languages
    By gentle in forum Spanish Desktop Publishing
    Replies: 3
    Last Post: 12-29-2016, 04:51 PM
  2. Proyecto en Excel
    By Maximiliano in forum Spanish Language Topics
    Replies: 2
    Last Post: 11-28-2016, 09:23 AM
  3. Excel - Como cambiar los separadores de decimales y de miles en Excel
    By RodrigoDG in forum Spanish Desktop Publishing
    Replies: 2
    Last Post: 06-05-2014, 07:27 PM
  4. TwinExternal en MS Excel
    By mariaq in forum Other CAT Tools
    Replies: 9
    Last Post: 09-13-2010, 02:21 PM
  5. Excel translation
    By J05EPHL in forum General Spanish to English Translation
    Replies: 2
    Last Post: 01-16-2010, 02:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •