+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, SIMS exported Marksheets (Formatted) in Excel in Technical; Why is there so much inflexibility with marksheets exported from SIMS? In particular, in completing the comments, staff are struggling ...
  1. #1

    Join Date
    May 2011
    Location
    London
    Posts
    92
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS exported Marksheets (Formatted) in Excel

    Why is there so much inflexibility with marksheets exported from SIMS?

    In particular, in completing the comments, staff are struggling as the default cell size is too small, and they cant increase the height of the rows in Excel.

    Does anyone know a workaround (apart from exporting unformatted obviously)

    Cheers,

    Tom

  2. #2

    Join Date
    May 2011
    Location
    London
    Posts
    92
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I've discovered I can unprotect the sheets, adjust the cell sizes and reprotect them.

    Although I have to do this for every marksheet, creating a macro to do it saves time so it can be done in minutes.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,888
    Thank Post
    750
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Do it in unformatted then get them to copy paste it into formatted for import. Some even just type in excel then copy in when done.



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 30
    Last Post: 14th September 2011, 11:05 PM
  2. [SIMS] SIMS - Read only Columns in Marksheet Templates
    By emlewi in forum MIS Systems
    Replies: 6
    Last Post: 4th July 2011, 04:14 PM
  3. [SIMS] Batch export marksheets with summary rows
    By LosOjos in forum MIS Systems
    Replies: 15
    Last Post: 4th February 2011, 08:51 PM
  4. [SIMS] SIMS via TS RemoteApp in server 2008R2
    By mrbios in forum MIS Systems
    Replies: 24
    Last Post: 3rd December 2010, 04:47 PM
  5. Custom date format in SIMS Report
    By pod in forum MIS Systems
    Replies: 6
    Last Post: 2nd November 2009, 01:37 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •