Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2022, 09:56 AM
dannyd dannyd is offline Copying two similar listed reference tables in the same document Windows 10 Copying two similar listed reference tables in the same document Office 2021
Novice
Copying two similar listed reference tables in the same document
 
Join Date: Jan 2022
Posts: 3
dannyd is on a distinguished road
Default Copying two similar listed reference tables in the same document

Hello all! I have a seemingly easy, but actually difficult question that I've been breaking my head on for several days now and I can't seem to find an answer to.



I have a German document with a table with numbered references, such as this:

+------+-----------------------+------+
| Ref. | Document | Year |
+------+-----------------------+------+
| [1] | Standards EU Metal | 2020 |
+------+-----------------------+------+
| [2] | Standards EU Concrete | 2018 |
+------+-----------------------+------+
| [3] | Standards US Concrete | 2016 |
+------+-----------------------+------+

In the text, I cross-reference to these Ref numbers. For example "The yield stress for the concrete is not high enough, as seen in [3]". This [3] is then a hyperlink back to the table.

Everything all good up untill now. Then I went to translate the document to English using a translation service. Everything works and the cross references still work.

I then need to paste the English document behind the German document, but then the English links will refer to the German table of references, instead of referring to the English table. My guess is that this occurs since the actual REF NUMBER is still the same (?).

How can I make sure that the [2] in the English part of the document refers to the English table and not the German one?

So far, I've tried a lot of options with creating new multi-level lists, resetting the numbering etc, and although they do reset the numbering of the English part such that it is indeed [1],[2],[3] again instead of a continuation of the German one ([4],[5],[6]), the references still refer to the German part.

Many thanks!
Reply With Quote
  #2  
Old 01-24-2022, 07:19 PM
Guessed's Avatar
Guessed Guessed is offline Copying two similar listed reference tables in the same document Windows 10 Copying two similar listed reference tables in the same document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I would put both English and German paragraphs into the same cell and show/hide these via styles to get the language specific content to display while hiding the other language(s).

In your example, only the heading row and middle column requires a different language entry.

Then the references are only put in once
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 01-25-2022, 07:48 AM
kilroyscarnival kilroyscarnival is offline Copying two similar listed reference tables in the same document Windows 10 Copying two similar listed reference tables in the same document Office 2019
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by dannyd View Post
Hello all! I have a seemingly easy, but actually difficult question that I've been breaking my head on for several days now and I can't seem to find an answer to.

I have a German document with a table with numbered references, such as this:

+------+-----------------------+------+
| Ref. | Document | Year |
+------+-----------------------+------+
| [1] | Standards EU Metal | 2020 |
+------+-----------------------+------+
| [2] | Standards EU Concrete | 2018 |
+------+-----------------------+------+
| [3] | Standards US Concrete | 2016 |
+------+-----------------------+------+

In the text, I cross-reference to these Ref numbers. For example "The yield stress for the concrete is not high enough, as seen in [3]". This [3] is then a hyperlink back to the table.

Everything all good up untill now. Then I went to translate the document to English using a translation service. Everything works and the cross references still work.

I then need to paste the English document behind the German document, but then the English links will refer to the German table of references, instead of referring to the English table. My guess is that this occurs since the actual REF NUMBER is still the same (?).

How can I make sure that the [2] in the English part of the document refers to the English table and not the German one?

So far, I've tried a lot of options with creating new multi-level lists, resetting the numbering etc, and although they do reset the numbering of the English part such that it is indeed [1],[2],[3] again instead of a continuation of the German one ([4],[5],[6]), the references still refer to the German part.

Many thanks!
Hello,

I think that you might look at your Bookmarks (Insert/Bookmark, view the list) and make sure they have different labels (Bookmark Names) in the German and English sections. If your bookmarks/links were words, you could simply label the German one "Dritter" and the English one "Third". But since you're using numbers, you may have to make the second set of numbers 01, 02, 03 given that they are not text labels but numeric. Or switch to a, b, c?

Ann
Reply With Quote
  #4  
Old 01-27-2022, 06:07 AM
dannyd dannyd is offline Copying two similar listed reference tables in the same document Windows 10 Copying two similar listed reference tables in the same document Office 2021
Novice
Copying two similar listed reference tables in the same document
 
Join Date: Jan 2022
Posts: 3
dannyd is on a distinguished road
Default

Quote:
Originally Posted by kilroyscarnival View Post
Hello,

I think that you might look at your Bookmarks (Insert/Bookmark, view the list) and make sure they have different labels (Bookmark Names) in the German and English sections. If your bookmarks/links were words, you could simply label the German one "Dritter" and the English one "Third". But since you're using numbers, you may have to make the second set of numbers 01, 02, 03 given that they are not text labels but numeric. Or switch to a, b, c?

Ann
Hi Ann, unfortunately the references are not inserted as bookmarks, there are no bookmarks in the document.

The [3] in the text is a cross-reference to a Reference-type: Numbered item.
Reply With Quote
  #5  
Old 01-27-2022, 06:09 AM
dannyd dannyd is offline Copying two similar listed reference tables in the same document Windows 10 Copying two similar listed reference tables in the same document Office 2021
Novice
Copying two similar listed reference tables in the same document
 
Join Date: Jan 2022
Posts: 3
dannyd is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
I would put both English and German paragraphs into the same cell and show/hide these via styles to get the language specific content to display while hiding the other language(s).

In your example, only the heading row and middle column requires a different language entry.

Then the references are only put in once
I am not sure what you mean by "putting both the English and German paragraphs into the same cell".

Do you mean putting the text for [3] for both English and German in the same cell in the table?
Reply With Quote
  #6  
Old 01-27-2022, 10:00 AM
kilroyscarnival kilroyscarnival is offline Copying two similar listed reference tables in the same document Windows 10 Copying two similar listed reference tables in the same document Office 2019
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by dannyd View Post
Hi Ann, unfortunately the references are not inserted as bookmarks, there are no bookmarks in the document.

The [3] in the text is a cross-reference to a Reference-type: Numbered item.
Oh, I think I see what you mean -- they are numbered references. I think my suggestion still applies, though, that they each need to have a unique number or descriptor. Perhaps A1 A2 A3 vs B1 B2 B3?

Or, if the references in the two different translations of the document do refer to the same text or resource, just one written in German and one in English, perhaps you could have just the one table giving both the German and English references side by side, which is what I think Guessed was suggesting. Forgive me, I'm using Google Translate for the German words just to create an example:

Ref Document (EN) Dokument (DE) Year/Jahr
1 Standards EU Metal Normen EU Metall 2020
2 Standards EU Concrete Normen EU Beton 2018
3 Standards US Concrete Normen US Beton 2016

If they are in fact different references, and not just translated names, then I would suggest you number the English ones 4, 5, 6.
Reply With Quote
  #7  
Old 01-27-2022, 02:55 PM
Guessed's Avatar
Guessed Guessed is offline Copying two similar listed reference tables in the same document Windows 10 Copying two similar listed reference tables in the same document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Cross references of any kind actually do use hidden bookmarks which can only occur once in a document. But the basic setup for having language-specific content is not that complicated. Attached is a file showing how I set up a sample with content controls tagged with a language-specific code along with a macro that allows the user to select which language should be shown.
Code:
Sub LocaliseMe()
  Dim aCC As ContentControl, sLang As String
  sLang = InputBox("What language should be displayed? Your choices are: EN, DE, All", _
          "Choose Language Code", "All")
  
  For Each aCC In ActiveDocument.ContentControls
    Select Case sLang
      Case aCC.Tag
        aCC.Range.Font.Hidden = False
      Case "All"
        aCC.Range.Font.Hidden = False
      Case Else
        aCC.Range.Font.Hidden = True
    End Select
  Next aCC
  
  'set options to make ensure hidden text is not displayed on screen
  ActiveWindow.View.ShowAll = False
  ActiveWindow.View.ShowHiddenText = False
End Sub
Attached Files
File Type: docm SingleSource_LanguageExample.docm (33.6 KB, 5 views)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #8  
Old 01-28-2022, 12:26 PM
Charles Kenyon Charles Kenyon is offline Copying two similar listed reference tables in the same document Windows 10 Copying two similar listed reference tables in the same document Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Off-topic:
Just a note on language-specific formatting. I recommend using a character style to identify/mark text in a different language from that used in the main text. This is not difficult to set up and is discussed toward the bottom of this article:
Proofing Language Keeps Changing - Solutions - How can I keep my proofing language from changing?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to redact words listed in one document from the current document AlanofBayCourt Word VBA 0 10-31-2019 03:00 AM
Revise tables in a word document based on a reference table in excel modiria50989 Word VBA 1 08-29-2017 03:07 PM
Copying two similar listed reference tables in the same document Copying Multiple tables from excel into a single word document dineshtgs Word Tables 1 04-07-2011 01:27 AM
Copying tables to MS Word 123 Word Tables 1 03-02-2011 11:25 AM
Copying format between tables. daeron Word Tables 0 06-11-2010 12:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft