질문하기

mpkettle's profile - activity

2020-10-19 16:39:07 +0100 받은 배지  주목할 만한 질문 (source)
2020-09-16 20:31:55 +0100 으뜸 답변으로 표시됨 How do I merge two separate csv files?

How to merge 2 separate csv files updated from email

2020-03-06 15:52:57 +0100 받은 배지  유명한 질문 (source)
2018-01-05 20:41:06 +0100 받은 배지  정리의 달인
2016-02-29 21:48:12 +0100 으뜸 답변으로 표시됨 Printing all found columns on spreadsheet when using "Find All"

Is there an easier way ?

I enter a word in the find box, use 'Find All' and all examples are shown in a drop down with their cell listings. Data in other columns is not shown.

I need a print-out of all the data.

At present I hand copy the cell numbers, close the drop-down, highlight these on the spreadsheet, and 'copy'. When I use 'paste' to a free area on the spreadsheet, the found items including the data in all columns are shown, ready for printing.

Any suggestions would be appreciated that would save me time. Thanks - Maurice.

2016-02-29 21:48:01 +0100 받은 배지  유명한 질문 (source)
2016-02-27 12:16:14 +0100 으뜸 답변으로 표시됨 Is it possible to count lines of text in a cell (thus obtain a line sequence number)?

I need every line (including wordwrapped ones) to have its own sequential number. These are separate from cell numbers which only count as one digit when a cell is wordwrapped. Is this possible ?

2016-02-25 10:29:44 +0100 으뜸 답변으로 표시됨 How can I merge a csv file into a Calc file?

I have exported a CSV file from file maker pro. How can I merge this file into a calc data file in LibreOffice?

2015-09-02 22:34:51 +0100 받은 배지  인기있는 질문 (source)
2015-08-29 21:34:34 +0100 받은 배지  유명한 질문 (source)
2014-10-26 02:10:21 +0100 받은 배지  주목할 만한 질문 (source)
2014-10-18 12:45:25 +0100 질문에 답변하였습니다 Trouble using cell merge in Calc

Hi- Thanks for the comments. I have found a work around which works .

  1. Select 1st Row

  2. Slide right corner indicator to last Row - 1st Row now covers all rows.

  3. "Edit" "Undo Fill" - Uncovers all Rows but leaves them as highlighted.

  4. "Format" "Merge Cells" "Merge Cells"

  5. "Should contents of the hidden cells be moved into the first cell"

  6. "Yes"

  7. "Edit" "Delete" - all Rows except the newly merged first one.

A bit messy but it does what I want. Maurice.

2014-10-17 14:54:27 +0100 받은 배지  인기있는 질문 (source)
2014-10-17 06:20:21 +0100 질문하였습니다 Trouble using cell merge in Calc

Some months ago I asked a question about merging two or more rows of data. I thought I had the method worked out using "merge" but I am having a problem.

This is my method- Select cell 1 (row 1) Slide right corner indicator to last cell (eg row 5) (same column) 1st cell now covers all cells selected Click "Merge" "Should contents of the hidden cells be moved into the first cell?" "Yes"

Instead of all the cells appearing in cell 1, I get multiple copies of cell one only. Am I doing the impossible or is there a setting I haven't found ?

Thank-you anybody who may have an answer. Maurice.

I am using Libre Office 4.2.5.2 on a Macbook OSX 10.6.8

2014-10-16 11:11:44 +0100 받은 배지  유명한 질문 (source)
2014-09-23 02:53:35 +0100 받은 배지  자기 주도 학습자 (source)
2014-09-23 02:53:35 +0100 받은 배지  선생님 (source)
2014-09-22 10:45:42 +0100 받은 배지  주목할 만한 질문 (source)
2014-09-22 05:22:54 +0100 질문에 답변하였습니다 How can I copy an entire cell, paste/merge it into a new cell, and retain the formatting in the new cell?

"Format" "Merge cells" works perfectly.

2014-09-22 05:18:29 +0100 질문에 댓글을 달았습니다 How can I copy an entire cell, paste/merge it into a new cell, and retain the formatting in the new cell?

Hi Mr Lupp - Thanks (as usual) for your very prompt reply. By sheer determination I found and tried "Merge" late last night. It is much easier than my method and does exactly what I needed. Maurice (81.5 years young) ! Thanks again !

2014-09-21 13:36:45 +0100 받은 배지  인기있는 질문 (source)
2014-09-21 10:55:18 +0100 질문하였습니다 How can I copy an entire cell, paste/merge it into a new cell, and retain the formatting in the new cell?

Merging several rows into one row in Calc Spreadsheet.

In the past you have helped me with some unusual problems . Here is my latest !

I am using a macbook 10.6.8. I have transferred File Maker Pro data to Calc Spreadsheet using merge (.mer) files. This is an example of a problem I am having. I have set all columns to 10 font. C3 - C10 are rows all of which contain only one line of data. (This is all text) When I copy and paste C3 to C2 (via line input) the result in C2 is an exact copy of C3 (10 font). When I copy and paste C3 plus C4 (or more rows) to C2, the result is a different font, approximately 12. If I change the font size of C2 to 11, the result becomes slightly smaller than the original 10 font. I have changed the setting in "Preferences" "View" "Scaling", but this doesn't help at all. Manually changing the font in C2 may be the only solution but is there another way ? Note - The above is only a simplified example. Thanks for any help. Maurice.

2014-08-21 04:07:10 +0100 받은 배지  주목할 만한 질문 (source)
2014-08-20 11:03:26 +0100 받은 배지  주목할 만한 질문 (source)
2014-08-20 10:51:42 +0100 받은 배지  인기있는 질문 (source)
2014-08-18 04:46:46 +0100 받은 배지  조력자 (source)
2014-08-18 04:46:27 +0100 받은 배지  학자 (source)
2014-08-18 02:43:03 +0100 받은 배지  학생 (source)
2014-08-18 00:55:01 +0100 받은 배지  인기있는 질문 (source)
2014-08-17 07:43:24 +0100 질문하였습니다 Zooming line input

Using Calc in Macbook 10.6.8 Is there any way of zooming the typed entry in the line input window (the small window above the cell section)? Using 'view' 'zoom' only the main cell section is enlarged. Can the font style be changed or enlarged ? Any assistance would be appreciated. Thanks - Maurice.

2014-08-17 07:30:27 +0100 질문하였습니다 Synchronisation problem in Line Input

I am using the Calc Spreadsheet on a Macbook 10.6.8. I am typing in text (wordwrapped) in a cell often with several lines. If I use the delete key or use the left arrow in the line input window (the small window above the main cells window), its position on the type varies - either right(correct), centre or left. This seems to be a bit random. It can become difficult to delete a single letter because I am never sure which letter will be deleted. Supposing I type these numbers - 123456. Normally I would click to the right of 4 to delete it. Sometimes I have to click in the middle of 5 or on the right side of 5 to delete 4. All very confusing. I am using "courier" as I thought maybe a fixed font spacing may help. Any ideas you have would be appreciated. Thanks . Maurice.

2014-07-23 10:16:07 +0100 받은 배지  주목할 만한 질문 (source)
2014-07-17 02:57:30 +0100 받은 배지  인기있는 질문 (source)
2014-07-17 02:53:35 +0100 코멘트달린 답변 Printing all found columns on spreadsheet when using "Find All"

Thanks for the suggestion - not quite what I need. I have about 4000 rows of data. Ideally I would like to be able to use "Find all" to highlight the found rows with all the data shown (as originally typed in). I could then copy and paste for printing. The cell numbers are shown in the drop-down window but I haven't come up with a way of easily using this information to highlight the required rows. The only way at present is to scroll through the 4000 lines and use Mac Cmd key as I highlight the rows listed in the drop-down window. - Maurice.