Re: [RBASE-L] - Oddity when exporting a report to Excel
Kayza, In addition to properly aligned objects, I also suggest to use Monospace fonts. Monospace fonts being the same size and spacing, unlike variable width fonts and were and are arguably, easier to deal with since everything is uniformly spaced. Examples of monospaced fonts include Courier, Courier New, Lucida Console, Monaco, and Consolas. Hope that helps! Very Best R:egards, Razzak At 01:21 PM 5/22/2017, Kayza Kleinman wrote: I have a report that has one line per row of data. Nothing special or esoteric about it. I need to print this report to Excel, which has worked just fine till I made an edit to the report. I added a field to the report. Now, every few lines (and the number of lines is NOT consistent!) the last field shows up on the row below. What should be happening is: Item1Item2Item3Item4 Item1a Item2a Item3a Item4a What is happening every few lines is: Item1Item2Item3 Item4 Item1a Item2a Item3a Item4a This is creating some major problem. R:base v 9.5 Thanks for any insight. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Oddity when exporting a report to Excel
Yes, make sure you check the horizontal alignment, because if it's off a fraction of a pixel, it might throw it on a new line. Also make sure you have plenty of white space around your new field Karen -Original Message- From: Tony IJntema <t.ijnt...@cio-bv.nl> To: rbase-l <rbase-l@googlegroups.com> Sent: Mon, May 22, 2017 1:14 pm Subject: RE: [RBASE-L] - Oddity when exporting a report to Excel Do you have tried to align using one of these: The middle one Tony Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Kayza Kleinman Verzonden: maandag 22 mei 2017 19:22 Aan: rbase-l@googlegroups.com Onderwerp: [RBASE-L] - Oddity when exporting a report to Excel I have a report that has one line per row of data. Nothing special or esoteric about it. I need to print this report to Excel, which has worked just fine till I made an edit to the report. I added a field to the report. Now, every few lines (and the number of lines is NOT consistent!) the last field shows up on the row below. What should be happening is: Item1Item2Item3Item4 Item1a Item2a Item3a Item4a What is happening every few lines is: Item1Item2Item3 Item4 Item1a Item2a Item3a Item4a This is creating some major problem. R:base v 9.5 Thanks for any insight. PS this shows up properly when I print to PDF or Word. When I print to Quattro, I get the blank lines, but I all of the items are on the same line. Kayza Kleinman Director of the Nonprofit Helpdesk CIO Jewish Community Council of Greater Coney Island, Inc 3001 West 37th Street Brooklyn NY 11224 718 449-5000 x 2266 fax 347-946-6411 www.jccgci.org www.nphd.org -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Oddity when exporting a report to Excel
Do you have tried to align using one of these: The middle one Tony Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Kayza Kleinman Verzonden: maandag 22 mei 2017 19:22 Aan: rbase-l@googlegroups.com Onderwerp: [RBASE-L] - Oddity when exporting a report to Excel I have a report that has one line per row of data. Nothing special or esoteric about it. I need to print this report to Excel, which has worked just fine till I made an edit to the report. I added a field to the report. Now, every few lines (and the number of lines is NOT consistent!) the last field shows up on the row below. What should be happening is: Item1Item2Item3Item4 Item1a Item2a Item3a Item4a What is happening every few lines is: Item1Item2Item3 Item4 Item1a Item2a Item3a Item4a This is creating some major problem. R:base v 9.5 Thanks for any insight. PS this shows up properly when I print to PDF or Word. When I print to Quattro, I get the blank lines, but I all of the items are on the same line. Kayza Kleinman Director of the Nonprofit Helpdesk CIO Jewish Community Council of Greater Coney Island, Inc 3001 West 37th Street Brooklyn NY 11224 718 449-5000 x 2266 fax 347-946-6411 <http://www.jccgci.org/> www.jccgci.org <http://www.nphd.org/> www.nphd.org -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.