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.
    • 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