When trados studio translate bilingual excel, trados can not deal with the date in the excel

Question

Hi 
 When I try to use trados studio to translate bilingual excel, There is the date in the excel cell 
 
 But when I try to add the bilingual excel into trados studio after I set the file type only for bilingual excel. Trados will demonstrate the date as numbers, which is not correct, and I need the date can still be shown here. 
 Beside, before I add the bilingual excel to trados, I have set two column of excel as text mode.

Paul · Answer

jack zhong 
 I have no idea why you have this problem. I created a quick test file and used General (default) for the cells: 
 
 That opens in Trados Studio like this: 
 
 I attached my test file for you to test and see how this behaves for you: 
 dates.zip

Paul · Answer

jack zhong 
 Perhaps you could make two copies of the Word file. Then hide the source in one and the target in the other, then align them?

Paul · Answer

jack zhong jack zhong said: It seems that we might need to add the capability or function of trados studio to to this. I don't think this is something we need to make part of the core product, but I'm not the product manager so if you still think so feel free to create an idea for this in the ideas site. I think you could solve this problem, based on everything you've shared so far (and ignoring anything that might be possible to improve the alignment since what you have shown doesn't mean it's not possible to get a better alignment than you have), by using a powershell script to move the rows in the table as they are already 1:1 into an XLIFF file. So I created the following: # Ask for the Word document path $docFullPath = Read-Host "Please enter the full path to the DOCX file" if (-Not (Test-Path -Path $docFullPath)) { Write-Host "The file path you entered does not exist. Please check the path and try again." exit } # Prompt for source and target language codes $sourceLangCode = Read-Host "Enter the source language code (e.g., 'zh-TW')" $targetLangCode = Read-Host "Enter the target language code (e.g., 'pt-PT')" # Create the XLIFF file name by changing the DOCX extension to .xliff $xliffFile = [IO.Path]::ChangeExtension($docFullPath, ".xliff") # Create a new invisible Word Application object $wordApp = New-Object -ComObject Word.Application $wordApp.Visible = $false function Escape-Xml ($string) { $string -replace '&', '&' -replace '<', '<' -replace '>', '>' -replace '"', '"' -replace "'", ''' } try { # Open the Word document $document = $wordApp.Documents.Open($docFullPath) $table = $document.Tables.Item(1) # Start building the XLIFF content $xliffContent = @" "@ # Iterate over each row in the table, skipping the header row for ($i = 2; $i -le $table.Rows.Count; $i++) { $sourceText = Escape-Xml ($table.Cell($i, 1).Range.Text -replace "`r`n", "" -replace "`a", "").Trim() $targetText = Escape-Xml ($table.Cell($i, 2).Range.Text -replace "`r`n", "" -replace "`a", "").Trim() $unitId = "u" + $i $xliffContent += "`r`n `r`n $sourceText`r`n $targetText`r`n `r`n`r`n" } # Close the XLIFF content $xliffContent += @" "@ # Save the XLIFF content to the file $xliffContent | Set-Content -Path $xliffFile -Encoding UTF8 Write-Host "XLIFF 2.0 file has been created at $xliffFile" } catch { Write-Host "An error occurred: $_" } finally { # Close the Word document and quit the application if ($document) { $document.Close($false) } $wordApp.Quit() # Clean up COM objects [System.Runtime.Interopservices.Marshal]::ReleaseComObject($document) | Out-Null [System.Runtime.Interopservices.Marshal]::ReleaseComObject($wordApp) | Out-Null [System.GC]::Collect() [System.GC]::WaitForPendingFinalizers() } And this table: Which seems to do the trick like this:

Trados Studio > 2. Trados Studio

When trados studio translate bilingual excel, trados can not deal with the date in the excel