sketchucation logo sketchucation
    • Login
    ⚠️ Attention | Having issues with Sketchucation Tools 5? Report Here

    Tables in LO 2017

    Scheduled Pinned Locked Moved LayOut Bug Reporting
    layout
    13 Posts 5 Posters 15.9k Views 5 Watching
    Loading More Posts
    • 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.
    • ntxdaveN Offline
      ntxdave
      last edited by

      @brettsichellodesign said:

      Any advice on this?

      It worked for me.

      1 Reply Last reply Reply Quote 0
      • M Offline
        marcdurant
        last edited by

        Any chance you could share that excel file with the LayOut team for debugging purposes? There may be something specific about your file that's breaking our importer, and we'd love to check it out.

        Thanks,
        Marc

        1 Reply Last reply Reply Quote 0
        • N Offline
          nickchun
          last edited by

          Marc, I have had the same issue trialling Layout. I have downloaded the Make version for now. I am trying to insert a table from an Excel 2007 Workbook that has 25 sheets. If you want a copy of the workbook I can PM it to you.

          Nick

          1 Reply Last reply Reply Quote 0
          • M Offline
            marcdurant
            last edited by

            Yes, I would appreciate any and all files that are causing issues.

            1 Reply Last reply Reply Quote 0
            • brettsichellodesignB Offline
              brettsichellodesign
              last edited by

              Unfortunately I am unable to share this excel file. However I can confirm that is a 6218KB file with many workbooks most of which are protected. I did try un-protecting them but still have the same issue.

              I have got round this problem by referencing the cells I needed into a new excel file with just 1 workbook and referencing that into LO. Just means I have to have another file.

              1 Reply Last reply Reply Quote 0
              • jujuJ Offline
                juju
                last edited by

                This is probably a noob Excel question, but how do you manage to reference cells in a separate protected Excel file? How do you enter the password to the referenced file from the referring file?

                Save the Earth, it's the only planet with chocolate.

                1 Reply Last reply Reply Quote 0
                • brettsichellodesignB Offline
                  brettsichellodesign
                  last edited by

                  Please see video below:

                  1 Reply Last reply Reply Quote 0
                  • brettsichellodesignB Offline
                    brettsichellodesign
                    last edited by

                    @marcdurant said:

                    Yes, I would appreciate any and all files that are causing issues.

                    Marc I sent you a PM

                    1 Reply Last reply Reply Quote 0
                    • jujuJ Offline
                      juju
                      last edited by

                      @brettsichellodesign said:

                      Please see video below:

                      thanks for the vid, that is how you reference cells between documents

                      I'm interested to know if it still works (automatically) if you have the source Excel file password protected and, if so, how you manage that the target file opens/reads the source (password protected) file?

                      Save the Earth, it's the only planet with chocolate.

                      1 Reply Last reply Reply Quote 0
                      • M Offline
                        marcdurant
                        last edited by

                        Among other minutia, looks like the library we're using to import .XLS files doesn't properly handle some aspects of locked cells. Thanks for your help identifying the issue, and keep an eye out for maintenance releases.

                        -m

                        1 Reply Last reply Reply Quote 0
                        • jujuJ Offline
                          juju
                          last edited by

                          @marcdurant said:

                          Among other minutia, looks like the library we're using to import .XLS files doesn't properly handle some aspects of locked cells. Thanks for your help identifying the issue, and keep an eye out for maintenance releases.

                          -m

                          Hi Marc,

                          When will we be able to reference a password locked Excel file into Layout? I tried again after the SU2017proM2 release but no luck...

                          Save the Earth, it's the only planet with chocolate.

                          1 Reply Last reply Reply Quote 0
                          • 1 / 1
                          • First post
                            Last post
                          Buy SketchPlus
                          Buy SUbD
                          Buy WrapR
                          Buy eBook
                          Buy Modelur
                          Buy Vertex Tools
                          Buy SketchCuisine
                          Buy FormFonts

                          Advertisement