Ask Your Question
1

How do you get libreoffice to fill in these boxes automatically? [closed]

asked 2013-03-19 06:38:18 +0100

user9733 gravatar image

updated 2013-06-16 18:59:53 +0100

manj_k gravatar image

Noob here.

How do you get libreoffice to fill in these boxes automatically?

The "points" box is "1" and feedback "Correct!" and "Incorrect".

Links to the file.

http://speedy.sh/jMa8E/microsoft-office-excel-quiz-template-2.xlsx

http://www.mediafire.com/view/?zbsayacod1jeo5v

http://depositfiles.com/files/srzvxhgwj

Image of what I'm talking about.

image description

I have 100 boxes like that.

I need to paste that same information in all the boxes.

Also I need 120 questions instead of 100.

I never used microsoft or open office before.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-27 03:30:41.835933

3 Answers

Sort by » oldest newest most voted
1

answered 2013-03-20 02:24:34 +0100

user9733 gravatar image

updated 2013-03-20 02:29:24 +0100

I asked how to mass paste in xlsx without messing it up.

I never used office apps before but I figured it out.

  1. copy paste everything into a new document
  2. "delete contents" formatting, etc.
  3. edit without format crap in the way
  4. copy paste text and numbers into original document

http://www.mediafire.com/?kk8bqb2p6hh14nt

http://depositfiles.com/files/mvs6mb69e

Some things I didn't figure out;

  1. count every 20 rows from 100 to 120
  2. select every 20 rows and change row height
  3. make the cell boarders less thick after saving

So I just did it manually.

I know I don't need advice anymore I just wanted to tell everyone.

edit flag offensive delete link more

Comments

@user9733 -- Thanks for the update.

qubit gravatar imagequbit ( 2013-03-20 04:48:13 +0100 )edit
0

answered 2013-03-19 11:21:41 +0100

qubit gravatar image

Hi @user9733,

Sounds like you've got quite a task here.

I have 100 boxes like that.

I need to paste that same information in all the boxes.

Also I need 120 questions instead of 100.

I never used microsoft or open office before.

One possibility would be to write a macro, but you mention that you have no experience with Microsoft, OpenOffice, or (presumably) LibreOffice, so that might be a bit too complicated.

Given that you have no experience with the office suite, I suggest that you start here:

Try reading the LO 4.0 "Getting Started" Guide. That will provide a good first step towards understanding LibreOffice. After that, we can work on providing some info about macros.

edit flag offensive delete link more
0

answered 2013-03-20 02:21:52 +0100

user9733 gravatar image

Hi @qubit

A macro was suggested but I can not into programming.

Yes, I never used libre or any office either.

Thanks for the reading material.

Thank you for responding.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-03-19 06:38:18 +0100

Seen: 280 times

Last updated: Mar 20 '13