+ 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
    1157

    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
    29
    Posts
    982
    Rep Power
    920

    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
    806
    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
    1157

    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
    33

    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
    1157

    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)

Posting Permissions

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