Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Merging several rows into one row in Calc Spreadsheet.

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.

click to hide/show revision 2
No.2 Revision

Merging several rows into one row in Calc Spreadsheet.When I copy/paste entire cells, why is the formatting (font size) not preserved?

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.

click to hide/show revision 3
No.3 Revision

When I copy/paste How can I copy an entire cells, why is cell, paste/merge it into a new cell, and retain the formatting (font size) not preserved?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.

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.