Hi,
    I have created an xl sheet. Value of few cells are being calculated as per a formula. I am not getting the value of formula (cell.getFormula()) that I have set using cell.setFormula() method.
e.g.
Formula being set '=IW39'
formula of cell I am getting is '=A39'

Please let me know if I am making some mistake while setting the formula or there is smoe other problem?

Thanks,
Vimlesh

Hi,

Thanks for providing us details.

Actually by default the formulas are set in Excel (97-2003) formats where we cannot provide reference to the columns (in the formula) greater than 256th (i.e. greater than IV column) column.

We have logged your issue into our issue tracking system with an issue id: CELLSJAVA-14256. We will let you know when it figured out.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Thanks for quick reply.
    As per reply the formulas are set in Excel(97-2003) formats where we cannot provide reference to the columns (in the formula) greater than 256th (i.e. greater than IV column) column. But what about the reference 'ABQ11' and others? This column is also greater than 256. But it is being set properly.

Thanks,
Vimlesh

Hi,
Is there any workaround for this problem ? Can we have source code so that we can do something as this is creating a serious problem at our end for generating excel in 2007 format.
Thanks.

Hi,

Yes, we found the issue and already logged into our issue tracking system with an issue id: CELLSJAVA-14256. We will try to provide the fix asap.

 "Is there any workaround for this problem ? Can we have source code so that we can do something as this is creating a serious problem at our end for generating excel in 2007 format."

Well, I am afraid we cannot provide the source code as it is against our internal policies. Anyways, we appreciate your understanding, we will figure out your issue soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,
Can we have information by when would you be able to update us on the same?
Thanks,
Vimlesh

Hi,

We will check if we can provide you an eta for your issue.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

After analyzing the feature we conclude it will take at least 2 months time to incorporate the feature in the product. There are two possible reasons for it:
1) It is a complex feature which would take some time to be implemented.
2) There are already some other important tasks (on hand) to be supported.

Thanks for your understanding!

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Provide us some patch stuffs for this, we are losing lot of business for this feature. Its really urgent for me.

Hi,

OK, we have put your feature in our top priority list.

We will try to provide the supported version in the start of next month now.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,
   Can we have your contact number and reference number for this conversation?

Thanks,
Vimlesh

Hi Vimlesh,

I have afraid, you need to use forums or live chat only to contact us, we don't provide telephonic technical support at the moment. Our forum support is fast enough that you can reply on it. If you have any problem/issue or need some help for anything, you can post us a query or live chat with us, we will help you instantaneously.

For your case, as we have already told you we will try to provide the supported version (for your requirement) in the first half of next month.

Thanks for your understanding!

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Aspose support team, It's mid-March and we are waiting for a fix.

Hi,

 

We are working on your issue but I am afraid it is a complex issue and we cannot provide a fix in 1 ~ 2 day’s time. We will hopefully provide a fix for it in the next week.

 

Thank you for understanding,

---

Nausherwan Aslam
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,
    As per your commitment to provide the fix for the same, we had planned our release date on Wednesday 24th March. For that we need the fix today or by tomorrow. Please provide the fix asap.

Thanks,