Skip to content
  • Categories
  • Recent
  • Popular
Collapse
Brand Logo
  1. Home
  2. Categories
  3. Technical subjects
  4. Excel editing and comparison

Excel editing and comparison

Scheduled Pinned Locked Moved Technical subjects
4 Posts 3 Posters 92 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • aclassenA Offline
    aclassenA Offline
    aclassen
    Utilisateur GoFAST Entreprise
    wrote on last edited by
    #1

    We are just testing things without having had training or an introduction, so my issue may be a result of inexperience.
    Anyway:
    #mmoreira created an Excel document and put it into our organisational space.
    I was able to edit it with OnlyOffice without a problem.

    • The preview of the Excel both before and after the editing would not display the real contents of the table on the first sheet (what we had edited). I tried to refresh the preview, which did not change anything
    • While I can see two versions of the document in the history, the diff results in "no differences found"
      Capture.PNG
    1 Reply Last reply
    1
    • cpotterC Offline
      cpotterC Offline
      cpotter
      ADMIN
      wrote on last edited by
      #2

      Please find below our answers:

      The preview of the Excel both before and after the editing would not display the real contents of the table on the first sheet (what we had edited). I tried to refresh the preview, which did not change anything

      Onlyoffice has an ongoing bug where it loses "scale to fit" informations please see https://github.com/ONLYOFFICE/DocumentServer/issues/510 (should be fixed in Onlyoffice 5.5).

      While I can see two versions of the document in the history, the diff results in "no differences found"

      We will investigating this one, not sure that we should autorize excel comparison

      Best,

      Christopher Potter
      Fondateur & Président / Founder & President,
      CEO-Vision S.A.S

      1 Reply Last reply
      1
      • sjeandrozS Offline
        sjeandrozS Offline
        sjeandroz
        DEV MODERATOR
        wrote on last edited by
        #3

        Hello,

        When we analyze your document, we can see the print area is set to only the table header ( as we can see with the dotted line on the following screenshot), and the problem is that the PDF preview is based on this print area ( and the compare tool use the PDF preview ) , so that's why the compare tool doesn't find any difference, because on the PDF previews, there is no difference, due to print area

        26132721-012a-4d1a-a0df-96d3625d182d-image.png

        If you set the print area to the full table, the PDF preview will be ok and the diff tool should be able to do its job

        Best regards,

        JEANDROZ Sylvain - CEO-Vision IT
        sylvain.jeandroz@ceo-vision.com
        Alliance - Porte A, 178 rue des Frères Lumière 74160 Archamps Technopole, FRANCE
        +33 (0) 811 693 111 et depuis l'étranger +33 (0) 972 236 057
        https://www.ceo-vision.com

        1 Reply Last reply
        2
        • aclassenA Offline
          aclassenA Offline
          aclassen
          Utilisateur GoFAST Entreprise
          wrote on last edited by
          #4

          argh, I hadn't checked that. You are certainly right, thank you!

          1 Reply Last reply
          1
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Search
          • First post
            Last post
          0
          • Categories
          • Recent
          • Popular
          • Search