Add labels to HTML spreadsheet

5 pts.
Tags:
HTML
Spreadsheets
I am trying to add labels and would like to save the counting numbers. How do I perform this task? for example: I am starting off with a four digit # say 6700in cell a-5,How do I perform this task easily with 10 counting numbers in a column going down? Making the next number 6701 then 6702, etc.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Are you trying to build this HTML page dynamically? Where is your data coming from? OR are you just looking to increment the cell value until you reach a desired limit of new cells?
    113,580 pointsBadges:
    report
  • carlosdl
    What spreadsheet software are you using?  How is the situation related to HTML?
    84,535 pointsBadges:
    report
  • TheRealRaven
    Have you read instructions that come with the product? That's where you should learn how to use it. Seriously, if answers are given for "How do I do x with product y" questions, there would never be questions that actually fit the 'advertised' purpose of this forum.
    28,365 pointsBadges:
    report
  • carlosdl
    Raven, what is the part of the advertised purpose of the site that makes questions about doing something with some product don't fit?

    Databases, programming languages implementations, IDEs, networking devices, operating systems, etc...  All of them are products.

    Did I misunderstand your point?

    84,535 pointsBadges:
    report
  • TheRealRaven
    Carlosdl, databases are documented as products. A question like "How do I select rows with only this customer number?" are qualitatively different from "I have this SELECT statement: SELECT amt FROM mytable WHERE cusno ='12345' but I get this error: SQL1234. What am I doing wrong?"

    In the first case, an understanding of the purpose of documentation leads to reading about clauses of a SELECT statement. The purpose of a WHERE clause should at least lead to experimentation, perhaps until something seems to contradict documented behavior.

    In the second case, product documentation is less useful. Now there is a demonstrable "problem" where the eyes and experiences of other IT professionals can help. Obviously my example is trivial and contrived, yet it can represent a real problem that interrupts a developer's workflow.

    Perhaps it's something as invisible to the developer as an improper use of quote marks, or maybe quotes are valid but the actual cusno is '012345' because it's a CHAR(6) data item, or maybe...?

    In any case, straight documentation is less useful. The problem becomes at least one step beyond it due to some detail that may be obscured by an implementation or by the unexpected presence of some secondary element.

    And the second case even includes an example along with the problem that needs a solution.

    In this thread, there isn't enough even to grasp if a problem exists. What is a "label" in this context? What are "counting numbers"? (They might make some sense, but in what way?) What is the intended relationship between "HTML" and "spreadsheet"? Certainly it's not quite a HTML table.

    For what seems to be asked, we're probably actually looking at Javascript rather than HTML at the least, or maybe an embedded <object> of MIME type "vnd.oasis.opendocument.spreadsheet" or related. If Javascript, then is the expectation of pure, complete coding to emulate a spreadsheet? Or is about some framework feature such as a Dojo spreadsheet?

    If we're into something like Dojo, then... what? Mobservable? Omniscient? Ractive.js? Deku? One of the dozens of other frameworks?

    I mean, for the implied question of "How do you make a spreadsheet with HTML?", the direct answer is "You don't."

    You can display tables with HTML. If you want certain numbers in certain cells, e.g., 6700 in column 1 row 5, you simply code 6700 as the content of that cell. But you don't have a HTML 'formula' that increments and displays new values in subsequent cells. You need something much more than just HTML, e.g., Javascript.

    And a 'label' in HTML? Well, use a <label> tag. Except that doesn't seem to be what the question is asking for. Without at least a reference to an example, what answers are possible?

    Look at the "answers" so far. After six days, is there anything remotely useful? (That is, other than what you tried in your comment.)

    At the top of each of these pages, there are two general areas where members may post 'questions' -- 'Questions & Answers' and 'Discussions' (ignoring blog comments). Differentiating between the two, 'Discussion' generally won't have "answers". They'll have opinions, conversations, ideas, concepts. But 'Questions & Answers' implies that an actual "answer" should exist, factual.

    And the site FAQ gives a site mission that directs it towards "IT professionals". We shouldn't have major difficulty in recognizing a question from an "IT professional". It first should fit in the proper part of the site. An "IT pro" should be able to read a FAQ and recognize page elements. It second shouldn't require a lengthy tutorial just to clarify what question is being asked. It third should indicate that basic research was done. If you can copy/paste the exact question, or subject, into a Google search box and get the answer, it's obvious that there was no research at all.

    So, if this is intended to be for "IT professionals", what questions make sense? They will indeed be about a "product" of some kind, but they should make sense to some other "IT professional".

    It should be clear what "product" is involved. It should be a question that isn't about a fundamental element of a product because a professional can find the answer faster just by looking at a table of contents or an index, faster than typing the question and waiting for someone else to be a research assistant.

    A professional should have already looked at the appropriate documentation. If the documentation was unclear, that should be noted in the question. The answer shouldn't need to be just a copy/paste of the documentation text, because if it wasn't clear to the OP at first reading, there's no reason to think it'll be any more clear when copied (or paraphrased) here. A question about documentation clarity seems valid, but the question should say exactly what needs additional explanation or example.

    In the few months I've been watching this forum, I feeel like I've seen as many spam or otherwise frivolous questions (e.g., "I'm all alone") as I've seen questions truly from IT pros that need answers. The vast majority have no evident "professionalism" at all. (How do I hack my college network? What is residual magnetism? How do I design a data center?)

    Sure, a data center design or provisioning an enterprise network are problems a professional will encounter. But this forum can't do the work for free. The forum can't become a way to avoid hiring someone to do the work. That's not how to treat our "peers". If a network needs to be built, then a network engineer needs to be hired. Such questions should be rejected out of hand, ideally ny a moderator.

    Except there doesn't seem to be much moderation. Any question at all seems to be allowed. It's not clear at all how (or if) the 'Vote to Delete' icon works. If it works, maybe most members don't know it exists. It's hard enough to see to make that plausible. Or maybe almost no members care. Or maybe there just aren't enough.

    That last wouldn't be surprise. When so many questions are like "my phone dont work. why?", it's easy to see why so few "IT pros" even try to answer. They're all at other forums that actually strive for good content.

    Other than those in this thread, there might be less than half a dozen others who've given quality answers so far this year. You, Carlosdl, clearly are the top Oracle guy willing to answer. At times, I've thought ToddN2000 has also been just a little frustrated at the questions and question themes that show up over and over. (More questions that demonstrate unwillingness even to search earlier in this forum. Unwillingness to search motivates my unwillingness to answer.)

    So, the part that doesn't fit about "doing X with product Y" is any part that is fundamental. It's any part that is covered in any basic tutorial about the product or that comes from any initial training. Making a particular recursive SQL feature work is not quite like finding the oldest transaction. I haven't seen any "IT pro" grasp recursive SQL intuitively, but the MAX() and MIN() functions are certainly in a different class.

    The functions are fairly easily grasped just by visually scanning the list of DBMS functions. I wouldn't expect an "IT pro" even to ask about them, and I wouldn't expect them to be asked about here. (Though even simple functions can be confusing when used in CASE() structures in a variable ORDER BY clause. For such a question to be reasonable, I'd expect to see a possible SELECT along with sample input and desired results.)

    I wouldn't expect "How do I find the heaviest item with SQL?"

    In short, it should be a professional question in a forum for professionals. Otherwise this is just another "Ask Yahoo!" forum and not worth any effort.
    28,365 pointsBadges:
    report
  • ToddN2000
    Beaben, post the code you have tried and let us take a look. It may help clear up some our confusion. Also if you have any errors when trying to execute the code.
    113,580 pointsBadges:
    report
  • carlosdl
    Thanks for your detailed response, Raven.

    I totally agree with you, and just in case some clarification is needed, I was not saying that this particular question is a good one. It is definitely not.

    I just felt that the comment about questions like "How do I do x with product y" not being a good fit for the site was a little too radical, but after reading your explanation I can tell you that in general I feel the same way.

    Will bring your views to Michael's attention. This is not the first time that someone expresses this kind of feeling about the identity of the site.
    84,535 pointsBadges:
    report

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.

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

Following

Share this item with your network: