1
  • Formatting a spreadsheet row with color

    Hello, I would like to know if there is a way to color (shade in) a row when one specific cell has a value in it. For instance if I am entering in data and column I is for refunds, when that I blank I don't want the row to be shaded, but if there is an amount in that column I want that row to be...

    Skeet9005 pointsBadges:
  • A new kind of inheritance in programming languages?

    Hi, I may have invented a new kind of inheritance in programming languages, I called it "deep inheritance". Suppose that Companies have Employees. Now Suppose that there are two kinds of Companies: privately held companies and publicly traded companies. Now, the employees from publicly traded...

    nreyntje5 pointsBadges:
  • Export from SAP to Spreadheet

    How would one going about exporting a report (ZREP_EXPEDITE)in SAP to a certain spreadsheet that you built.

    Dfarris15 pointsBadges:
  • Read/Write Excel spreadsheet in Forms6i but no excel

    Hi!  I'd like to know if I there's a way to read/write a spreadsheet without to install Excel. I'm working en Forms 6i and I'm performing a programmed task, so a file csv doesnt' work for me, the application must access and generate the Excel file automatically.  Please, help me. Regards, thanks...

    PaolaChile35 pointsBadges:
  • How to make excel rows/columns writable by only specific people

    I have two users working on the same spreadsheet, both should be able to write to only their specific part of spreadsheet, i.e. user2 should not be able to overwrite what user1 has previously entered. I know NTFS permissions, will operate on the file level, but I guess I'm looking to restrict it to...

    Pandub130 pointsBadges:
  • Is there an attribute assigned to a spreadsheet that identifies that a Macro was created and can this be reset?

    With the Macro security set at medium, if a Macro was ever created for a spreadsheet, you are prompted whether or not to Enable or Disable MACROS. If a MACRO was never created in the spreadsheet, you are not prompted at Medium security. If you delete all the MACROS from the spreadsheet and save the...

    MEH5 pointsBadges:
  • SpinButton linking to an occupied cell

    Can a spin button be linked to the cell that it is located in? I have about 100 spin buttons that I need in this sheet and don't want to individually link each one! Thanks!

    Sleibbra245 pointsBadges:
  • Export adding .00

    When I export a table into a spreadsheet my id fields now add a .00 to the end of the number. They don't appear this way in the actual table though. How can I prevent them from exporting this way?

    Accessneve5 pointsBadges:
  • Match a date to a number

    I have a list of dates (A) on the left inside next to each date i have numbers (B). I have another list of dates (C) which is shorter with the same dates. I'm trying to match the numbers to dates (C) based on the first dates (A). 1 0.6 10/20/08 10/20/08 2 1 10/21/08 10/21/08 3 0.65 10/22/08...

    Cubemonkey5 pointsBadges:
  • Copying a portion

    how can a copy just the last character from one cell to another?

    Richccac5 pointsBadges:
  • How would you calculate, using the spreadsheets statistical functions, the cheapest option at the fastest speed with the least downtime?

    i have 5 tables each including speed, price, download limit, average downtime and the average uptime. i was asked by my teacher to calculate all these so i get one number, to find out which is the best value for money for someone to go for. i just need to know what do i calcute to what to get my...

    Moron125 pointsBadges:
  • adding text to function results

    I am using a count function to create a total number (COUNTA(A1-A400) I want to add some test to display with the results so it reads 350 units. I have tried to nest the TEXT command but get an error

    Carourke15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following