Karen,
You don't need to have access to the full Rbase version.
If you browse a table then your are able to export the table to Excel.
This also can be done in a compiled environment.
The feature I like there is that you even don't need to have Excel
installed
Like this:
It is very fast and the produced spreadsheet is excellent
Tony
Op 29-12-2020 om 22:24 schreef 'Karen Tellef' via RBASE-L:
Yes exactly, the numbers are coming to Excel as text. When you select
the "print to file / Excel" (3 excel options) in each case a dialog
box comes up with a few options you can select, but none of them are
anything like "keep numbers as numbers". Perhaps there is such an
option in the Gateway Export utility, but I was asked about the print
preview option to go to Excel since they don't have access to the full
RBase version.
Karen
-----Original Message-----
From: [email protected]
To: [email protected]
Sent: Tue, Dec 29, 2020 3:08 pm
Subject: RE: [RBASE-L] - Report output to Excel - FOUND IT!
If I understand correctly, you have number columns/variables in R:base
that are coming to Excel as text? Is there a feature to keep the type,
i.e. keep them as number so you do not have to make the conversion in
Excel? I seem to recall an option to do this but maybe it is in the
EXPORT utility rather than reports. L
Javier,
Javier Valencia, PE
[email protected]
O: 913-829-0888
C: 913-915-3137
*From:*'Karen Tellef' via RBASE-L [mailto:[email protected]]
*Sent:* Tuesday, December 29, 2020 9:30 AM
*To:* [email protected]
*Subject:* Re: [RBASE-L] - Report output to Excel - FOUND IT!
Tony mentioned those little green markers and that rang a bell! That
used to annoy me seeing those things so I turned that option off! I
turned the option back on, I get the green markers, and can do the
convert and my sum works fine!!!
In case anyone wants to know how to turn those markers on/off, you
pick "file / options", Formulas tab:
Karen
-----Original Message-----
From: 'Karen Tellef' via RBASE-L <[email protected]>
To: [email protected] <[email protected]>
Sent: Tue, Dec 29, 2020 9:24 am
Subject: Re: [RBASE-L] - Report output to Excel
Tony: I've seen those green markers before, but in this case (I'll
repeat my print-screen here) for some reason there is no green marker
on these cells. Yet my =SUM still isn't working.
Here's my sum below:
If I type a "2" over one of those 1s, the sum shows 2:
Karen
-----Original Message-----
From: Tony IJntema <[email protected]>
To: [email protected]
Sent: Tue, Dec 29, 2020 9:15 am
Subject: Re: [RBASE-L] - Report output to Excel
Karen,
You can do it this way:
Select all figures you like to convert (the green marker up left is
showing that the number is stored as text)
Select the exclamation mark and then a right mouse click
You should see the menu as below (sorry in Dutch)
The second option is convert to number.
Hope this helps.
Tony
Op 29-12-2020 om 15:35 schreef apstock:
Karen,
Highlight the cell you want to convert to numbers. To the left of
the top most cell there will be an excel symbol which one can
select to change the formatting of the highlighted cell.
On 12/29/2020 9:19 AM, 'Karen Tellef' via RBASE-L wrote:
Steve: can you do a print-screen of that? I've highlighted the
numbers and cannot find the option box that you're talking
about (perhaps we're on different versions). Since the list
allows pics now, post the print-screen to the list in case
someone else can use this very helpful tip!
Karen
-----Original Message-----
From: Steve Johnson <[email protected]>
<mailto:[email protected]>
To: [email protected] <mailto:[email protected]>
Sent: Mon, Dec 28, 2020 8:28 pm
Subject: RE: [RBASE-L] - Report output to Excel
Karen,
You have to convert the column numbers displayed (which are in
text format) to numbers. Formatting the cells using the format
option does not work.
Highlight the range of column cells (not the header) and to
the left of the top cell in the option box, (looks like a
small diamond with an ! point), choose convert to number and
it will work. I have monthly reports where I have to do the
same thing.
One thing to note, if your spreadsheet is more than one page
and the columns shift, particularly on a subsequent page,
tinker with the report object placement for the range of cells
that moved. I also usually have blank rows of cells from the
page break that have to be trimmed off using ‘delete row
cells’ in Excel. Then the columns are contiguous and then I
convert (or the staff does) the range of cells within a column
to a number so they can use the =sum formula as needed.
Steve Johnson
*From:*'Karen Tellef' via RBASE-L
[mailto:[email protected]
<mailto:[email protected]>]
*Sent:* Monday, December 28, 2020 5:45 PM
*To:* [email protected] <mailto:[email protected]>
*Subject:* [RBASE-L] - Report output to Excel
Haven't played around with this in a while, but someone
requested instructions.
If I have a report to the screen and do a "print to file"
picking Excel (either 2003 or xlsx), it formats pretty well.
If I bring up Excel and want to insert a sum by using the
=SUM(....) it shows up as 0. If I do each individually as a
cell (such as: +A1+A2+A3) then it adds up the numbers, but not
when I do a =SUM. Obviously using the + isn't good if I want
to add up hundreds of lines. Is this an Excel issue? I
tried a couple things:
1. I left my =SUM in the spreadsheet. If I type over any of
the numbers, my sum works (but only on the numbers that I
typed over)
2. If I highlight some of the column of numbers and "format
cells" and change it, it doesn't work. For example, I had a
column of integers and did a "format cells" to change it to a
number with 2 decimals, and it leaves the column untouched.
Other individual calculations work (such as +B1/A1) just not
the =SUM.
Anyone getting that to work?
Karen
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/397078517.3912595.1609195474881%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/397078517.3912595.1609195474881%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/005201d6dd8a%24581e3b90%24085ab2b0%24%40sprintmail.com
<https://groups.google.com/d/msgid/rbase-l/005201d6dd8a%24581e3b90%24085ab2b0%24%40sprintmail.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/670373004.4031006.1609251582146%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/670373004.4031006.1609251582146%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/a9c3a281-da4a-970f-fe8f-d69e65176350%40sbcglobal.net
<https://groups.google.com/d/msgid/rbase-l/a9c3a281-da4a-970f-fe8f-d69e65176350%40sbcglobal.net?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/56170e10-f6d9-357a-5e35-77256203ec0f%40cio-bv.nl
<https://groups.google.com/d/msgid/rbase-l/56170e10-f6d9-357a-5e35-77256203ec0f%40cio-bv.nl?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/500400194.4056033.1609255443325%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/500400194.4056033.1609255443325%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/827918818.4050337.1609255827317%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/827918818.4050337.1609255827317%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAMSsZZPN63JEl67ds0M9eGEBAAAAAA%3D%3D%40vtgonline.com
<https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAMSsZZPN63JEl67ds0M9eGEBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/86766185.4155887.1609277048839%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/86766185.4155887.1609277048839%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/a8d2c4e9-de8d-1a28-7278-d300a844ffd7%40cio-bv.nl.
