Spreadsheets

How can we improve Spreadsheets?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Spread for ASP.NET needs a pivot function

    Spread for ASP.NET needs a pivot function.

    Not all databases support a pivot function for a 2D chart.

    1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
    • when fill large amount of fumula in sheet, the add/remove row will cost large amount of time

      var spread = new GcSpread.Sheets.Spread(document.getElementById('ss'), { sheetCount: 1 });
      var sheet = spread.getActiveSheet();

      sheet.setRowCount(2005);

      sheet.isPaintSuspended(true);
      sheet.suspendEvent();
      sheet.suspendCalcService();

      for (var i = 1; i < 2000; i++) {
      for (var j = 1; j < 21;j++) {
      sheet.setFormula(i, j, 'A1+A'+ (i + 1) + '+' + String.fromCharCode(j + 65) + '1');
      }
      }

      sheet.resumeCalcService();
      sheet.resumeEvent();
      sheet.isPaintSuspended(false);

      then:

      var spread = new GcSpread.Sheets.Spread(document.getElementById('ss'), { sheetCount: 1 });
      var sheet = spread.getActiveSheet();

      sheet.setRowCount(2005);

      sheet.isPaintSuspended(true);
      sheet.suspendEvent();
      sheet.suspendCalcService();

      for (var i = 1; i < 2000; i++) {
      for (var j = 1; j < 21;j++) {
      sheet.setFormula(i, j, 'A1+A'+ (i + 1) + '+'…

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
      • Unminified angular.gc.spread.sheets.10.0.0.js

        I am trying to understand all of the settings that can be specified via html when using angular. I dont know if the angular documentation is complete. Version 9 directive was unminified. Can we get a copy of the unminified directives for 10? I have a license for the production version.

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
        • add charts to spreadjs

          Please add charts to spreadJS. Not sparklines, but actual charts. That are import/export compatible with Excel.

          3 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
          • After upgrade to win 10 - Spread does not display page

            I upgraded to win10, after seeing that the product does problems, I rolled back the OS to Windows 7.
            But now in VB - has a problems. - some of the ActiveX needed registration again
            The main problems is that the preview page does not display info
            I know the info is there
            I am using fpSPR80.ocx COM version 8.00.06
            OS is win 7 ultimate
            Any suggestions?

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
            • Better development response on Spread COM

              Can you look into a way to boost your Spread COM development department?

              I would be willing to subscribe to a software subsciption, for better maintenance (as I think many others do to).
              Of course one cannot ask the purchase fee, but a 10% annual fee is not much for a royalty free control!!!

              2 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
              • SpreadJS snapshot of sheet range

                Something like:

                var instance = new GcSpread.Sheets.Sheet("sheet1");

                var value = instance.getSnapshot(startRow,
                startColumn,
                endRow,
                endColumn);

                value.toBase64();// get base64

                2 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                • Support wordWrap in HyperLinkCellType - spreadjs

                  I'd like to use word wrapping into an HyperLinkCellType but currently is not supported. Microsoft Excel support that behavior.

                  3 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                  • add AllowWrap propertie in the MultiColumCellType like in ComboboxCellType

                    Is it possible tu add AllowWrap propertie in the MultiColumCellType like in ComboboxCellType?

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                    • SpreadJS unresponsive after select all cells and align text

                      After selecting all cells in a SpreadJS sheet and aligning the text or changing the font causes the page to become unresponsive.

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  Admin →
                      • Can we have a spell checker feature similar to MS Excel

                        I want to spell check a range of cell for any typing mistakes for this it would be better if we have a spell check features.

                        1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                        • Formula Text box connecting to mutliple spread objects.

                          As a wish list, would be possible, in the future, to connect the FormulaTextBox to multiple fpSpread objects, to achieve the formula editing functionality for cross-spreads (e.g. while in edit in spread 1, click on a cell in spread2 and a reference is added to the formula in-edit in spread1)
                          See
                          http://our.componentone.com/groups/topic/cell-formula-referencing-a-different-spreadsheet/#post-657393

                          Thanks

                          Jerry

                          Thanks

                          J

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                          • Adding an autofilter row

                            If enabled you see an additional row (row zero) where you can set up filters for each type of column.
                            The type of filter cell can be different from the type of all the data cells of the column. You filter text cells with substring filter, date cells with "<" ">" + date in date format with "/" separators, numeric cells with "<" ">" + number and so on.

                            The row zero for filtering is obviously frozen and non affected by sorting. If you have it all the row numbers in the row header (col zero) must be "real row…

                            4 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                            • Spread for Windows Forms: Translate text

                              If any english strings are exposed to the user they should be made available to translate in the app using Spread.
                              My customers mainly speech german. English texts may deter them from using certain functionality if the don't know the exact meaning.

                              4 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                              • JavaScript runtime error: 'FpSpreadJS' is undefined

                                JavaScript runtime error: 'FpSpreadJS' is undefined

                                4 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                • Define the contextmenu for a column or a cell

                                  see on attached files if it's possible with the actual version.

                                  The simpliest is to get the context menu when right-clicking an image button.

                                  2 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                  • Undo in Spread 8

                                    Undo feature is a much wanted missing feature.

                                    7 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                    • More powerfull editor for edit cells

                                      The current editor provided with Spread 8 is very limited. I would like to see more options and features like auto height change according to text entered (now we have to do it with code)

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                      • Don't see your idea?

                                      Spreadsheets

                                      Feedback and Knowledge Base